PREVIEW / etf_1hour / 2019-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-14.parquet
  size:    314 KB
  rows:    10,498

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-14 04:00:00	SPY	ETF	296.06	296.45	295.8	296.4	26194.0
2019-10-14 05:00:00	SPY	ETF	296.35	296.35	294.83	294.99	100478.0
2019-10-14 06:00:00	SPY	ETF	295.05	295.59	295.01	295.56	58052.0
2019-10-14 07:00:00	SPY	ETF	295.51	295.96	295.38	295.92	229209.0
2019-10-14 08:00:00	SPY	ETF	295.94	297.3	295.4	295.71	449296.0
2019-10-14 09:00:00	SPY	ETF	295.7	296.3	295.53	296.14	5057682.0
2019-10-14 10:00:00	SPY	ETF	296.14	296.605	295.83	296.59	5058920.0
2019-10-14 11:00:00	SPY	ETF	296.585	296.67	296.11	296.325	4323364.0
2019-10-14 12:00:00	SPY	ETF	296.335	296.41	296.01	296.15	2340150.0
2019-10-14 13:00:00	SPY	ETF	296.14	296.38	295.91	296.37	3618810.0
2019-10-14 14:00:00	SPY	ETF	296.36	296.54	296.1033	296.22	4266504.0
2019-10-14 15:00:00	SPY	ETF	296.215	296.39	295.905	296.01	8274609.0
2019-10-14 16:00:00	SPY	ETF	296.01	296.18	295.79	296.03	6054137.0
2019-10-14 17:00:00	SPY	ETF	296.02	296.03	295.98	296.02	25121.0
2019-10-14 18:00:00	SPY	ETF	296.05	296.37	296.05	296.32	36209.0
2019-10-14 19:00:00	SPY	ETF	296.33	296.74	296.32	296.67	42258.0
2019-10-14 04:00:00	QQQ	ETF	190.87	191.14	190.75	191.09	13181.0
2019-10-14 05:00:00	QQQ	ETF	190.98	191.02	189.96	190.11	72350.0
2019-10-14 06:00:00	QQQ	ETF	190.08	190.47	189.97	190.41	36545.0
2019-10-14 07:00:00	QQQ	ETF	190.39	190.84	190.35	190.77	61902.0
2019-10-14 08:00:00	QQQ	ETF	190.85	191.72	190.3999	190.67	163419.0
2019-10-14 09:00:00	QQQ	ETF	190.67	191.35	190.56	191.155	1893807.0
2019-10-14 10:00:00	QQQ	ETF	191.15	191.66	190.985	191.64	1921560.0
2019-10-14 11:00:00	QQQ	ETF	191.64	191.7	191.23	191.33	1528323.0
2019-10-14 12:00:00	QQQ	ETF	191.34	191.4	191.03	191.145	753214.0
2019-10-14 13:00:00	QQQ	ETF	191.1325	191.381	191.05	191.38	1300106.0
2019-10-14 14:00:00	QQQ	ETF	191.38	191.5401	191.3	191.3869	1174209.0
2019-10-14 15:00:00	QQQ	ETF	191.38	191.54	191.09	191.11	2906953.0
2019-10-14 16:00:00	QQQ	ETF	191.12	191.36	190.97	191.25	541087.0
2019-10-14 17:00:00	QQQ	ETF	191.25	191.25	191.09	191.24	22717.0
2019-10-14 18:00:00	QQQ	ETF	191.23	191.45	191.2	191.41	275082.0
2019-10-14 19:00:00	QQQ	ETF	191.43	191.74	191.41	191.68	37566.0
2019-10-14 04:00:00	IWM	ETF	150.0	150.0	149.88	149.99	3162.0
2019-10-14 05:00:00	IWM	ETF	150.13	150.15	149.42	149.42	4600.0
2019-10-14 06:00:00	IWM	ETF	149.42	149.71	149.4	149.71	16000.0
2019-10-14 07:00:00	IWM	ETF	149.67	149.77	149.6	149.77	6900.0
2019-10-14 08:00:00	IWM	ETF	149.6	149.95	149.6	149.74	34204.0
2019-10-14 09:00:00	IWM	ETF	149.82	150.08	149.23	149.34	1911739.0
2019-10-14 10:00:00	IWM	ETF	149.33	149.87	149.1	149.855	1735758.0
2019-10-14 11:00:00	IWM	ETF	149.86	149.98	149.63	149.7701	1241866.0
2019-10-14 12:00:00	IWM	ETF	149.77	150.15	149.54	149.61	978841.0
2019-10-14 13:00:00	IWM	ETF	149.6	149.875	149.53	149.87	415400.0
2019-10-14 14:00:00	IWM	ETF	149.88	149.96	149.7	149.7	494337.0
2019-10-14 15:00:00	IWM	ETF	149.7	149.84	149.53	149.69	1660345.0
2019-10-14 16:00:00	IWM	ETF	149.7	149.84	149.59	149.61	459479.0
2019-10-14 17:00:00	IWM	ETF	149.67	149.67	149.67	149.67	7530.0
2019-10-14 18:00:00	IWM	ETF	149.66	149.78	149.66	149.78	251000.0
2019-10-14 19:00:00	IWM	ETF	149.83	150.04	149.83	150.03	7020.0
2019-10-14 04:00:00	DIA	ETF	267.96	267.96	267.9	267.9	400.0
2019-10-14 05:00:00	DIA	ETF	268.04	268.04	267.58	267.58	1100.0

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

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