PREVIEW / etf_30min / 2023-10-05

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-05.parquet
  size:    697 KB
  rows:    28,052

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-10-05 04:00:00	SPY	ETF	424.06	424.76	423.75	424.75	21318.0
2023-10-05 04:30:00	SPY	ETF	424.55	424.82	423.66	423.71	4661.0
2023-10-05 05:00:00	SPY	ETF	423.6	423.74	423.22	423.37	5183.0
2023-10-05 05:30:00	SPY	ETF	423.55	423.68	423.21	423.6	7771.0
2023-10-05 06:00:00	SPY	ETF	423.47	424.25	423.47	424.13	8510.0
2023-10-05 06:30:00	SPY	ETF	424.18	424.65	424.18	424.53	23678.0
2023-10-05 07:00:00	SPY	ETF	424.48	424.73	424.0	424.52	140183.0
2023-10-05 07:30:00	SPY	ETF	424.5	425.11	424.5	425.05	121317.0
2023-10-05 08:00:00	SPY	ETF	424.93	425.45	423.73	424.74	175405.0
2023-10-05 08:30:00	SPY	ETF	424.74	424.74	423.13	423.86	579453.0
2023-10-05 09:00:00	SPY	ETF	423.9	424.74	423.46	424.37	300096.0
2023-10-05 09:30:00	SPY	ETF	424.36	425.26	423.33	424.13	5350055.0
2023-10-05 10:00:00	SPY	ETF	424.14	424.15	422.67	423.425	5320466.0
2023-10-05 10:30:00	SPY	ETF	423.42	423.5	421.645	421.9801	4854100.0
2023-10-05 11:00:00	SPY	ETF	421.98	422.415	421.1701	421.99	3963194.0
2023-10-05 11:30:00	SPY	ETF	422.0	422.6	421.55	422.03	3793850.0
2023-10-05 12:00:00	SPY	ETF	422.0291	423.24	421.85	423.17	3080869.0
2023-10-05 12:30:00	SPY	ETF	423.165	423.45	422.29	422.6199	2932923.0
2023-10-05 13:00:00	SPY	ETF	422.62	422.97	421.87	422.915	2426841.0
2023-10-05 13:30:00	SPY	ETF	422.915	424.1999	422.46	424.07	4590951.0
2023-10-05 14:00:00	SPY	ETF	424.095	424.58	423.8908	424.28	3290471.0
2023-10-05 14:30:00	SPY	ETF	424.275	425.37	424.27	425.04	3852966.0
2023-10-05 15:00:00	SPY	ETF	425.065	425.18	424.18	424.89	3605696.0
2023-10-05 15:30:00	SPY	ETF	424.88	424.98	424.205	424.46	6711406.0
2023-10-05 16:00:00	SPY	ETF	424.46	425.0	421.7526	424.0	2075801.0
2023-10-05 16:30:00	SPY	ETF	424.0	424.25	423.99	424.22	112459.0
2023-10-05 17:00:00	SPY	ETF	424.26	424.27	423.84	424.0536	56664.0
2023-10-05 17:30:00	SPY	ETF	424.1098	424.13	424.0	424.11	11222.0
2023-10-05 18:00:00	SPY	ETF	424.1	424.22	424.1	424.2	11262.0
2023-10-05 18:30:00	SPY	ETF	424.19	424.29	424.16	424.27	5841.0
2023-10-05 19:00:00	SPY	ETF	424.17	424.22	424.05	424.1	6773.0
2023-10-05 19:30:00	SPY	ETF	424.09	424.09	423.91	423.96	15914.0
2023-10-05 04:00:00	QQQ	ETF	359.14	359.83	359.09	359.71	25625.0
2023-10-05 04:30:00	QQQ	ETF	359.65	359.94	358.8	358.8	24119.0
2023-10-05 05:00:00	QQQ	ETF	358.8	359.1	358.52	358.9	27690.0
2023-10-05 05:30:00	QQQ	ETF	358.76	359.05	358.41	358.92	16657.0
2023-10-05 06:00:00	QQQ	ETF	358.82	359.57	358.68	359.5	24335.0
2023-10-05 06:30:00	QQQ	ETF	359.53	359.96	359.45	359.87	32182.0
2023-10-05 07:00:00	QQQ	ETF	359.84	360.1	359.4	359.85	126246.0
2023-10-05 07:30:00	QQQ	ETF	359.88	360.63	359.88	360.59	72461.0
2023-10-05 08:00:00	QQQ	ETF	359.8	360.89	358.6596	360.16	205702.0
2023-10-05 08:30:00	QQQ	ETF	360.23	360.39	358.58	359.27	522364.0
2023-10-05 09:00:00	QQQ	ETF	359.28	360.0	358.95	359.74	433926.0
2023-10-05 09:30:00	QQQ	ETF	359.74	360.15	357.57	358.0075	4248143.0
2023-10-05 10:00:00	QQQ	ETF	358.01	358.03	356.27	357.14	3604058.0
2023-10-05 10:30:00	QQQ	ETF	357.13	357.22	355.14	355.5754	3741772.0
2023-10-05 11:00:00	QQQ	ETF	355.575	356.35	355.18	356.1	2776394.0
2023-10-05 11:30:00	QQQ	ETF	356.11	357.0	355.6	356.363	2787951.0
2023-10-05 12:00:00	QQQ	ETF	356.37	357.71	356.1916	357.64	2247870.0
2023-10-05 12:30:00	QQQ	ETF	357.64	357.91	356.81	357.22	1460664.0

> showing 50 of 28,052 rows — these rows as CSV

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