PREVIEW / etf_30min / 2021-09-30

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-30.parquet
  size:    643 KB
  rows:    24,536

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
2021-09-30 04:00:00	SPY	ETF	437.02	438.0	437.02	437.33	75379.0
2021-09-30 04:30:00	SPY	ETF	437.16	437.48	437.15	437.48	11956.0
2021-09-30 05:00:00	SPY	ETF	437.41	437.58	437.11	437.11	6599.0
2021-09-30 05:30:00	SPY	ETF	437.17	437.3	436.38	436.5	9525.0
2021-09-30 06:00:00	SPY	ETF	436.47	436.79	435.81	435.94	14053.0
2021-09-30 06:30:00	SPY	ETF	435.89	436.46	435.8	436.05	100132.0
2021-09-30 07:00:00	SPY	ETF	436.0	436.45	435.75	436.19	86884.0
2021-09-30 07:30:00	SPY	ETF	436.18	436.23	435.54	435.92	106062.0
2021-09-30 08:00:00	SPY	ETF	435.8001	437.75	435.58	435.94	229707.0
2021-09-30 08:30:00	SPY	ETF	435.85	436.4	435.76	435.84	251697.0
2021-09-30 09:00:00	SPY	ETF	435.88	436.0	435.16	436.0	551756.0
2021-09-30 09:30:00	SPY	ETF	436.02	436.77	435.25	435.84	6600407.0
2021-09-30 10:00:00	SPY	ETF	435.82	436.11	434.65	435.13	6271722.0
2021-09-30 10:30:00	SPY	ETF	435.13	435.31	433.38	433.73	5564235.0
2021-09-30 11:00:00	SPY	ETF	433.73	435.13	433.42	434.71	4171161.0
2021-09-30 11:30:00	SPY	ETF	434.72	434.74	431.52	432.2699	6679937.0
2021-09-30 12:00:00	SPY	ETF	432.27	432.47	430.09	430.4	7917546.0
2021-09-30 12:30:00	SPY	ETF	430.38	431.4701	430.0	430.855	6409255.0
2021-09-30 13:00:00	SPY	ETF	430.85	432.26	430.61	430.9105	5614667.0
2021-09-30 13:30:00	SPY	ETF	430.9	431.89	430.42	431.89	4541050.0
2021-09-30 14:00:00	SPY	ETF	431.87	433.2	431.8	432.69	5061963.0
2021-09-30 14:30:00	SPY	ETF	432.68	433.86	432.3401	432.38	5755968.0
2021-09-30 15:00:00	SPY	ETF	432.4	433.6	431.93	432.28	7502448.0
2021-09-30 15:30:00	SPY	ETF	432.27	433.1801	428.78	429.16	24834671.0
2021-09-30 16:00:00	SPY	ETF	429.16	430.04	429.01	429.36	9464521.0
2021-09-30 16:30:00	SPY	ETF	429.4	429.45	429.07	429.38	378182.0
2021-09-30 17:00:00	SPY	ETF	429.32	429.58	429.31	429.55	103204.0
2021-09-30 17:30:00	SPY	ETF	429.5301	429.56	429.44	429.47	46551.0
2021-09-30 18:00:00	SPY	ETF	429.47	429.99	429.32	429.43	179872.0
2021-09-30 18:30:00	SPY	ETF	429.14	429.85	429.14	429.85	77635.0
2021-09-30 19:00:00	SPY	ETF	429.88	430.31	429.14	430.27	61623.0
2021-09-30 19:30:00	SPY	ETF	430.28	430.34	429.8	430.05	79943.0
2021-09-30 04:00:00	QQQ	ETF	361.3	362.51	361.3	361.9	41524.0
2021-09-30 04:30:00	QQQ	ETF	361.78	361.9	361.5	361.84	7718.0
2021-09-30 05:00:00	QQQ	ETF	361.9	361.92	361.29	361.49	9472.0
2021-09-30 05:30:00	QQQ	ETF	361.5	361.66	360.84	361.03	39283.0
2021-09-30 06:00:00	QQQ	ETF	361.06	361.35	360.4	360.65	20027.0
2021-09-30 06:30:00	QQQ	ETF	360.69	361.09	360.5	360.95	31478.0
2021-09-30 07:00:00	QQQ	ETF	360.77	361.3	360.5	361.08	65580.0
2021-09-30 07:30:00	QQQ	ETF	361.04	361.07	360.57	360.9	49545.0
2021-09-30 08:00:00	QQQ	ETF	360.5599	362.72	360.54	360.82	116214.0
2021-09-30 08:30:00	QQQ	ETF	360.9	361.31	360.84	360.92	165052.0
2021-09-30 09:00:00	QQQ	ETF	360.89	360.98	360.21	360.98	241117.0
2021-09-30 09:30:00	QQQ	ETF	361.02	362.68	360.93	361.81	5912028.0
2021-09-30 10:00:00	QQQ	ETF	361.78	362.42	360.89	361.47	4032854.0
2021-09-30 10:30:00	QQQ	ETF	361.46	361.69	360.11	360.41	3599430.0
2021-09-30 11:00:00	QQQ	ETF	360.41	361.76	360.13	361.52	2606714.0
2021-09-30 11:30:00	QQQ	ETF	361.54	361.58	358.76	359.57	4027799.0
2021-09-30 12:00:00	QQQ	ETF	359.61	359.7	357.99	358.29	4240356.0
2021-09-30 12:30:00	QQQ	ETF	358.28	359.3	357.1	358.8055	2577385.0

> showing 50 of 24,536 rows — these rows as CSV

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