PREVIEW / etf_30min / 2023-06-30

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-30.parquet
  size:    714 KB
  rows:    28,251

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-06-30 04:00:00	SPY	ETF	438.65	438.97	438.35	438.77	42411.0
2023-06-30 04:30:00	SPY	ETF	438.85	439.28	438.78	439.28	6880.0
2023-06-30 05:00:00	SPY	ETF	439.35	439.6	439.23	439.6	18246.0
2023-06-30 05:30:00	SPY	ETF	439.57	439.73	439.53	439.63	16966.0
2023-06-30 06:00:00	SPY	ETF	439.56	439.85	439.55	439.81	4567.0
2023-06-30 06:30:00	SPY	ETF	439.84	440.24	439.79	440.01	52872.0
2023-06-30 07:00:00	SPY	ETF	439.97	440.12	439.78	439.82	70718.0
2023-06-30 07:30:00	SPY	ETF	439.8	439.87	439.67	439.79	90234.0
2023-06-30 08:00:00	SPY	ETF	439.9514	440.13	438.36	440.0	176640.0
2023-06-30 08:30:00	SPY	ETF	440.04	441.22	439.8	441.06	659158.0
2023-06-30 09:00:00	SPY	ETF	441.08	441.67	441.06	441.44	426908.0
2023-06-30 09:30:00	SPY	ETF	441.44	442.6695	441.11	442.32	8387100.0
2023-06-30 10:00:00	SPY	ETF	442.34	443.32	442.32	443.0	7181602.0
2023-06-30 10:30:00	SPY	ETF	443.0	443.36	442.04	442.655	5823899.0
2023-06-30 11:00:00	SPY	ETF	442.66	443.12	442.52	442.695	3612728.0
2023-06-30 11:30:00	SPY	ETF	442.68	442.685	442.01	442.46	3477604.0
2023-06-30 12:00:00	SPY	ETF	442.46	443.0592	442.22	443.0501	2822654.0
2023-06-30 12:30:00	SPY	ETF	443.06	443.61	442.99	443.49	3595975.0
2023-06-30 13:00:00	SPY	ETF	443.5	443.595	443.26	443.5201	2871269.0
2023-06-30 13:30:00	SPY	ETF	443.53	443.95	443.445	443.8	3321590.0
2023-06-30 14:00:00	SPY	ETF	443.8	444.13	443.63	444.06	2726060.0
2023-06-30 14:30:00	SPY	ETF	444.06	444.1	443.61	443.88	2997876.0
2023-06-30 15:00:00	SPY	ETF	443.88	444.14	443.59	444.02	3984924.0
2023-06-30 15:30:00	SPY	ETF	444.02	444.3	443.18	443.25	15823405.0
2023-06-30 16:00:00	SPY	ETF	443.24	443.4351	442.67	442.82	5981899.0
2023-06-30 16:30:00	SPY	ETF	442.77	443.0	442.73	442.85	262431.0
2023-06-30 17:00:00	SPY	ETF	442.95	443.4351	442.7	442.85	157873.0
2023-06-30 17:30:00	SPY	ETF	442.84	443.28	442.75	442.85	715195.0
2023-06-30 18:00:00	SPY	ETF	442.81	442.81	442.71	442.73	18555.0
2023-06-30 18:30:00	SPY	ETF	442.81	442.86	442.75	442.84	6505.0
2023-06-30 19:00:00	SPY	ETF	442.9	442.93	442.86	442.86	4663.0
2023-06-30 19:30:00	SPY	ETF	442.89	442.94	442.4	442.81	19738.0
2023-06-30 04:00:00	QQQ	ETF	364.95	365.3	364.94	365.0	27635.0
2023-06-30 04:30:00	QQQ	ETF	365.04	365.55	365.01	365.47	10926.0
2023-06-30 05:00:00	QQQ	ETF	365.45	365.8	365.43	365.8	19800.0
2023-06-30 05:30:00	QQQ	ETF	365.78	365.83	365.59	365.63	8507.0
2023-06-30 06:00:00	QQQ	ETF	365.6	365.7	365.48	365.6	8053.0
2023-06-30 06:30:00	QQQ	ETF	365.55	365.93	365.51	365.7	18759.0
2023-06-30 07:00:00	QQQ	ETF	365.69	365.94	365.57	365.63	50615.0
2023-06-30 07:30:00	QQQ	ETF	365.63	365.76	365.55	365.66	64097.0
2023-06-30 08:00:00	QQQ	ETF	365.7204	366.14	364.62	366.02	248831.0
2023-06-30 08:30:00	QQQ	ETF	366.0	367.73	366.0	367.18	1047140.0
2023-06-30 09:00:00	QQQ	ETF	367.18	367.83	367.16	367.55	684344.0
2023-06-30 09:30:00	QQQ	ETF	367.55	369.41	367.23	369.05	6284760.0
2023-06-30 10:00:00	QQQ	ETF	369.09	370.49	368.95	369.9499	4721038.0
2023-06-30 10:30:00	QQQ	ETF	369.94	370.33	369.17	369.47	3616390.0
2023-06-30 11:00:00	QQQ	ETF	369.47	370.06	369.2	369.3599	2492990.0
2023-06-30 11:30:00	QQQ	ETF	369.35	369.35	368.3	368.97	3381134.0
2023-06-30 12:00:00	QQQ	ETF	368.98	369.4	368.7505	369.38	1604889.0
2023-06-30 12:30:00	QQQ	ETF	369.38	370.1	369.345	370.01	1865609.0

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

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