PREVIEW / etf_1hour / 2021-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-15.parquet
  size:    421 KB
  rows:    14,392

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
2021-01-15 04:00:00	SPY	ETF	377.4	377.73	377.27	377.44	35801.0
2021-01-15 05:00:00	SPY	ETF	377.5	377.9	377.1	377.31	18778.0
2021-01-15 06:00:00	SPY	ETF	377.25	377.25	376.65	377.18	111025.0
2021-01-15 07:00:00	SPY	ETF	377.17	377.56	376.7	376.97	332921.0
2021-01-15 08:00:00	SPY	ETF	376.8101	377.56	376.6	376.73	611937.0
2021-01-15 09:00:00	SPY	ETF	376.71	377.58	376.31	377.1	6992685.0
2021-01-15 10:00:00	SPY	ETF	377.1	377.32	373.7	375.31	31611545.0
2021-01-15 11:00:00	SPY	ETF	375.32	376.92	374.3	376.17	9561896.0
2021-01-15 12:00:00	SPY	ETF	376.18	376.81	375.7	376.64	3962121.0
2021-01-15 13:00:00	SPY	ETF	376.645	377.29	376.19	376.76	5030987.0
2021-01-15 14:00:00	SPY	ETF	376.76	377.17	376.31	376.4768	5697193.0
2021-01-15 15:00:00	SPY	ETF	376.48	377.22	375.41	375.68	14543726.0
2021-01-15 16:00:00	SPY	ETF	375.64	375.7	374.01	374.12	21157394.0
2021-01-15 17:00:00	SPY	ETF	374.16	375.7	374.0	375.14	3532034.0
2021-01-15 18:00:00	SPY	ETF	375.15	375.5	374.7	374.7	171039.0
2021-01-15 19:00:00	SPY	ETF	374.7	374.71	374.5	374.52	36930.0
2021-01-15 04:00:00	QQQ	ETF	314.14	314.33	313.8	313.8	27661.0
2021-01-15 05:00:00	QQQ	ETF	313.83	314.22	313.5	313.6	7889.0
2021-01-15 06:00:00	QQQ	ETF	313.7	313.71	313.19	313.47	32313.0
2021-01-15 07:00:00	QQQ	ETF	313.56	314.32	313.49	314.22	165593.0
2021-01-15 08:00:00	QQQ	ETF	313.8	314.58	313.06	314.21	371855.0
2021-01-15 09:00:00	QQQ	ETF	314.11	315.12	313.65	314.42	2984109.0
2021-01-15 10:00:00	QQQ	ETF	314.43	314.61	310.81	312.05	5826062.0
2021-01-15 11:00:00	QQQ	ETF	312.09	313.71	310.58	312.86	3754614.0
2021-01-15 12:00:00	QQQ	ETF	312.86	313.387	312.52	313.14	1517787.0
2021-01-15 13:00:00	QQQ	ETF	313.15	314.04	312.67	313.63	1680352.0
2021-01-15 14:00:00	QQQ	ETF	313.63	313.92	312.6	312.64	1609841.0
2021-01-15 15:00:00	QQQ	ETF	312.65	313.19	311.73	311.9	4313247.0
2021-01-15 16:00:00	QQQ	ETF	311.87	311.87	310.89	310.94	1280566.0
2021-01-15 17:00:00	QQQ	ETF	311.12	311.39	310.89	311.36	77484.0
2021-01-15 18:00:00	QQQ	ETF	311.39	311.83	311.0	311.18	260965.0
2021-01-15 19:00:00	QQQ	ETF	311.15	311.23	310.95	311.23	26005.0
2021-01-15 04:00:00	IWM	ETF	212.7	213.13	212.55	213.04	22272.0
2021-01-15 05:00:00	IWM	ETF	213.18	213.38	212.7	213.1	14581.0
2021-01-15 06:00:00	IWM	ETF	213.02	213.02	212.5	212.81	42596.0
2021-01-15 07:00:00	IWM	ETF	212.83	212.96	210.94	211.24	226390.0
2021-01-15 08:00:00	IWM	ETF	211.18	213.0	211.0198	211.6	273949.0
2021-01-15 09:00:00	IWM	ETF	211.51	212.35	210.67	211.435	3756975.0
2021-01-15 10:00:00	IWM	ETF	211.41	211.47	208.26	210.33	5629403.0
2021-01-15 11:00:00	IWM	ETF	210.38	210.9	208.98	210.22	3473512.0
2021-01-15 12:00:00	IWM	ETF	210.22	211.717	210.09	211.69	1652744.0
2021-01-15 13:00:00	IWM	ETF	211.68	212.17	211.21	211.97	2908120.0
2021-01-15 14:00:00	IWM	ETF	211.98	212.06	211.32	211.42	1381819.0
2021-01-15 15:00:00	IWM	ETF	211.43	211.76	210.45	210.78	5049207.0
2021-01-15 16:00:00	IWM	ETF	210.75	210.84	209.7	209.93	3780317.0
2021-01-15 17:00:00	IWM	ETF	210.05	210.7	209.68	210.15	13067.0
2021-01-15 18:00:00	IWM	ETF	210.27	210.34	210.11	210.34	8641.0
2021-01-15 19:00:00	IWM	ETF	210.2	210.47	209.52	209.58	9888.0
2021-01-15 04:00:00	DIA	ETF	308.96	309.02	308.96	309.01	1400.0
2021-01-15 05:00:00	DIA	ETF	309.16	309.16	309.16	309.16	100.0

> showing 50 of 14,392 rows — these rows as CSV

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