PREVIEW / etf_1hour / 2019-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-22.parquet
  size:    320 KB
  rows:    10,776

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-07-22 04:00:00	SPY	ETF	297.12	297.78	297.06	297.71	38135.0
2019-07-22 05:00:00	SPY	ETF	297.69	297.73	297.49	297.56	22027.0
2019-07-22 06:00:00	SPY	ETF	297.54	297.83	297.48	297.76	24949.0
2019-07-22 07:00:00	SPY	ETF	297.74	297.81	297.6	297.67	198322.0
2019-07-22 08:00:00	SPY	ETF	297.7601	298.0	297.25	297.69	536524.0
2019-07-22 09:00:00	SPY	ETF	297.7	298.11	297.33	298.08	4217971.0
2019-07-22 10:00:00	SPY	ETF	298.08	298.12	297.04	297.295	5634131.0
2019-07-22 11:00:00	SPY	ETF	297.29	297.74	297.0415	297.64	3908942.0
2019-07-22 12:00:00	SPY	ETF	297.64	298.09	297.31	298.0	3391546.0
2019-07-22 13:00:00	SPY	ETF	298.0	298.105	297.77	298.05	3230730.0
2019-07-22 14:00:00	SPY	ETF	298.05	298.12	297.75	297.99	3145232.0
2019-07-22 15:00:00	SPY	ETF	298.0	298.5	297.65	297.92	10280823.0
2019-07-22 16:00:00	SPY	ETF	297.9	298.2	297.72	298.09	6974844.0
2019-07-22 17:00:00	SPY	ETF	298.08	298.11	297.9	298.03	131938.0
2019-07-22 18:00:00	SPY	ETF	298.1	298.22	297.97	297.97	51800.0
2019-07-22 19:00:00	SPY	ETF	298.0	298.18	297.96	298.08	22008.0
2019-07-22 04:00:00	QQQ	ETF	190.94	191.4	190.94	191.4	64685.0
2019-07-22 05:00:00	QQQ	ETF	191.38	191.45	191.29	191.36	22674.0
2019-07-22 06:00:00	QQQ	ETF	191.28	191.65	191.25	191.58	28156.0
2019-07-22 07:00:00	QQQ	ETF	191.58	191.62	191.4	191.42	134391.0
2019-07-22 08:00:00	QQQ	ETF	191.58	191.75	190.69	191.5	284608.0
2019-07-22 09:00:00	QQQ	ETF	191.48	192.46	191.31	192.42	3046737.0
2019-07-22 10:00:00	QQQ	ETF	192.42	192.5399	191.791	191.97	2895970.0
2019-07-22 11:00:00	QQQ	ETF	191.97	192.31	191.77	192.21	2038429.0
2019-07-22 12:00:00	QQQ	ETF	192.21	192.4499	191.92	192.42	1103333.0
2019-07-22 13:00:00	QQQ	ETF	192.41	192.49	192.185	192.48	669588.0
2019-07-22 14:00:00	QQQ	ETF	192.4896	192.59	192.2657	192.54	836094.0
2019-07-22 15:00:00	QQQ	ETF	192.54	192.94	192.35	192.58	3468351.0
2019-07-22 16:00:00	QQQ	ETF	192.59	192.82	192.3166	192.76	810898.0
2019-07-22 17:00:00	QQQ	ETF	192.7	192.78	192.59	192.72	61828.0
2019-07-22 18:00:00	QQQ	ETF	192.7	192.83	192.68	192.68	30035.0
2019-07-22 19:00:00	QQQ	ETF	192.72	192.8	192.7	192.75	24672.0
2019-07-22 04:00:00	IWM	ETF	154.01	154.33	154.01	154.33	5042.0
2019-07-22 05:00:00	IWM	ETF	154.2	154.2	154.2	154.2	200.0
2019-07-22 06:00:00	IWM	ETF	154.29	154.44	154.29	154.44	500.0
2019-07-22 07:00:00	IWM	ETF	154.32	154.32	154.17	154.21	11454.0
2019-07-22 08:00:00	IWM	ETF	154.18	154.42	154.01	154.35	31375.0
2019-07-22 09:00:00	IWM	ETF	154.32	154.7	153.7751	154.53	1813131.0
2019-07-22 10:00:00	IWM	ETF	154.53	154.62	153.57	153.79	1999420.0
2019-07-22 11:00:00	IWM	ETF	153.78	154.1	153.4	154.04	1904193.0
2019-07-22 12:00:00	IWM	ETF	154.04	154.265	153.63	154.195	1194650.0
2019-07-22 13:00:00	IWM	ETF	154.2	154.23	153.91	153.975	577326.0
2019-07-22 14:00:00	IWM	ETF	153.97	154.02	153.495	153.57	1325174.0
2019-07-22 15:00:00	IWM	ETF	153.56	153.925	153.46	153.68	2725989.0
2019-07-22 16:00:00	IWM	ETF	153.66	153.84	153.58	153.71	1042975.0
2019-07-22 17:00:00	IWM	ETF	153.77	153.79	153.77	153.79	600.0
2019-07-22 18:00:00	IWM	ETF	153.71	153.71	153.71	153.71	500.0
2019-07-22 19:00:00	IWM	ETF	153.77	153.8	153.75	153.75	6605.0
2019-07-22 07:00:00	DIA	ETF	271.98	271.98	271.86	271.9	2050.0
2019-07-22 08:00:00	DIA	ETF	271.84	272.06	271.7001	271.88	7550.0

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

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