PREVIEW / etf_1hour / 2020-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-08.parquet
  size:    370 KB
  rows:    12,040

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2020-01-08 04:00:00	SPY	ETF	322.08	322.44	322.03	322.42	72421.0
2020-01-08 05:00:00	SPY	ETF	322.3	323.33	322.2	323.21	99821.0
2020-01-08 06:00:00	SPY	ETF	323.26	323.65	323.0	323.12	315455.0
2020-01-08 07:00:00	SPY	ETF	323.09	323.46	322.91	323.35	593249.0
2020-01-08 08:00:00	SPY	ETF	323.31	323.68	320.89	323.03	941337.0
2020-01-08 09:00:00	SPY	ETF	323.03	323.85	322.67	323.71	4605297.0
2020-01-08 10:00:00	SPY	ETF	323.73	323.98	322.88	323.295	5880968.0
2020-01-08 11:00:00	SPY	ETF	323.31	325.22	323.1	324.81	11681284.0
2020-01-08 12:00:00	SPY	ETF	324.81	325.0799	324.71	324.89	4365499.0
2020-01-08 13:00:00	SPY	ETF	324.89	324.97	324.56	324.61	4128054.0
2020-01-08 14:00:00	SPY	ETF	324.63	325.26	324.63	325.25	6033604.0
2020-01-08 15:00:00	SPY	ETF	325.255	325.78	324.23	324.42	20147408.0
2020-01-08 16:00:00	SPY	ETF	324.41	325.14	322.7855	324.97	7970188.0
2020-01-08 17:00:00	SPY	ETF	324.99	325.15	324.96	325.08	218142.0
2020-01-08 18:00:00	SPY	ETF	325.07	325.45	324.95	325.2	177424.0
2020-01-08 19:00:00	SPY	ETF	325.22	325.52	324.93	325.36	57798.0
2020-01-08 20:00:00	SPY	ETF	325.37	325.37	325.37	325.37	300.0
2020-01-08 04:00:00	QQQ	ETF	214.78	215.09	214.72	214.94	117016.0
2020-01-08 05:00:00	QQQ	ETF	214.88	215.78	214.88	215.61	32225.0
2020-01-08 06:00:00	QQQ	ETF	215.58	215.98	215.46	215.63	92633.0
2020-01-08 07:00:00	QQQ	ETF	215.64	215.94	215.5	215.8	370732.0
2020-01-08 08:00:00	QQQ	ETF	215.59	216.14	214.06	215.63	547115.0
2020-01-08 09:00:00	QQQ	ETF	215.63	216.32	215.16	216.17	2569724.0
2020-01-08 10:00:00	QQQ	ETF	216.22	216.36	215.39	215.7307	2375670.0
2020-01-08 11:00:00	QQQ	ETF	215.74	217.33	215.51	217.05	4263434.0
2020-01-08 12:00:00	QQQ	ETF	217.05	217.4905	217.03	217.3884	1465638.0
2020-01-08 13:00:00	QQQ	ETF	217.38	217.49	217.16	217.22	1229861.0
2020-01-08 14:00:00	QQQ	ETF	217.23	217.6087	217.225	217.6	1359248.0
2020-01-08 15:00:00	QQQ	ETF	217.6	218.14	216.97	217.11	6290349.0
2020-01-08 16:00:00	QQQ	ETF	217.13	217.67	217.05	217.53	1521772.0
2020-01-08 17:00:00	QQQ	ETF	217.55	217.62	217.4	217.5	23222.0
2020-01-08 18:00:00	QQQ	ETF	217.52	217.9	217.45	217.66	45300.0
2020-01-08 19:00:00	QQQ	ETF	217.64	217.94	217.56	217.75	36654.0
2020-01-08 04:00:00	IWM	ETF	164.37	164.53	164.36	164.5	12586.0
2020-01-08 05:00:00	IWM	ETF	164.46	165.0	164.45	165.0	11075.0
2020-01-08 06:00:00	IWM	ETF	164.92	165.13	164.91	164.97	27097.0
2020-01-08 07:00:00	IWM	ETF	164.92	165.1	164.82	165.01	44455.0
2020-01-08 08:00:00	IWM	ETF	164.9401	165.13	164.17	164.89	340819.0
2020-01-08 09:00:00	IWM	ETF	164.97	165.985	164.72	165.8	1546307.0
2020-01-08 10:00:00	IWM	ETF	165.81	165.98	164.82	165.1101	1614547.0
2020-01-08 11:00:00	IWM	ETF	165.11	165.91	164.96	165.573	1786168.0
2020-01-08 12:00:00	IWM	ETF	165.6	165.81	165.405	165.72	1038198.0
2020-01-08 13:00:00	IWM	ETF	165.72	165.77	165.48	165.51	703429.0
2020-01-08 14:00:00	IWM	ETF	165.51	165.845	165.51	165.83	629250.0
2020-01-08 15:00:00	IWM	ETF	165.84	166.025	165.27	165.41	2901055.0
2020-01-08 16:00:00	IWM	ETF	165.41	165.74	165.31	165.64	701111.0
2020-01-08 17:00:00	IWM	ETF	165.54	165.69	165.31	165.31	6490.0
2020-01-08 18:00:00	IWM	ETF	165.63	165.85	165.6	165.71	22795.0
2020-01-08 19:00:00	IWM	ETF	165.71	165.85	165.66	165.75	2337.0
2020-01-08 04:00:00	DIA	ETF	284.49	284.73	284.49	284.73	2447.0

> showing 50 of 12,040 rows — these rows as CSV

> unlock the full archive -- $79 one-time