PREVIEW / etf_1hour / 2019-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-25.parquet
  size:    335 KB
  rows:    10,901

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-09-25 04:00:00	SPY	ETF	295.41	295.6	294.99	295.0	22666.0
2019-09-25 05:00:00	SPY	ETF	295.07	295.38	294.65	295.36	17329.0
2019-09-25 06:00:00	SPY	ETF	295.32	295.5	295.23	295.5	47948.0
2019-09-25 07:00:00	SPY	ETF	295.5	295.51	295.21	295.35	129853.0
2019-09-25 08:00:00	SPY	ETF	295.35	296.62	295.31	296.07	418191.0
2019-09-25 09:00:00	SPY	ETF	296.07	296.36	295.11	295.18	6358775.0
2019-09-25 10:00:00	SPY	ETF	295.2	296.61	294.33	296.26	15478831.0
2019-09-25 11:00:00	SPY	ETF	296.26	296.7	296.11	296.44	6189864.0
2019-09-25 12:00:00	SPY	ETF	296.44	296.93	296.3	296.4637	4871494.0
2019-09-25 13:00:00	SPY	ETF	296.47	296.99	296.38	296.88	2833036.0
2019-09-25 14:00:00	SPY	ETF	296.87	297.55	296.865	297.5099	6050325.0
2019-09-25 15:00:00	SPY	ETF	297.5	298.11	297.4	297.6	13481521.0
2019-09-25 16:00:00	SPY	ETF	297.59	297.73	297.43	297.56	12544777.0
2019-09-25 17:00:00	SPY	ETF	297.59	297.62	297.46	297.55	69949.0
2019-09-25 18:00:00	SPY	ETF	297.51	297.78	297.51	297.53	80532.0
2019-09-25 19:00:00	SPY	ETF	297.55	297.59	297.26	297.51	81477.0
2019-09-25 04:00:00	QQQ	ETF	187.37	187.56	186.99	187.05	36094.0
2019-09-25 05:00:00	QQQ	ETF	187.02	187.34	186.72	187.33	43054.0
2019-09-25 06:00:00	QQQ	ETF	187.31	187.44	187.23	187.44	31080.0
2019-09-25 07:00:00	QQQ	ETF	187.46	187.46	187.21	187.3	112762.0
2019-09-25 08:00:00	QQQ	ETF	187.35	188.01	187.25	187.97	198711.0
2019-09-25 09:00:00	QQQ	ETF	187.97	188.15	186.88	187.0576	3643207.0
2019-09-25 10:00:00	QQQ	ETF	187.07	188.34	186.21	188.1	7916403.0
2019-09-25 11:00:00	QQQ	ETF	188.11	188.73	188.06	188.35	3354950.0
2019-09-25 12:00:00	QQQ	ETF	188.35	188.91	188.29	188.64	2194074.0
2019-09-25 13:00:00	QQQ	ETF	188.63	189.16	188.55	189.06	945435.0
2019-09-25 14:00:00	QQQ	ETF	189.07	189.8923	189.04	189.84	2459094.0
2019-09-25 15:00:00	QQQ	ETF	189.85	190.58	189.79	190.07	6335622.0
2019-09-25 16:00:00	QQQ	ETF	190.08	190.13	189.9	190.07	3058662.0
2019-09-25 17:00:00	QQQ	ETF	190.02	190.1	189.89	189.9	113892.0
2019-09-25 18:00:00	QQQ	ETF	189.94	190.19	189.92	190.01	108178.0
2019-09-25 19:00:00	QQQ	ETF	189.98	189.98	189.74	189.93	37650.0
2019-09-25 04:00:00	IWM	ETF	151.99	151.99	151.99	151.99	100.0
2019-09-25 05:00:00	IWM	ETF	151.9	151.98	151.8	151.98	2500.0
2019-09-25 06:00:00	IWM	ETF	152.06	152.06	151.98	151.98	700.0
2019-09-25 07:00:00	IWM	ETF	152.02	152.04	151.89	151.95	16000.0
2019-09-25 08:00:00	IWM	ETF	152.07	152.38	152.0	152.38	40288.0
2019-09-25 09:00:00	IWM	ETF	152.38	153.22	152.1	152.25	3301187.0
2019-09-25 10:00:00	IWM	ETF	152.24	152.81	151.8	152.75	3747823.0
2019-09-25 11:00:00	IWM	ETF	152.77	153.47	152.73	153.0	2913978.0
2019-09-25 12:00:00	IWM	ETF	153.03	153.75	153.01	153.51	2843840.0
2019-09-25 13:00:00	IWM	ETF	153.51	153.96	153.45	153.83	1597977.0
2019-09-25 14:00:00	IWM	ETF	153.84	154.35	153.83	154.28	1537624.0
2019-09-25 15:00:00	IWM	ETF	154.28	154.36	153.94	154.06	2536296.0
2019-09-25 16:00:00	IWM	ETF	154.07	154.12	153.9	154.06	885185.0
2019-09-25 17:00:00	IWM	ETF	154.05	154.1	154.02	154.08	42593.0
2019-09-25 18:00:00	IWM	ETF	154.08	154.18	154.01	154.01	42245.0
2019-09-25 19:00:00	IWM	ETF	153.96	154.01	153.84	154.01	5483.0
2019-09-25 04:00:00	DIA	ETF	267.86	267.86	267.86	267.86	150.0
2019-09-25 05:00:00	DIA	ETF	267.5	267.5	267.5	267.5	100.0

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

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