PREVIEW / etf_1hour / 2019-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-21.parquet
  size:    329 KB
  rows:    10,957

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-21 04:00:00	SPY	ETF	294.37	294.37	293.95	293.95	22215.0
2019-06-21 05:00:00	SPY	ETF	293.99	294.32	293.85	294.06	36647.0
2019-06-21 06:00:00	SPY	ETF	294.0	294.26	293.8	294.11	49493.0
2019-06-21 07:00:00	SPY	ETF	294.13	294.33	293.87	293.91	154665.0
2019-06-21 08:00:00	SPY	ETF	294.06	294.35	293.4	293.85	645241.0
2019-06-21 09:00:00	SPY	ETF	293.85	294.37	293.65	294.01	9636839.0
2019-06-21 10:00:00	SPY	ETF	294.04	294.73	293.84	294.46	13232398.0
2019-06-21 11:00:00	SPY	ETF	294.45	295.52	294.35	294.51	8650004.0
2019-06-21 12:00:00	SPY	ETF	294.5	294.66	294.14	294.43	6828966.0
2019-06-21 13:00:00	SPY	ETF	294.44	294.53	294.16	294.5234	3313311.0
2019-06-21 14:00:00	SPY	ETF	294.52	294.67	294.25	294.52	6860330.0
2019-06-21 15:00:00	SPY	ETF	294.52	294.89	293.95	294.08	16787678.0
2019-06-21 16:00:00	SPY	ETF	294.05	294.35	293.44	293.44	12438437.0
2019-06-21 17:00:00	SPY	ETF	293.5	294.0	293.21	293.38	823376.0
2019-06-21 18:00:00	SPY	ETF	293.36	294.0	293.13	293.24	285389.0
2019-06-21 19:00:00	SPY	ETF	293.24	293.24	293.13	293.17	39888.0
2019-06-21 04:00:00	QQQ	ETF	188.55	188.65	188.42	188.48	8171.0
2019-06-21 05:00:00	QQQ	ETF	188.51	188.71	188.37	188.56	7619.0
2019-06-21 06:00:00	QQQ	ETF	188.4	188.57	188.28	188.51	18767.0
2019-06-21 07:00:00	QQQ	ETF	188.46	188.56	188.27	188.33	47059.0
2019-06-21 08:00:00	QQQ	ETF	188.3901	189.03	188.0	188.35	317399.0
2019-06-21 09:00:00	QQQ	ETF	188.34	188.76	188.1736	188.6	5058879.0
2019-06-21 10:00:00	QQQ	ETF	188.6	189.37	188.5001	189.06	5108560.0
2019-06-21 11:00:00	QQQ	ETF	189.07	189.77	188.7115	188.82	4343614.0
2019-06-21 12:00:00	QQQ	ETF	188.8198	188.97	188.51	188.8568	2050271.0
2019-06-21 13:00:00	QQQ	ETF	188.86	188.98	188.73	188.88	1403384.0
2019-06-21 14:00:00	QQQ	ETF	188.89	188.98	188.61	188.85	2338063.0
2019-06-21 15:00:00	QQQ	ETF	188.86	189.16	188.53	188.62	6531621.0
2019-06-21 16:00:00	QQQ	ETF	188.61	188.86	188.4	188.4	2238703.0
2019-06-21 17:00:00	QQQ	ETF	188.5	188.6685	188.29	188.35	2180674.0
2019-06-21 18:00:00	QQQ	ETF	188.45	188.57	188.2	188.3	789903.0
2019-06-21 19:00:00	QQQ	ETF	188.25	188.35	188.2	188.24	9562.0
2019-06-21 04:00:00	IWM	ETF	155.18	155.23	155.18	155.23	500.0
2019-06-21 05:00:00	IWM	ETF	155.14	155.14	154.99	155.01	6500.0
2019-06-21 06:00:00	IWM	ETF	155.06	155.08	154.98	154.98	1800.0
2019-06-21 07:00:00	IWM	ETF	155.08	155.1	154.84	154.98	7500.0
2019-06-21 08:00:00	IWM	ETF	154.99	155.18	154.94	155.17	25225.0
2019-06-21 09:00:00	IWM	ETF	155.01	155.21	153.61	153.89	3562873.0
2019-06-21 10:00:00	IWM	ETF	153.88	154.47	153.67	154.38	2362122.0
2019-06-21 11:00:00	IWM	ETF	154.38	154.87	154.21	154.29	1665832.0
2019-06-21 12:00:00	IWM	ETF	154.28	154.47	153.92	154.3	1375928.0
2019-06-21 13:00:00	IWM	ETF	154.29	154.36	154.02	154.15	937763.0
2019-06-21 14:00:00	IWM	ETF	154.16	154.2154	153.81	153.97	1014502.0
2019-06-21 15:00:00	IWM	ETF	153.975	154.19	153.86	153.89	4069828.0
2019-06-21 16:00:00	IWM	ETF	153.88	154.25	153.81	153.83	1217957.0
2019-06-21 17:00:00	IWM	ETF	153.77	153.95	153.7	153.7	148724.0
2019-06-21 18:00:00	IWM	ETF	153.73	153.8299	153.73	153.77	1085.0
2019-06-21 19:00:00	IWM	ETF	153.79	153.8	153.7	153.7	6177.0
2019-06-21 04:00:00	DIA	ETF	267.43	267.43	267.43	267.43	3800.0
2019-06-21 05:00:00	DIA	ETF	267.43	267.43	267.43	267.43	200.0

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

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