PREVIEW / etf_30min / 2023-10-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-27.parquet
  size:    711 KB
  rows:    28,831

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-27 04:00:00	SPY	ETF	414.5	414.96	414.4	414.89	18506.0
2023-10-27 04:30:00	SPY	ETF	414.95	415.35	414.87	415.35	15875.0
2023-10-27 05:00:00	SPY	ETF	415.3	415.4	414.89	414.95	15185.0
2023-10-27 05:30:00	SPY	ETF	414.89	415.0	414.54	414.7	25860.0
2023-10-27 06:00:00	SPY	ETF	414.72	414.97	414.72	414.75	7856.0
2023-10-27 06:30:00	SPY	ETF	414.61	414.7	414.22	414.27	11226.0
2023-10-27 07:00:00	SPY	ETF	414.26	414.38	413.49	413.57	105177.0
2023-10-27 07:30:00	SPY	ETF	413.55	413.68	413.11	413.2	94369.0
2023-10-27 08:00:00	SPY	ETF	414.31	415.14	413.0504	413.95	285725.0
2023-10-27 08:30:00	SPY	ETF	414.0	414.74	413.43	414.28	405637.0
2023-10-27 09:00:00	SPY	ETF	414.24	414.77	414.11	414.19	284526.0
2023-10-27 09:30:00	SPY	ETF	414.19	414.47	412.62	413.29	7026081.0
2023-10-27 10:00:00	SPY	ETF	413.3	414.13	412.385	413.0	7057756.0
2023-10-27 10:30:00	SPY	ETF	413.01	413.6	411.865	413.52	5469988.0
2023-10-27 11:00:00	SPY	ETF	413.52	414.6	413.18	413.94	4491899.0
2023-10-27 11:30:00	SPY	ETF	413.95	414.025	412.81	413.4599	3728642.0
2023-10-27 12:00:00	SPY	ETF	413.423	413.58	412.025	412.52	3475428.0
2023-10-27 12:30:00	SPY	ETF	412.53	412.95	411.67	411.8	3651641.0
2023-10-27 13:00:00	SPY	ETF	411.815	412.03	410.31	410.765	6389908.0
2023-10-27 13:30:00	SPY	ETF	410.77	411.13	410.12	410.4	4542970.0
2023-10-27 14:00:00	SPY	ETF	410.39	410.99	409.61	409.82	5702543.0
2023-10-27 14:30:00	SPY	ETF	409.83	411.22	409.26	409.56	5817310.0
2023-10-27 15:00:00	SPY	ETF	409.55	410.5	409.375	410.41	6481322.0
2023-10-27 15:30:00	SPY	ETF	410.405	410.91	409.21	410.73	16290071.0
2023-10-27 16:00:00	SPY	ETF	410.73	412.9909	409.5007	410.8	3030551.0
2023-10-27 16:30:00	SPY	ETF	410.78	410.93	410.6	410.62	127942.0
2023-10-27 17:00:00	SPY	ETF	410.62	410.65	410.04	410.5	68985.0
2023-10-27 17:30:00	SPY	ETF	410.52	410.67	410.51	410.67	22909.0
2023-10-27 18:00:00	SPY	ETF	410.66	411.0	410.66	411.0	27203.0
2023-10-27 18:30:00	SPY	ETF	410.96	411.08	410.88	411.08	24280.0
2023-10-27 19:00:00	SPY	ETF	411.08	411.25	410.81	410.81	22745.0
2023-10-27 19:30:00	SPY	ETF	410.81	410.81	410.22	410.35	38842.0
2023-10-27 04:00:00	QQQ	ETF	346.42	346.69	346.27	346.6	37365.0
2023-10-27 04:30:00	QQQ	ETF	346.62	347.2	346.62	347.2	33820.0
2023-10-27 05:00:00	QQQ	ETF	347.19	347.3	346.93	346.93	21747.0
2023-10-27 05:30:00	QQQ	ETF	346.92	347.01	346.62	346.9	15841.0
2023-10-27 06:00:00	QQQ	ETF	346.95	347.2	346.86	346.92	25275.0
2023-10-27 06:30:00	QQQ	ETF	346.75	347.01	346.52	346.59	66806.0
2023-10-27 07:00:00	QQQ	ETF	346.6	346.78	346.0	346.15	216514.0
2023-10-27 07:30:00	QQQ	ETF	346.05	346.41	345.73	345.8	215747.0
2023-10-27 08:00:00	QQQ	ETF	346.5985	347.24	343.917	346.18	341168.0
2023-10-27 08:30:00	QQQ	ETF	346.07	347.07	345.69	346.6	483797.0
2023-10-27 09:00:00	QQQ	ETF	346.63	347.0	346.27	346.39	256572.0
2023-10-27 09:30:00	QQQ	ETF	346.43	347.62	346.065	346.92	6843868.0
2023-10-27 10:00:00	QQQ	ETF	346.92	347.97	346.13	346.91	4797801.0
2023-10-27 10:30:00	QQQ	ETF	346.89	347.52	345.6525	347.15	3945321.0
2023-10-27 11:00:00	QQQ	ETF	347.15	348.84	346.89	348.41	3986962.0
2023-10-27 11:30:00	QQQ	ETF	348.42	348.52	347.155	348.01	2261552.0
2023-10-27 12:00:00	QQQ	ETF	348.0	348.28	346.6	347.09	2321023.0
2023-10-27 12:30:00	QQQ	ETF	347.14	347.58	346.13	346.33	1826786.0

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

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