PREVIEW / etf_1hour / 2019-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-20.parquet
  size:    352 KB
  rows:    11,574

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
2019-12-20 04:00:00	SPY	ETF	319.7	319.7	319.33	319.36	21069.0
2019-12-20 05:00:00	SPY	ETF	319.35	319.57	319.34	319.57	23811.0
2019-12-20 06:00:00	SPY	ETF	319.57	319.7	319.53	319.58	33593.0
2019-12-20 07:00:00	SPY	ETF	319.6	319.75	319.46	319.72	93834.0
2019-12-20 08:00:00	SPY	ETF	319.6201	320.0	319.38	319.96	288466.0
2019-12-20 09:00:00	SPY	ETF	319.98	320.9	319.97	320.59	17497541.0
2019-12-20 10:00:00	SPY	ETF	320.59	321.9742	320.5	320.9	34698946.0
2019-12-20 11:00:00	SPY	ETF	320.9	321.37	320.88	321.155	10126337.0
2019-12-20 12:00:00	SPY	ETF	321.15	321.25	321.0	321.13	6781299.0
2019-12-20 13:00:00	SPY	ETF	321.13	321.27	321.06	321.0885	4085868.0
2019-12-20 14:00:00	SPY	ETF	321.09	321.9517	320.96	321.36	12006294.0
2019-12-20 15:00:00	SPY	ETF	321.36	321.37	320.84	320.95	19658167.0
2019-12-20 16:00:00	SPY	ETF	320.95	321.26	320.73	321.0	24187276.0
2019-12-20 17:00:00	SPY	ETF	321.01	321.14	320.73	321.12	3526358.0
2019-12-20 18:00:00	SPY	ETF	321.14	321.28	321.03	321.1	76621.0
2019-12-20 19:00:00	SPY	ETF	321.15	321.3	321.12	321.3	26701.0
2019-12-20 04:00:00	QQQ	ETF	210.8	210.96	210.8	210.87	36800.0
2019-12-20 05:00:00	QQQ	ETF	210.9	211.05	210.9	211.01	6431.0
2019-12-20 06:00:00	QQQ	ETF	211.09	211.26	211.09	211.12	14888.0
2019-12-20 07:00:00	QQQ	ETF	211.13	211.32	211.06	211.31	28643.0
2019-12-20 08:00:00	QQQ	ETF	211.13	211.55	210.85	211.5	212362.0
2019-12-20 09:00:00	QQQ	ETF	211.51	212.24	211.27	211.2902	5509497.0
2019-12-20 10:00:00	QQQ	ETF	211.31	211.71	211.3	211.6	2307665.0
2019-12-20 11:00:00	QQQ	ETF	211.59	211.92	211.585	211.78	2296189.0
2019-12-20 12:00:00	QQQ	ETF	211.77	211.95	211.74	211.89	1145703.0
2019-12-20 13:00:00	QQQ	ETF	211.885	212.05	211.88	211.93	1174704.0
2019-12-20 14:00:00	QQQ	ETF	211.9347	212.05	211.8089	212.0	1424017.0
2019-12-20 15:00:00	QQQ	ETF	212.0	212.01	211.49	211.77	4591241.0
2019-12-20 16:00:00	QQQ	ETF	211.75	212.02	211.66	211.92	1762369.0
2019-12-20 17:00:00	QQQ	ETF	211.92	211.92	211.71	211.9	943742.0
2019-12-20 18:00:00	QQQ	ETF	211.91	212.0	211.9	211.92	7112.0
2019-12-20 19:00:00	QQQ	ETF	211.92	212.02	211.91	212.02	12504.0
2019-12-20 05:00:00	IWM	ETF	165.65	165.83	165.65	165.83	9000.0
2019-12-20 06:00:00	IWM	ETF	165.88	165.89	165.83	165.88	12651.0
2019-12-20 07:00:00	IWM	ETF	165.88	165.95	165.77	165.95	5196.0
2019-12-20 08:00:00	IWM	ETF	165.7701	166.03	165.76	166.02	40407.0
2019-12-20 09:00:00	IWM	ETF	166.0	166.31	165.736	165.855	2280820.0
2019-12-20 10:00:00	IWM	ETF	165.85	166.25	165.72	166.25	1691888.0
2019-12-20 11:00:00	IWM	ETF	166.24	166.41	166.155	166.205	973947.0
2019-12-20 12:00:00	IWM	ETF	166.195	166.255	166.12	166.1366	650302.0
2019-12-20 13:00:00	IWM	ETF	166.13	166.14	166.01	166.07	1129972.0
2019-12-20 14:00:00	IWM	ETF	166.08	166.11	165.95	166.03	740390.0
2019-12-20 15:00:00	IWM	ETF	166.03	166.1	165.85	165.91	3571852.0
2019-12-20 16:00:00	IWM	ETF	165.9	166.21	165.81	165.81	2782605.0
2019-12-20 17:00:00	IWM	ETF	165.81	165.97	165.81	165.84	708120.0
2019-12-20 18:00:00	IWM	ETF	165.86	165.97	165.86	165.97	5252.0
2019-12-20 19:00:00	IWM	ETF	165.97	165.97	165.9	165.95	2420.0
2019-12-20 04:00:00	DIA	ETF	284.06	284.06	283.76	283.77	6720.0
2019-12-20 05:00:00	DIA	ETF	283.69	283.9	283.65	283.88	25200.0
2019-12-20 06:00:00	DIA	ETF	283.88	284.01	283.88	283.95	17200.0

> showing 50 of 11,574 rows — these rows as CSV

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