PREVIEW / etf_1hour / 2019-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-30.parquet
  size:    328 KB
  rows:    10,799

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-08-30 04:00:00	SPY	ETF	293.52	294.24	293.51	294.15	34213.0
2019-08-30 05:00:00	SPY	ETF	294.12	294.71	294.1	294.71	44544.0
2019-08-30 06:00:00	SPY	ETF	294.61	294.67	294.41	294.61	85500.0
2019-08-30 07:00:00	SPY	ETF	294.58	294.67	294.17	294.54	313351.0
2019-08-30 08:00:00	SPY	ETF	294.64	294.66	292.65	294.39	313465.0
2019-08-30 09:00:00	SPY	ETF	294.38	294.44	293.46	293.66	5578837.0
2019-08-30 10:00:00	SPY	ETF	293.67	294.18	293.07	293.07	6751076.0
2019-08-30 11:00:00	SPY	ETF	293.05	293.18	291.42	292.39	9524045.0
2019-08-30 12:00:00	SPY	ETF	292.38	293.02	292.165	292.87	4636827.0
2019-08-30 13:00:00	SPY	ETF	292.86	292.97	292.18	292.3921	4702156.0
2019-08-30 14:00:00	SPY	ETF	292.38	292.79	292.0	292.15	5624388.0
2019-08-30 15:00:00	SPY	ETF	292.16	293.06	291.72	292.46	15210464.0
2019-08-30 16:00:00	SPY	ETF	292.48	292.7613	292.08	292.48	7693398.0
2019-08-30 17:00:00	SPY	ETF	292.45	292.75	292.19	292.57	734784.0
2019-08-30 18:00:00	SPY	ETF	292.57	292.57	292.29	292.39	102102.0
2019-08-30 19:00:00	SPY	ETF	292.36	292.43	292.3	292.3	18852.0
2019-08-30 04:00:00	QQQ	ETF	188.6	189.02	188.53	189.0	61181.0
2019-08-30 05:00:00	QQQ	ETF	189.04	189.44	189.01	189.43	59434.0
2019-08-30 06:00:00	QQQ	ETF	189.4	189.41	189.13	189.37	37230.0
2019-08-30 07:00:00	QQQ	ETF	189.36	189.36	188.97	189.19	322754.0
2019-08-30 08:00:00	QQQ	ETF	189.06	189.35	187.62	189.08	89741.0
2019-08-30 09:00:00	QQQ	ETF	189.04	189.1	188.24	188.41	2241488.0
2019-08-30 10:00:00	QQQ	ETF	188.42	188.7	187.765	187.767	2522668.0
2019-08-30 11:00:00	QQQ	ETF	187.75	187.87	186.41	187.14	5589943.0
2019-08-30 12:00:00	QQQ	ETF	187.15	187.36	186.83	187.2165	2250325.0
2019-08-30 13:00:00	QQQ	ETF	187.21	187.3065	186.8699	187.0639	1484798.0
2019-08-30 14:00:00	QQQ	ETF	187.05	187.41	186.9	187.02	2000770.0
2019-08-30 15:00:00	QQQ	ETF	187.02	187.67	186.7	187.52	5357213.0
2019-08-30 16:00:00	QQQ	ETF	187.52	187.6413	187.02	187.2	1511012.0
2019-08-30 17:00:00	QQQ	ETF	187.16	187.57	187.1	187.4	107582.0
2019-08-30 18:00:00	QQQ	ETF	187.31	187.4	187.27	187.34	8800.0
2019-08-30 19:00:00	QQQ	ETF	187.37	187.38	187.2	187.2	5471.0
2019-08-30 04:00:00	IWM	ETF	149.54	149.89	149.54	149.88	11125.0
2019-08-30 05:00:00	IWM	ETF	149.9	150.12	149.9	150.12	6002.0
2019-08-30 06:00:00	IWM	ETF	150.15	150.16	150.0	150.1	25702.0
2019-08-30 07:00:00	IWM	ETF	150.12	150.16	149.93	150.03	19600.0
2019-08-30 08:00:00	IWM	ETF	150.1599	150.1599	149.25	150.05	26555.0
2019-08-30 09:00:00	IWM	ETF	150.0	150.0	149.19	149.26	1814724.0
2019-08-30 10:00:00	IWM	ETF	149.28	149.73	149.0101	149.04	1817341.0
2019-08-30 11:00:00	IWM	ETF	149.01	149.07	148.04	148.84	2124192.0
2019-08-30 12:00:00	IWM	ETF	148.835	149.19	148.73	149.055	1015297.0
2019-08-30 13:00:00	IWM	ETF	149.06	149.11	148.43	148.52	1719868.0
2019-08-30 14:00:00	IWM	ETF	148.515	148.85	148.51	148.57	1506025.0
2019-08-30 15:00:00	IWM	ETF	148.59	149.07	148.35	148.86	3809623.0
2019-08-30 16:00:00	IWM	ETF	148.86	148.8793	148.56	148.65	1470894.0
2019-08-30 17:00:00	IWM	ETF	148.67	148.84	148.66	148.71	503199.0
2019-08-30 18:00:00	IWM	ETF	148.78	148.78	148.78	148.78	114.0
2019-08-30 19:00:00	IWM	ETF	148.71	148.78	148.61	148.61	1800.0
2019-08-30 05:00:00	DIA	ETF	265.34	265.7	265.3	265.7	3437.0
2019-08-30 06:00:00	DIA	ETF	265.62	265.64	265.54	265.54	2788.0

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

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