PREVIEW / etf_1hour / 2019-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-24.parquet
  size:    325 KB
  rows:    10,801

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-24 04:00:00	SPY	ETF	294.3	294.38	294.22	294.35	41634.0
2019-06-24 05:00:00	SPY	ETF	294.29	294.38	294.24	294.28	13945.0
2019-06-24 06:00:00	SPY	ETF	294.33	294.53	294.24	294.24	39467.0
2019-06-24 07:00:00	SPY	ETF	294.24	294.29	294.07	294.27	125679.0
2019-06-24 08:00:00	SPY	ETF	294.07	294.67	294.07	294.23	185817.0
2019-06-24 09:00:00	SPY	ETF	294.21	294.5	293.85	293.92	5445910.0
2019-06-24 10:00:00	SPY	ETF	293.93	294.58	293.88	294.19	6203385.0
2019-06-24 11:00:00	SPY	ETF	294.19	294.51	294.03	294.25	3664891.0
2019-06-24 12:00:00	SPY	ETF	294.2501	294.36	294.11	294.14	3374599.0
2019-06-24 13:00:00	SPY	ETF	294.15	294.21	293.78	293.9	3153013.0
2019-06-24 14:00:00	SPY	ETF	293.89	294.01	293.73	293.9	4374679.0
2019-06-24 15:00:00	SPY	ETF	293.9	293.99	293.47	293.64	11470100.0
2019-06-24 16:00:00	SPY	ETF	293.63	294.1015	293.5928	293.75	8372354.0
2019-06-24 17:00:00	SPY	ETF	293.73	293.78	293.67	293.67	49220.0
2019-06-24 18:00:00	SPY	ETF	293.7	293.85	293.7	293.74	37965.0
2019-06-24 19:00:00	SPY	ETF	293.77	293.88	293.75	293.81	16685.0
2019-06-24 04:00:00	QQQ	ETF	188.7	188.78	188.63	188.73	49394.0
2019-06-24 05:00:00	QQQ	ETF	188.74	188.74	188.63	188.72	26545.0
2019-06-24 06:00:00	QQQ	ETF	188.72	188.86	188.57	188.57	25545.0
2019-06-24 07:00:00	QQQ	ETF	188.59	188.67	188.4	188.65	49839.0
2019-06-24 08:00:00	QQQ	ETF	188.51	189.0	188.4499	188.62	122913.0
2019-06-24 09:00:00	QQQ	ETF	188.62	188.72	188.07	188.12	2597632.0
2019-06-24 10:00:00	QQQ	ETF	188.12	188.67	188.0801	188.34	2464427.0
2019-06-24 11:00:00	QQQ	ETF	188.34	188.67	188.29	188.5627	1578195.0
2019-06-24 12:00:00	QQQ	ETF	188.57	188.67	188.39	188.517	787626.0
2019-06-24 13:00:00	QQQ	ETF	188.52	188.55	188.18	188.28	1319699.0
2019-06-24 14:00:00	QQQ	ETF	188.28	188.38	188.165	188.31	1243761.0
2019-06-24 15:00:00	QQQ	ETF	188.31	188.34	188.06	188.14	3321879.0
2019-06-24 16:00:00	QQQ	ETF	188.14	188.38	188.1097	188.21	562171.0
2019-06-24 17:00:00	QQQ	ETF	188.28	188.28	188.16	188.17	611541.0
2019-06-24 18:00:00	QQQ	ETF	188.17	188.33	188.16	188.25	20019.0
2019-06-24 19:00:00	QQQ	ETF	188.28	188.36	188.27	188.27	19484.0
2019-06-24 07:00:00	IWM	ETF	154.29	154.29	154.2	154.27	1839.0
2019-06-24 08:00:00	IWM	ETF	154.23	154.32	154.23	154.28	2422135.0
2019-06-24 09:00:00	IWM	ETF	154.27	154.41	153.525	153.54	1853169.0
2019-06-24 10:00:00	IWM	ETF	153.55	153.925	153.09	153.19	3463127.0
2019-06-24 11:00:00	IWM	ETF	153.18	153.54	152.96	153.2065	1951009.0
2019-06-24 12:00:00	IWM	ETF	153.21	153.31	152.86	152.88	1078122.0
2019-06-24 13:00:00	IWM	ETF	152.88	152.95	152.52	152.617	1632895.0
2019-06-24 14:00:00	IWM	ETF	152.62	152.755	152.23	152.39	1914950.0
2019-06-24 15:00:00	IWM	ETF	152.38	152.45	152.0	152.02	4413096.0
2019-06-24 16:00:00	IWM	ETF	152.08	153.9489	152.012	152.32	2222452.0
2019-06-24 17:00:00	IWM	ETF	152.34	152.34	152.08	152.3	62718.0
2019-06-24 18:00:00	IWM	ETF	152.3	152.35	152.29	152.31	5900.0
2019-06-24 19:00:00	IWM	ETF	152.34	152.35	152.28	152.28	4203.0
2019-06-24 04:00:00	DIA	ETF	267.17	267.17	267.14	267.14	600.0
2019-06-24 05:00:00	DIA	ETF	267.2	267.2	267.2	267.2	200.0
2019-06-24 06:00:00	DIA	ETF	267.38	267.44	267.38	267.44	1250.0
2019-06-24 07:00:00	DIA	ETF	267.26	267.26	267.2	267.26	1112.0
2019-06-24 08:00:00	DIA	ETF	267.37	267.46	267.27	267.38	4075.0

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

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