PREVIEW / etf_1hour / 2019-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-23.parquet
  size:    330 KB
  rows:    10,719

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-10-23 04:00:00	SPY	ETF	298.6	299.0	298.6	298.75	12381.0
2019-10-23 05:00:00	SPY	ETF	298.79	298.83	298.65	298.7	9149.0
2019-10-23 06:00:00	SPY	ETF	299.1	299.22	298.24	298.3	84197.0
2019-10-23 07:00:00	SPY	ETF	298.35	298.51	297.92	298.44	270493.0
2019-10-23 08:00:00	SPY	ETF	298.46	298.85	297.97	298.65	203561.0
2019-10-23 09:00:00	SPY	ETF	298.65	299.39	298.495	299.28	3821534.0
2019-10-23 10:00:00	SPY	ETF	299.29	299.57	298.77	299.43	4240137.0
2019-10-23 11:00:00	SPY	ETF	299.425	299.76	299.375	299.44	2991930.0
2019-10-23 12:00:00	SPY	ETF	299.43	299.59	299.22	299.325	2565869.0
2019-10-23 13:00:00	SPY	ETF	299.32	299.5	299.14	299.29	1962968.0
2019-10-23 14:00:00	SPY	ETF	299.295	299.295	298.79	299.06	4059627.0
2019-10-23 15:00:00	SPY	ETF	299.05	299.94	298.94	299.86	9164785.0
2019-10-23 16:00:00	SPY	ETF	299.86	300.11	299.79	300.07	4291804.0
2019-10-23 17:00:00	SPY	ETF	300.07	300.15	300.0	300.0	160944.0
2019-10-23 18:00:00	SPY	ETF	300.07	300.45	300.07	300.24	73300.0
2019-10-23 19:00:00	SPY	ETF	300.34	300.34	300.13	300.2	50250.0
2019-10-23 04:00:00	QQQ	ETF	190.84	191.35	190.84	191.16	32986.0
2019-10-23 05:00:00	QQQ	ETF	191.19	191.24	191.09	191.21	23857.0
2019-10-23 06:00:00	QQQ	ETF	191.24	191.55	190.88	190.97	57044.0
2019-10-23 07:00:00	QQQ	ETF	190.98	191.11	190.7	191.08	177962.0
2019-10-23 08:00:00	QQQ	ETF	191.0801	191.46	190.73	191.33	299676.0
2019-10-23 09:00:00	QQQ	ETF	191.32	191.9853	191.15	191.7771	2110693.0
2019-10-23 10:00:00	QQQ	ETF	191.78	192.1	191.17	191.94	2475108.0
2019-10-23 11:00:00	QQQ	ETF	191.93	192.2582	191.78	191.83	1236650.0
2019-10-23 12:00:00	QQQ	ETF	191.8491	192.07	191.625	191.96	1025830.0
2019-10-23 13:00:00	QQQ	ETF	191.95	192.1	191.8	191.916	734119.0
2019-10-23 14:00:00	QQQ	ETF	191.92	191.92	191.41	191.67	843534.0
2019-10-23 15:00:00	QQQ	ETF	191.67	192.25	191.57	192.22	1898263.0
2019-10-23 16:00:00	QQQ	ETF	192.18	192.73	191.8256	192.7	1386714.0
2019-10-23 17:00:00	QQQ	ETF	192.69	192.78	192.55	192.77	80557.0
2019-10-23 18:00:00	QQQ	ETF	192.78	193.06	192.78	192.95	61373.0
2019-10-23 19:00:00	QQQ	ETF	192.95	193.0	192.86	192.9	52775.0
2019-10-23 04:00:00	IWM	ETF	154.24	154.24	154.17	154.17	2500.0
2019-10-23 05:00:00	IWM	ETF	154.13	154.2	154.13	154.2	1118.0
2019-10-23 06:00:00	IWM	ETF	154.18	154.4	153.97	153.97	7370.0
2019-10-23 07:00:00	IWM	ETF	154.01	154.05	153.84	153.97	14062.0
2019-10-23 08:00:00	IWM	ETF	153.9001	154.2	153.9001	154.13	30879.0
2019-10-23 09:00:00	IWM	ETF	154.14	154.42	153.55	154.31	1314395.0
2019-10-23 10:00:00	IWM	ETF	154.3	154.565	153.89	154.355	1293826.0
2019-10-23 11:00:00	IWM	ETF	154.35	154.75	154.18	154.5811	901788.0
2019-10-23 12:00:00	IWM	ETF	154.59	154.68	154.37	154.3955	639184.0
2019-10-23 13:00:00	IWM	ETF	154.4	154.56	154.28	154.45	506289.0
2019-10-23 14:00:00	IWM	ETF	154.44	154.45	154.07	154.15	566162.0
2019-10-23 15:00:00	IWM	ETF	154.15	154.41	154.06	154.4	1322506.0
2019-10-23 16:00:00	IWM	ETF	154.38	154.68	154.38	154.6	569991.0
2019-10-23 17:00:00	IWM	ETF	154.61	154.75	154.61	154.67	13790.0
2019-10-23 18:00:00	IWM	ETF	154.67	154.82	154.67	154.77	3951.0
2019-10-23 19:00:00	IWM	ETF	154.73	154.73	154.64	154.65	1785.0
2019-10-23 06:00:00	DIA	ETF	267.82	267.82	267.3	267.32	1100.0
2019-10-23 07:00:00	DIA	ETF	267.28	267.77	266.64	267.58	7900.0

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

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