PREVIEW / etf_1hour / 2021-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-12.parquet
  size:    421 KB
  rows:    14,883

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-11-12 04:00:00	SPY	ETF	464.6	464.6	464.0	464.31	34216.0
2021-11-12 05:00:00	SPY	ETF	464.35	464.7	464.22	464.58	22297.0
2021-11-12 06:00:00	SPY	ETF	464.55	465.05	464.48	465.02	115357.0
2021-11-12 07:00:00	SPY	ETF	464.93	464.93	464.6	464.61	42504.0
2021-11-12 08:00:00	SPY	ETF	464.61	465.13	464.1	465.05	195148.0
2021-11-12 09:00:00	SPY	ETF	465.05	465.44	464.11	464.31	3366358.0
2021-11-12 10:00:00	SPY	ETF	464.29	465.37	464.15	465.36	4339959.0
2021-11-12 11:00:00	SPY	ETF	465.36	467.28	465.35	467.13	6462731.0
2021-11-12 12:00:00	SPY	ETF	467.13	467.37	466.67	466.805	3255228.0
2021-11-12 13:00:00	SPY	ETF	466.81	467.0	466.38	466.96	2545924.0
2021-11-12 14:00:00	SPY	ETF	466.96	467.0	466.255	466.6666	2792341.0
2021-11-12 15:00:00	SPY	ETF	466.66	467.86	466.6	467.26	11611429.0
2021-11-12 16:00:00	SPY	ETF	467.25	468.04	467.17	467.62	3802309.0
2021-11-12 17:00:00	SPY	ETF	467.61	467.62	467.27	467.48	990126.0
2021-11-12 18:00:00	SPY	ETF	467.59	467.69	467.27	467.62	17699.0
2021-11-12 19:00:00	SPY	ETF	467.6	467.6	467.5	467.6	13769.0
2021-11-12 04:00:00	QQQ	ETF	391.97	391.97	391.0	391.24	37022.0
2021-11-12 05:00:00	QQQ	ETF	391.26	391.67	391.11	391.49	30210.0
2021-11-12 06:00:00	QQQ	ETF	391.53	391.81	391.3	391.74	51174.0
2021-11-12 07:00:00	QQQ	ETF	391.75	391.75	391.37	391.42	134112.0
2021-11-12 08:00:00	QQQ	ETF	391.4	391.79	391.2	391.6795	186002.0
2021-11-12 09:00:00	QQQ	ETF	391.66	392.23	390.13	390.63	3754009.0
2021-11-12 10:00:00	QQQ	ETF	390.6	392.79	390.57	392.69	3782369.0
2021-11-12 11:00:00	QQQ	ETF	392.71	394.89	392.59	394.68	5118147.0
2021-11-12 12:00:00	QQQ	ETF	394.69	394.9	394.17	394.2906	2240044.0
2021-11-12 13:00:00	QQQ	ETF	394.3011	394.78	393.85	394.591	2025012.0
2021-11-12 14:00:00	QQQ	ETF	394.6	394.765	393.9	394.28	1590984.0
2021-11-12 15:00:00	QQQ	ETF	394.27	395.25	394.15	394.71	5564955.0
2021-11-12 16:00:00	QQQ	ETF	394.71	395.13	394.69	394.98	1662841.0
2021-11-12 17:00:00	QQQ	ETF	394.91	395.15	394.91	395.0	80015.0
2021-11-12 18:00:00	QQQ	ETF	395.0	395.2	395.0	395.11	16893.0
2021-11-12 19:00:00	QQQ	ETF	395.11	395.14	394.96	394.98	25076.0
2021-11-12 04:00:00	IWM	ETF	239.41	239.41	239.0	239.16	8100.0
2021-11-12 05:00:00	IWM	ETF	239.14	239.66	239.14	239.66	7756.0
2021-11-12 06:00:00	IWM	ETF	239.54	239.91	239.45	239.91	20298.0
2021-11-12 07:00:00	IWM	ETF	239.93	239.99	239.76	239.83	23251.0
2021-11-12 08:00:00	IWM	ETF	239.8801	240.23	239.5	239.99	81995.0
2021-11-12 09:00:00	IWM	ETF	239.98	240.28	239.12	239.83	1984391.0
2021-11-12 10:00:00	IWM	ETF	239.83	239.97	238.74	238.99	2148640.0
2021-11-12 11:00:00	IWM	ETF	239.0	239.58	238.88	239.27	2066126.0
2021-11-12 12:00:00	IWM	ETF	239.28	239.48	238.98	239.19	1349197.0
2021-11-12 13:00:00	IWM	ETF	239.18	239.74	238.91	239.41	1324728.0
2021-11-12 14:00:00	IWM	ETF	239.41	239.48	239.02	239.43	1036348.0
2021-11-12 15:00:00	IWM	ETF	239.43	240.065	239.3	239.46	3122388.0
2021-11-12 16:00:00	IWM	ETF	239.47	239.95	239.46	239.74	1401493.0
2021-11-12 17:00:00	IWM	ETF	239.81	239.85	239.63	239.75	14857.0
2021-11-12 18:00:00	IWM	ETF	239.85	239.89	239.75	239.81	7324.0
2021-11-12 19:00:00	IWM	ETF	239.87	239.92	239.8	239.8	5049.0
2021-11-12 04:00:00	DIA	ETF	359.87	359.87	359.67	359.67	374.0
2021-11-12 05:00:00	DIA	ETF	359.95	360.19	359.95	360.19	3500.0

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

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