PREVIEW / etf_30min / 2023-11-29

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-29.parquet
  size:    766 KB
  rows:    30,343

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-11-29 04:00:00	SPY	ETF	455.89	456.47	455.89	456.47	17426.0
2023-11-29 04:30:00	SPY	ETF	456.48	456.59	456.2	456.5	20194.0
2023-11-29 05:00:00	SPY	ETF	456.43	456.51	456.31	456.41	3530.0
2023-11-29 05:30:00	SPY	ETF	456.43	456.5	456.33	456.4	9393.0
2023-11-29 06:00:00	SPY	ETF	456.47	456.5	456.34	456.43	7044.0
2023-11-29 06:30:00	SPY	ETF	456.39	456.85	456.39	456.77	31742.0
2023-11-29 07:00:00	SPY	ETF	456.79	456.88	456.54	456.8	46367.0
2023-11-29 07:30:00	SPY	ETF	456.81	457.1	456.78	457.1	139174.0
2023-11-29 08:00:00	SPY	ETF	456.7897	457.42	455.4	457.36	342568.0
2023-11-29 08:30:00	SPY	ETF	457.36	457.63	455.49	457.09	381364.0
2023-11-29 09:00:00	SPY	ETF	457.15	457.4	456.92	457.14	171067.0
2023-11-29 09:30:00	SPY	ETF	457.15	458.32	457.0	458.11	5877480.0
2023-11-29 10:00:00	SPY	ETF	458.12	458.2513	456.1	456.475	6718120.0
2023-11-29 10:30:00	SPY	ETF	456.48	456.89	456.11	456.61	2995653.0
2023-11-29 11:00:00	SPY	ETF	456.6	456.744	455.11	455.14	3394179.0
2023-11-29 11:30:00	SPY	ETF	455.15	455.805	454.945	455.765	2377233.0
2023-11-29 12:00:00	SPY	ETF	455.765	456.215	455.55	456.19	1726935.0
2023-11-29 12:30:00	SPY	ETF	456.1901	456.38	456.1	456.29	1818498.0
2023-11-29 13:00:00	SPY	ETF	456.3	456.45	455.82	456.295	1714667.0
2023-11-29 13:30:00	SPY	ETF	456.295	456.31	455.695	456.1011	1668091.0
2023-11-29 14:00:00	SPY	ETF	456.1	456.3399	455.83	455.885	1981856.0
2023-11-29 14:30:00	SPY	ETF	455.89	455.89	455.09	455.525	2246658.0
2023-11-29 15:00:00	SPY	ETF	455.53	455.59	454.37	454.44	3461863.0
2023-11-29 15:30:00	SPY	ETF	454.44	454.67	454.2	454.62	8924601.0
2023-11-29 16:00:00	SPY	ETF	454.62	456.3079	454.5632	455.09	2319635.0
2023-11-29 16:30:00	SPY	ETF	455.11	455.15	454.85	454.89	197168.0
2023-11-29 17:00:00	SPY	ETF	454.88	454.98	454.82	454.83	23114.0
2023-11-29 17:30:00	SPY	ETF	454.83	454.95	454.83	454.92	11083.0
2023-11-29 18:00:00	SPY	ETF	454.95	455.0	454.83	454.99	12531.0
2023-11-29 18:30:00	SPY	ETF	454.95	454.95	454.79	454.86	5012.0
2023-11-29 19:00:00	SPY	ETF	454.95	454.99	454.79	454.83	2297.0
2023-11-29 19:30:00	SPY	ETF	454.82	455.07	454.82	454.93	21577.0
2023-11-29 04:00:00	QQQ	ETF	390.79	391.88	390.79	391.87	39003.0
2023-11-29 04:30:00	QQQ	ETF	391.89	392.08	391.58	391.9	25497.0
2023-11-29 05:00:00	QQQ	ETF	391.92	392.11	391.85	392.04	9470.0
2023-11-29 05:30:00	QQQ	ETF	391.98	392.04	391.88	391.98	7670.0
2023-11-29 06:00:00	QQQ	ETF	391.99	392.02	391.83	392.01	15859.0
2023-11-29 06:30:00	QQQ	ETF	391.89	392.42	391.84	392.34	8416.0
2023-11-29 07:00:00	QQQ	ETF	392.26	392.44	392.14	392.31	49742.0
2023-11-29 07:30:00	QQQ	ETF	392.4	392.6	392.29	392.6	34424.0
2023-11-29 08:00:00	QQQ	ETF	392.2603	393.0	390.482	392.92	139779.0
2023-11-29 08:30:00	QQQ	ETF	392.9	393.305	392.48	392.6399	285141.0
2023-11-29 09:00:00	QQQ	ETF	392.68	393.05	392.48	392.71	192552.0
2023-11-29 09:30:00	QQQ	ETF	392.69	394.14	392.68	393.82	3987940.0
2023-11-29 10:00:00	QQQ	ETF	393.83	394.04	391.18	391.75	4371163.0
2023-11-29 10:30:00	QQQ	ETF	391.76	392.345	391.285	392.03	2053348.0
2023-11-29 11:00:00	QQQ	ETF	392.02	392.08	390.08	390.22	2662026.0
2023-11-29 11:30:00	QQQ	ETF	390.225	390.84	389.91	390.76	1722526.0
2023-11-29 12:00:00	QQQ	ETF	390.76	391.3092	390.4301	391.28	1098885.0
2023-11-29 12:30:00	QQQ	ETF	391.29	391.47	391.2	391.345	1152319.0

> showing 50 of 30,343 rows — these rows as CSV

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