PREVIEW / etf_30min / 2023-05-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-10.parquet
  size:    686 KB
  rows:    27,219

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-05-10 04:00:00	SPY	ETF	410.32	410.49	409.71	410.49	33491.0
2023-05-10 04:30:00	SPY	ETF	410.45	410.59	410.45	410.54	4129.0
2023-05-10 05:00:00	SPY	ETF	410.51	410.61	410.25	410.52	2717.0
2023-05-10 05:30:00	SPY	ETF	410.57	410.68	410.4	410.55	51768.0
2023-05-10 06:00:00	SPY	ETF	410.55	410.56	410.28	410.45	63157.0
2023-05-10 06:30:00	SPY	ETF	410.42	410.5	410.34	410.38	6340.0
2023-05-10 07:00:00	SPY	ETF	410.42	410.66	410.33	410.65	48031.0
2023-05-10 07:30:00	SPY	ETF	410.57	410.75	410.49	410.54	130142.0
2023-05-10 08:00:00	SPY	ETF	410.3508	411.6	409.7704	410.6	413290.0
2023-05-10 08:30:00	SPY	ETF	410.5	414.48	410.5	414.25	1937565.0
2023-05-10 09:00:00	SPY	ETF	414.26	414.91	413.77	413.89	747742.0
2023-05-10 09:30:00	SPY	ETF	413.88	414.535	411.5001	412.491	8804672.0
2023-05-10 10:00:00	SPY	ETF	412.49	413.73	411.73	412.11	6722209.0
2023-05-10 10:30:00	SPY	ETF	412.12	412.5599	410.18	410.919	5730639.0
2023-05-10 11:00:00	SPY	ETF	410.91	412.07	410.86	411.92	3724156.0
2023-05-10 11:30:00	SPY	ETF	411.915	412.42	411.52	411.675	3369609.0
2023-05-10 12:00:00	SPY	ETF	411.68	411.71	410.9	411.3883	2480815.0
2023-05-10 12:30:00	SPY	ETF	411.39	411.5	410.42	410.65	2014383.0
2023-05-10 13:00:00	SPY	ETF	410.66	410.74	408.9719	409.22	4062435.0
2023-05-10 13:30:00	SPY	ETF	409.222	410.28	408.87	410.1	3911475.0
2023-05-10 14:00:00	SPY	ETF	410.08	411.25	410.075	411.01	4072743.0
2023-05-10 14:30:00	SPY	ETF	411.01	412.2	411.01	412.01	3848401.0
2023-05-10 15:00:00	SPY	ETF	412.01	413.61	411.82	413.18	6465484.0
2023-05-10 15:30:00	SPY	ETF	413.18	413.79	412.57	412.8	12474674.0
2023-05-10 16:00:00	SPY	ETF	412.79	413.23	412.75	412.95	2987425.0
2023-05-10 16:30:00	SPY	ETF	412.95	413.02	412.84	412.86	86420.0
2023-05-10 17:00:00	SPY	ETF	412.91	412.95	412.8	412.85	37546.0
2023-05-10 17:30:00	SPY	ETF	412.85	412.85	412.6	412.79	68026.0
2023-05-10 18:00:00	SPY	ETF	412.78	413.07	412.74	413.04	73229.0
2023-05-10 18:30:00	SPY	ETF	412.99	413.09	412.99	413.07	10558.0
2023-05-10 19:00:00	SPY	ETF	413.04	413.14	412.95	413.07	10105.0
2023-05-10 19:30:00	SPY	ETF	413.07	413.47	412.99	413.32	48979.0
2023-05-10 04:00:00	QQQ	ETF	320.75	320.98	320.2	320.93	26193.0
2023-05-10 04:30:00	QQQ	ETF	320.94	321.0	320.83	320.98	9070.0
2023-05-10 05:00:00	QQQ	ETF	320.84	320.98	320.69	320.98	3484.0
2023-05-10 05:30:00	QQQ	ETF	321.05	321.19	320.96	320.98	6898.0
2023-05-10 06:00:00	QQQ	ETF	320.9	321.0	320.77	320.92	9925.0
2023-05-10 06:30:00	QQQ	ETF	320.96	321.19	320.96	321.13	5471.0
2023-05-10 07:00:00	QQQ	ETF	321.17	321.6	321.09	321.55	52524.0
2023-05-10 07:30:00	QQQ	ETF	321.53	321.69	321.42	321.57	85552.0
2023-05-10 08:00:00	QQQ	ETF	321.56	322.02	320.6996	321.39	298897.0
2023-05-10 08:30:00	QQQ	ETF	321.65	324.71	321.61	324.5	2197174.0
2023-05-10 09:00:00	QQQ	ETF	324.54	325.07	324.08	324.11	1166749.0
2023-05-10 09:30:00	QQQ	ETF	324.11	325.34	323.04	324.36	7081655.0
2023-05-10 10:00:00	QQQ	ETF	324.37	325.72	324.18	324.8	5748399.0
2023-05-10 10:30:00	QQQ	ETF	324.81	325.21	322.46	323.0	4862329.0
2023-05-10 11:00:00	QQQ	ETF	323.01	324.175	322.99	324.09	2157730.0
2023-05-10 11:30:00	QQQ	ETF	324.095	324.73	324.0201	324.13	2291133.0
2023-05-10 12:00:00	QQQ	ETF	324.11	324.12	323.29	323.8811	1683653.0
2023-05-10 12:30:00	QQQ	ETF	323.86	324.22	323.06	323.29	1518047.0

> showing 50 of 27,219 rows — these rows as CSV

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