PREVIEW / etf_1hour / 2019-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-20.parquet
  size:    345 KB
  rows:    11,433

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-06-20 04:00:00	SPY	ETF	295.02	295.68	295.02	295.59	37761.0
2019-06-20 05:00:00	SPY	ETF	295.61	295.99	295.61	295.94	19741.0
2019-06-20 06:00:00	SPY	ETF	295.94	295.94	295.7	295.7	97168.0
2019-06-20 07:00:00	SPY	ETF	295.67	296.18	295.66	296.05	428045.0
2019-06-20 08:00:00	SPY	ETF	295.96	296.44	294.47	296.21	884284.0
2019-06-20 09:00:00	SPY	ETF	296.22	296.35	295.62	295.84	11235668.0
2019-06-20 10:00:00	SPY	ETF	295.85	296.11	293.1255	294.99	17133585.0
2019-06-20 11:00:00	SPY	ETF	294.99	295.28	294.59	294.97	9408994.0
2019-06-20 12:00:00	SPY	ETF	295.0	295.02	293.61	294.65	9287467.0
2019-06-20 13:00:00	SPY	ETF	294.65	295.27	294.57	295.0	5342545.0
2019-06-20 14:00:00	SPY	ETF	295.0	295.57	294.91	295.5	8525166.0
2019-06-20 15:00:00	SPY	ETF	295.51	296.3093	295.22	295.84	24954265.0
2019-06-20 16:00:00	SPY	ETF	295.84	296.09	295.67	295.78	27078704.0
2019-06-20 17:00:00	SPY	ETF	295.76	295.86	295.73	295.75	213355.0
2019-06-20 18:00:00	SPY	ETF	295.71	295.75	294.8	295.61	822472.0
2019-06-20 19:00:00	SPY	ETF	295.56	295.78	295.44	295.68	45968.0
2019-06-20 04:00:00	QQQ	ETF	189.16	189.55	189.08	189.51	34880.0
2019-06-20 05:00:00	QQQ	ETF	189.46	189.77	189.46	189.59	27970.0
2019-06-20 06:00:00	QQQ	ETF	189.59	189.72	189.5	189.59	28718.0
2019-06-20 07:00:00	QQQ	ETF	189.5	189.85	189.48	189.67	156152.0
2019-06-20 08:00:00	QQQ	ETF	189.54	190.19	187.11	189.96	548213.0
2019-06-20 09:00:00	QQQ	ETF	189.98	190.13	189.08	189.46	5722816.0
2019-06-20 10:00:00	QQQ	ETF	189.47	189.64	188.58	188.615	4629821.0
2019-06-20 11:00:00	QQQ	ETF	188.62	188.95	188.2	188.5693	3607705.0
2019-06-20 12:00:00	QQQ	ETF	188.58	188.61	187.4401	188.155	3694203.0
2019-06-20 13:00:00	QQQ	ETF	188.16	188.5599	188.08	188.26	1860442.0
2019-06-20 14:00:00	QQQ	ETF	188.25	188.545	188.1501	188.49	1844129.0
2019-06-20 15:00:00	QQQ	ETF	188.49	189.13	188.23	188.82	6462627.0
2019-06-20 16:00:00	QQQ	ETF	188.82	189.17	188.77	188.78	2697265.0
2019-06-20 17:00:00	QQQ	ETF	188.8	188.83	188.76	188.77	9987.0
2019-06-20 18:00:00	QQQ	ETF	188.77	188.77	188.66	188.69	36111.0
2019-06-20 19:00:00	QQQ	ETF	188.66	188.9	188.61	188.8	56443.0
2019-06-20 04:00:00	IWM	ETF	155.47	155.85	155.47	155.85	1600.0
2019-06-20 05:00:00	IWM	ETF	155.81	155.97	155.81	155.97	5200.0
2019-06-20 06:00:00	IWM	ETF	155.85	155.85	155.79	155.8	2748.0
2019-06-20 07:00:00	IWM	ETF	155.8	156.05	155.8	156.05	58657.0
2019-06-20 08:00:00	IWM	ETF	156.0	156.17	155.37	156.12	34385.0
2019-06-20 09:00:00	IWM	ETF	156.14	156.25	155.44	155.8601	2522232.0
2019-06-20 10:00:00	IWM	ETF	155.88	156.145	155.16	155.18	3224599.0
2019-06-20 11:00:00	IWM	ETF	155.2	155.37	154.93	155.21	1377597.0
2019-06-20 12:00:00	IWM	ETF	155.22	155.275	154.44	155.11	1953580.0
2019-06-20 13:00:00	IWM	ETF	155.14	155.36	155.07	155.24	806318.0
2019-06-20 14:00:00	IWM	ETF	155.23	155.44	155.15	155.3265	880223.0
2019-06-20 15:00:00	IWM	ETF	155.3385	155.47	155.155	155.29	2844391.0
2019-06-20 16:00:00	IWM	ETF	155.28	155.38	155.14	155.21	1215540.0
2019-06-20 17:00:00	IWM	ETF	155.15	155.15	155.15	155.15	800.0
2019-06-20 18:00:00	IWM	ETF	155.14	155.14	155.13	155.13	628.0
2019-06-20 19:00:00	IWM	ETF	155.02	155.05	155.02	155.05	1000.0
2019-06-20 04:00:00	DIA	ETF	267.12	267.8	267.12	267.8	500.0
2019-06-20 05:00:00	DIA	ETF	267.84	267.86	267.84	267.86	1991.0

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

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