PREVIEW / etf_1hour / 2019-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-05.parquet
  size:    316 KB
  rows:    10,611

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-07-05 04:00:00	SPY	ETF	298.74	298.74	298.21	298.21	19187.0
2019-07-05 05:00:00	SPY	ETF	298.33	298.43	298.23	298.28	10351.0
2019-07-05 06:00:00	SPY	ETF	298.23	298.46	298.23	298.44	37880.0
2019-07-05 07:00:00	SPY	ETF	298.44	298.57	298.3	298.33	131629.0
2019-07-05 08:00:00	SPY	ETF	298.44	299.19	297.25	297.65	1476663.0
2019-07-05 09:00:00	SPY	ETF	297.59	297.63	296.66	296.69	6167215.0
2019-07-05 10:00:00	SPY	ETF	296.7	297.09	296.01	296.58	8842262.0
2019-07-05 11:00:00	SPY	ETF	296.6	297.16	296.39	297.16	4542096.0
2019-07-05 12:00:00	SPY	ETF	297.15	297.83	296.89	297.69	4234033.0
2019-07-05 13:00:00	SPY	ETF	297.69	298.19	297.49	298.025	3482881.0
2019-07-05 14:00:00	SPY	ETF	298.0284	298.6327	297.9	298.63	2628591.0
2019-07-05 15:00:00	SPY	ETF	298.62	298.64	297.7	298.36	11047511.0
2019-07-05 16:00:00	SPY	ETF	298.38	298.46	297.87	298.06	7409847.0
2019-07-05 17:00:00	SPY	ETF	298.01	298.46	297.91	298.09	697631.0
2019-07-05 18:00:00	SPY	ETF	298.46	298.46	298.07	298.12	10936.0
2019-07-05 19:00:00	SPY	ETF	298.1	298.15	298.05	298.14	17970.0
2019-07-05 04:00:00	QQQ	ETF	191.59	191.6	191.25	191.27	8700.0
2019-07-05 05:00:00	QQQ	ETF	191.21	191.33	191.09	191.09	10112.0
2019-07-05 06:00:00	QQQ	ETF	191.13	191.29	191.13	191.26	12187.0
2019-07-05 07:00:00	QQQ	ETF	191.26	191.33	191.15	191.17	77983.0
2019-07-05 08:00:00	QQQ	ETF	191.17	191.34	190.13	190.45	717607.0
2019-07-05 09:00:00	QQQ	ETF	190.42	190.45	189.6299	189.65	2465483.0
2019-07-05 10:00:00	QQQ	ETF	189.66	190.08	189.39	189.7	3774245.0
2019-07-05 11:00:00	QQQ	ETF	189.7	190.21	189.54	190.13	1713281.0
2019-07-05 12:00:00	QQQ	ETF	190.15	190.665	189.93	190.545	1271257.0
2019-07-05 13:00:00	QQQ	ETF	190.55	191.07	190.44	190.93	1495155.0
2019-07-05 14:00:00	QQQ	ETF	190.93	191.4	190.82	191.369	1223154.0
2019-07-05 15:00:00	QQQ	ETF	191.37	191.3899	190.7	191.1	3316087.0
2019-07-05 16:00:00	QQQ	ETF	191.1	191.12	190.4585	190.77	1898380.0
2019-07-05 17:00:00	QQQ	ETF	190.81	190.9	190.72	190.9	15437.0
2019-07-05 18:00:00	QQQ	ETF	190.94	190.94	190.9	190.9	887.0
2019-07-05 19:00:00	QQQ	ETF	190.85	190.88	190.82	190.82	3930.0
2019-07-05 04:00:00	IWM	ETF	156.35	156.35	156.35	156.35	300.0
2019-07-05 05:00:00	IWM	ETF	156.15	156.15	156.15	156.15	1000.0
2019-07-05 06:00:00	IWM	ETF	156.14	156.17	156.11	156.11	2000.0
2019-07-05 07:00:00	IWM	ETF	156.19	156.24	156.12	156.17	17257.0
2019-07-05 08:00:00	IWM	ETF	156.13	156.13	155.42	155.65	81724.0
2019-07-05 09:00:00	IWM	ETF	155.61	155.95	155.3	155.551	1227124.0
2019-07-05 10:00:00	IWM	ETF	155.57	155.87	154.86	155.4	1876410.0
2019-07-05 11:00:00	IWM	ETF	155.41	155.81	155.28	155.68	1993717.0
2019-07-05 12:00:00	IWM	ETF	155.71	155.955	155.525	155.94	735571.0
2019-07-05 13:00:00	IWM	ETF	155.94	156.59	155.885	156.585	1490132.0
2019-07-05 14:00:00	IWM	ETF	156.59	156.74	156.37	156.59	1211639.0
2019-07-05 15:00:00	IWM	ETF	156.6	156.74	156.395	156.71	3286260.0
2019-07-05 16:00:00	IWM	ETF	156.68	156.84	156.51	156.78	734591.0
2019-07-05 17:00:00	IWM	ETF	156.75	156.75	156.5	156.64	28400.0
2019-07-05 18:00:00	IWM	ETF	156.58	156.58	156.58	156.58	500.0
2019-07-05 19:00:00	IWM	ETF	156.63	156.63	156.55	156.59	2654.0
2019-07-05 07:00:00	DIA	ETF	269.34	269.34	269.25	269.25	6000.0
2019-07-05 08:00:00	DIA	ETF	269.24	269.32	268.48	268.74	27460.0

> showing 50 of 10,611 rows — these rows as CSV

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