PREVIEW / etf_1hour / 2023-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-06.parquet
  size:    469 KB
  rows:    17,005

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
2023-03-06 04:00:00	SPY	ETF	404.58	404.71	404.0	404.1	30863.0
2023-03-06 05:00:00	SPY	ETF	404.13	404.41	403.89	404.38	15410.0
2023-03-06 06:00:00	SPY	ETF	404.37	404.57	403.62	403.78	70935.0
2023-03-06 07:00:00	SPY	ETF	403.73	404.39	403.68	404.39	278270.0
2023-03-06 08:00:00	SPY	ETF	403.72	405.63	403.69	405.13	616824.0
2023-03-06 09:00:00	SPY	ETF	405.14	405.85	404.76	405.76	6973360.0
2023-03-06 10:00:00	SPY	ETF	405.77	407.37	405.24	406.6499	10282510.0
2023-03-06 11:00:00	SPY	ETF	406.65	407.45	406.23	406.7899	6146162.0
2023-03-06 12:00:00	SPY	ETF	406.79	407.38	405.57	405.85	5920691.0
2023-03-06 13:00:00	SPY	ETF	405.85	405.92	404.6031	404.855	6214477.0
2023-03-06 14:00:00	SPY	ETF	404.88	405.36	404.57	404.72	6031577.0
2023-03-06 15:00:00	SPY	ETF	404.7218	405.02	404.03	404.46	12470695.0
2023-03-06 16:00:00	SPY	ETF	404.46	404.74	404.43	404.62	2512535.0
2023-03-06 17:00:00	SPY	ETF	404.61	404.63	404.45	404.55	37211.0
2023-03-06 18:00:00	SPY	ETF	404.56	404.76	404.4	404.69	68746.0
2023-03-06 19:00:00	SPY	ETF	404.69	404.9	404.58	404.75	43581.0
2023-03-06 04:00:00	QQQ	ETF	300.2	300.42	299.56	299.65	35108.0
2023-03-06 05:00:00	QQQ	ETF	299.65	300.16	299.55	300.13	22610.0
2023-03-06 06:00:00	QQQ	ETF	300.09	300.4	299.38	299.49	84259.0
2023-03-06 07:00:00	QQQ	ETF	299.5	300.17	299.48	300.17	167879.0
2023-03-06 08:00:00	QQQ	ETF	299.51	301.45	299.51	301.09	555891.0
2023-03-06 09:00:00	QQQ	ETF	301.06	301.81	300.63	301.4732	5551100.0
2023-03-06 10:00:00	QQQ	ETF	301.48	303.69	300.91	303.23	7261119.0
2023-03-06 11:00:00	QQQ	ETF	303.23	304.0	302.8373	303.335	5326201.0
2023-03-06 12:00:00	QQQ	ETF	303.34	303.54	301.51	301.83	4656079.0
2023-03-06 13:00:00	QQQ	ETF	301.82	302.04	300.79	300.96	4388281.0
2023-03-06 14:00:00	QQQ	ETF	300.98	301.4	300.41	300.58	4229299.0
2023-03-06 15:00:00	QQQ	ETF	300.59	300.88	299.82	300.03	8731638.0
2023-03-06 16:00:00	QQQ	ETF	300.05	300.1	299.86	299.97	1944971.0
2023-03-06 17:00:00	QQQ	ETF	299.98	300.09	299.94	299.9859	385878.0
2023-03-06 18:00:00	QQQ	ETF	299.98	300.29	299.8	300.21	59973.0
2023-03-06 19:00:00	QQQ	ETF	300.2	300.37	300.07	300.2	82434.0
2023-03-06 04:00:00	IWM	ETF	191.63	191.7	191.39	191.42	19875.0
2023-03-06 05:00:00	IWM	ETF	191.49	191.55	191.34	191.54	6474.0
2023-03-06 06:00:00	IWM	ETF	191.48	191.6	191.15	191.21	10546.0
2023-03-06 07:00:00	IWM	ETF	191.24	191.6	191.21	191.55	18933.0
2023-03-06 08:00:00	IWM	ETF	191.35	192.14	191.2296	191.87	47731.0
2023-03-06 09:00:00	IWM	ETF	191.83	191.86	190.62	190.89	2048078.0
2023-03-06 10:00:00	IWM	ETF	190.88	191.39	190.49	190.51	2706694.0
2023-03-06 11:00:00	IWM	ETF	190.51	190.805	189.9	190.08	1920608.0
2023-03-06 12:00:00	IWM	ETF	190.08	190.24	189.0	189.105	1970384.0
2023-03-06 13:00:00	IWM	ETF	189.1	189.1902	188.45	188.59	1692484.0
2023-03-06 14:00:00	IWM	ETF	188.6	188.84	188.2	188.27	1841175.0
2023-03-06 15:00:00	IWM	ETF	188.3	188.75	187.9	188.7	4486354.0
2023-03-06 16:00:00	IWM	ETF	188.7	189.2761	188.68	188.71	824123.0
2023-03-06 17:00:00	IWM	ETF	188.75	188.88	188.65	188.65	12188.0
2023-03-06 18:00:00	IWM	ETF	188.73	188.87	188.64	188.83	19132.0
2023-03-06 19:00:00	IWM	ETF	188.8	188.91	188.74	188.8	31871.0
2023-03-06 04:00:00	DIA	ETF	334.38	334.38	334.11	334.11	3200.0
2023-03-06 05:00:00	DIA	ETF	334.21	334.21	334.21	334.21	2000.0

> showing 50 of 17,005 rows — these rows as CSV

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