PREVIEW / etf_30min / 2023-05-08

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-08.parquet
  size:    674 KB
  rows:    26,944

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-08 04:00:00	SPY	ETF	412.72	412.84	412.58	412.78	13159.0
2023-05-08 04:30:00	SPY	ETF	412.74	412.83	412.52	412.58	4126.0
2023-05-08 05:00:00	SPY	ETF	412.58	412.75	412.58	412.74	4182.0
2023-05-08 05:30:00	SPY	ETF	412.7	412.91	412.7	412.87	4743.0
2023-05-08 06:00:00	SPY	ETF	412.91	413.2	412.91	413.02	7309.0
2023-05-08 06:30:00	SPY	ETF	413.02	413.18	413.0	413.09	39649.0
2023-05-08 07:00:00	SPY	ETF	413.1	413.4	413.09	413.29	87970.0
2023-05-08 07:30:00	SPY	ETF	413.291	413.41	413.18	413.32	37241.0
2023-05-08 08:00:00	SPY	ETF	413.3493	413.6	412.17	413.47	218625.0
2023-05-08 08:30:00	SPY	ETF	413.46	413.48	412.97	413.15	143427.0
2023-05-08 09:00:00	SPY	ETF	413.15	413.2	412.84	412.95	566216.0
2023-05-08 09:30:00	SPY	ETF	412.96	413.13	411.89	412.1726	5030225.0
2023-05-08 10:00:00	SPY	ETF	412.23	412.51	411.76	411.84	3300233.0
2023-05-08 10:30:00	SPY	ETF	411.85	412.58	411.68	412.3901	3064537.0
2023-05-08 11:00:00	SPY	ETF	412.4	412.85	412.05	412.12	2318401.0
2023-05-08 11:30:00	SPY	ETF	412.12	412.73	411.84	412.64	1791602.0
2023-05-08 12:00:00	SPY	ETF	412.65	412.7703	412.06	412.36	1711617.0
2023-05-08 12:30:00	SPY	ETF	412.37	412.5	411.99	412.27	1929567.0
2023-05-08 13:00:00	SPY	ETF	412.28	412.61	412.09	412.43	1877183.0
2023-05-08 13:30:00	SPY	ETF	412.465	412.94	412.455	412.76	2088387.0
2023-05-08 14:00:00	SPY	ETF	412.77	412.97	411.28	412.79	4743653.0
2023-05-08 14:30:00	SPY	ETF	412.8	413.24	412.77	413.12	2561567.0
2023-05-08 15:00:00	SPY	ETF	413.13	413.18	412.42	412.5699	2613258.0
2023-05-08 15:30:00	SPY	ETF	412.56	413.1	412.46	412.79	5440581.0
2023-05-08 16:00:00	SPY	ETF	412.79	412.92	412.56	412.8	1689839.0
2023-05-08 16:30:00	SPY	ETF	412.79	412.84	412.61	412.61	221560.0
2023-05-08 17:00:00	SPY	ETF	412.54	412.8	412.45	412.68	40375.0
2023-05-08 17:30:00	SPY	ETF	412.6	412.7	412.55	412.62	6281.0
2023-05-08 18:00:00	SPY	ETF	412.62	412.62	412.49	412.58	13167.0
2023-05-08 18:30:00	SPY	ETF	412.54	412.55	412.48	412.55	5704.0
2023-05-08 19:00:00	SPY	ETF	412.54	412.6	412.49	412.49	10948.0
2023-05-08 19:30:00	SPY	ETF	412.48	412.54	412.45	412.54	17169.0
2023-05-08 04:00:00	QQQ	ETF	322.83	322.88	322.42	322.57	29313.0
2023-05-08 04:30:00	QQQ	ETF	322.6	322.61	322.36	322.44	4266.0
2023-05-08 05:00:00	QQQ	ETF	322.42	322.53	322.38	322.53	4911.0
2023-05-08 05:30:00	QQQ	ETF	322.48	322.72	322.48	322.72	3089.0
2023-05-08 06:00:00	QQQ	ETF	322.68	322.85	322.62	322.69	9227.0
2023-05-08 06:30:00	QQQ	ETF	322.66	322.71	322.57	322.62	4993.0
2023-05-08 07:00:00	QQQ	ETF	322.68	322.97	322.6	322.92	88858.0
2023-05-08 07:30:00	QQQ	ETF	322.93	322.96	322.64	322.75	89795.0
2023-05-08 08:00:00	QQQ	ETF	322.76	323.132	322.5596	322.75	156701.0
2023-05-08 08:30:00	QQQ	ETF	322.72	322.8	322.09	322.28	198760.0
2023-05-08 09:00:00	QQQ	ETF	322.23	322.42	322.14	322.4	140495.0
2023-05-08 09:30:00	QQQ	ETF	322.42	322.6399	321.46	321.69	4197076.0
2023-05-08 10:00:00	QQQ	ETF	321.7	322.16	321.51	321.71	2404017.0
2023-05-08 10:30:00	QQQ	ETF	321.72	322.34	321.315	322.14	2118434.0
2023-05-08 11:00:00	QQQ	ETF	322.15	322.65	322.09	322.1576	1820149.0
2023-05-08 11:30:00	QQQ	ETF	322.16	322.96	321.925	322.93	1710969.0
2023-05-08 12:00:00	QQQ	ETF	322.93	323.0	322.59	322.7912	1383121.0
2023-05-08 12:30:00	QQQ	ETF	322.8	323.11	322.625	323.06	1366073.0

> showing 50 of 26,944 rows — these rows as CSV

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