PREVIEW / etf_1hour / 2021-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-08.parquet
  size:    414 KB
  rows:    14,484

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-04-08 04:00:00	SPY	ETF	407.98	408.22	407.69	407.85	11173.0
2021-04-08 05:00:00	SPY	ETF	407.84	407.99	407.56	407.89	18281.0
2021-04-08 06:00:00	SPY	ETF	407.95	408.16	407.84	407.92	30545.0
2021-04-08 07:00:00	SPY	ETF	407.89	408.2	407.85	407.99	156143.0
2021-04-08 08:00:00	SPY	ETF	407.8684	408.8	407.62	407.8	338571.0
2021-04-08 09:00:00	SPY	ETF	407.8	408.05	407.16	407.72	5269459.0
2021-04-08 10:00:00	SPY	ETF	407.74	407.94	406.93	407.58	6504226.0
2021-04-08 11:00:00	SPY	ETF	407.59	408.08	407.445	407.88	4670623.0
2021-04-08 12:00:00	SPY	ETF	407.884	408.39	407.79	408.01	4063515.0
2021-04-08 13:00:00	SPY	ETF	408.01	408.28	407.835	408.07	2732122.0
2021-04-08 14:00:00	SPY	ETF	408.07	408.51	407.99	408.4553	3405318.0
2021-04-08 15:00:00	SPY	ETF	408.45	408.58	407.97	408.49	10706232.0
2021-04-08 16:00:00	SPY	ETF	408.49	409.39	408.1415	409.34	2902985.0
2021-04-08 17:00:00	SPY	ETF	409.3	409.45	409.27	409.42	58477.0
2021-04-08 18:00:00	SPY	ETF	409.37	409.37	408.52	409.3	97012.0
2021-04-08 19:00:00	SPY	ETF	409.29	409.52	409.15	409.52	45926.0
2021-04-08 04:00:00	QQQ	ETF	333.13	334.23	333.13	334.0	30110.0
2021-04-08 05:00:00	QQQ	ETF	334.02	334.31	333.58	334.31	37726.0
2021-04-08 06:00:00	QQQ	ETF	334.39	334.98	334.29	334.63	67026.0
2021-04-08 07:00:00	QQQ	ETF	334.47	334.68	334.23	334.438	116498.0
2021-04-08 08:00:00	QQQ	ETF	334.525	334.88	334.02	334.27	287448.0
2021-04-08 09:00:00	QQQ	ETF	334.31	335.23	334.0	335.145	4513991.0
2021-04-08 10:00:00	QQQ	ETF	335.15	335.27	333.7399	334.39	5234980.0
2021-04-08 11:00:00	QQQ	ETF	334.42	334.83	333.83	334.7	3153938.0
2021-04-08 12:00:00	QQQ	ETF	334.72	335.05	334.265	334.53	1949890.0
2021-04-08 13:00:00	QQQ	ETF	334.5101	334.8799	334.33	334.66	1625711.0
2021-04-08 14:00:00	QQQ	ETF	334.67	335.145	334.59	334.775	2051148.0
2021-04-08 15:00:00	QQQ	ETF	334.77	335.19	334.48	335.14	4604103.0
2021-04-08 16:00:00	QQQ	ETF	335.14	336.09	334.6351	336.06	855601.0
2021-04-08 17:00:00	QQQ	ETF	336.07	336.2	335.86	336.07	37117.0
2021-04-08 18:00:00	QQQ	ETF	336.07	336.07	335.74	336.0	53301.0
2021-04-08 19:00:00	QQQ	ETF	335.99	336.42	335.92	336.4	295852.0
2021-04-08 04:00:00	IWM	ETF	222.03	222.25	221.91	222.25	11799.0
2021-04-08 05:00:00	IWM	ETF	222.32	222.35	222.1	222.35	6153.0
2021-04-08 06:00:00	IWM	ETF	222.4	222.49	221.96	221.97	12211.0
2021-04-08 07:00:00	IWM	ETF	221.98	222.24	221.94	222.1	48949.0
2021-04-08 08:00:00	IWM	ETF	222.1399	222.49	221.51	221.96	102736.0
2021-04-08 09:00:00	IWM	ETF	221.93	222.11	220.15	220.59	2640627.0
2021-04-08 10:00:00	IWM	ETF	220.58	221.25	219.39	220.8	4129558.0
2021-04-08 11:00:00	IWM	ETF	220.815	222.21	220.77	221.785	3340127.0
2021-04-08 12:00:00	IWM	ETF	221.78	222.645	221.62	221.99	1923823.0
2021-04-08 13:00:00	IWM	ETF	221.99	222.4067	221.32	221.41	1372294.0
2021-04-08 14:00:00	IWM	ETF	221.41	222.2	221.39	222.19	1162017.0
2021-04-08 15:00:00	IWM	ETF	222.18	222.82	221.94	222.56	3390290.0
2021-04-08 16:00:00	IWM	ETF	222.56	223.3	222.55	223.24	865438.0
2021-04-08 17:00:00	IWM	ETF	223.44	223.71	223.15	223.44	213227.0
2021-04-08 18:00:00	IWM	ETF	223.42	223.44	223.06	223.278	100701.0
2021-04-08 19:00:00	IWM	ETF	223.19	223.48	223.08	223.42	31857.0
2021-04-08 04:00:00	DIA	ETF	334.66	334.66	334.42	334.42	2200.0
2021-04-08 05:00:00	DIA	ETF	334.49	334.49	334.42	334.42	200.0

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

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