PREVIEW / etf_30min / 2024-03-15

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-15.parquet
  size:    783 KB
  rows:    31,288

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
2024-03-15 04:00:00	SPY	ETF	512.65	513.24	512.61	513.16	80614.0
2024-03-15 04:30:00	SPY	ETF	513.25	513.43	513.02	513.4	9590.0
2024-03-15 05:00:00	SPY	ETF	513.4	513.74	513.4	513.58	15748.0
2024-03-15 05:30:00	SPY	ETF	513.67	514.19	513.67	514.04	7012.0
2024-03-15 06:00:00	SPY	ETF	514.07	514.32	514.07	514.19	13841.0
2024-03-15 06:30:00	SPY	ETF	514.25	514.55	514.24	514.38	22210.0
2024-03-15 07:00:00	SPY	ETF	514.34	514.51	514.2	514.41	28706.0
2024-03-15 07:30:00	SPY	ETF	514.42	514.5	513.92	514.0	69520.0
2024-03-15 08:00:00	SPY	ETF	514.03	514.52	512.62	513.73	145540.0
2024-03-15 08:30:00	SPY	ETF	513.86	513.95	513.15	513.53	245960.0
2024-03-15 09:00:00	SPY	ETF	513.51	513.61	510.1	510.22	997015.0
2024-03-15 09:30:00	SPY	ETF	510.22	511.33	509.62	509.84	9847937.0
2024-03-15 10:00:00	SPY	ETF	509.83	510.71	508.87	510.42	5525190.0
2024-03-15 10:30:00	SPY	ETF	510.41	511.7	510.185	511.08	3425918.0
2024-03-15 11:00:00	SPY	ETF	511.1	511.19	510.12	510.7	2698498.0
2024-03-15 11:30:00	SPY	ETF	510.7	510.835	509.54	509.71	2861253.0
2024-03-15 12:00:00	SPY	ETF	509.7	509.89	508.93	509.17	3091199.0
2024-03-15 12:30:00	SPY	ETF	509.16	509.66	508.36	508.46	3496948.0
2024-03-15 13:00:00	SPY	ETF	508.47	509.78	508.43	509.32	2967960.0
2024-03-15 13:30:00	SPY	ETF	509.33	509.95	509.04	509.905	2501304.0
2024-03-15 14:00:00	SPY	ETF	509.92	510.12	509.18	509.5399	3108828.0
2024-03-15 14:30:00	SPY	ETF	509.54	510.545	509.47	510.19	2996214.0
2024-03-15 15:00:00	SPY	ETF	510.19	510.53	509.63	510.14	3586238.0
2024-03-15 15:30:00	SPY	ETF	510.13	510.2112	509.22	509.74	10553665.0
2024-03-15 16:00:00	SPY	ETF	509.75	510.13	509.57	510.09	4679494.0
2024-03-15 16:30:00	SPY	ETF	510.09	510.2	509.67	509.7	442284.0
2024-03-15 17:00:00	SPY	ETF	509.84	510.0	509.7135	509.83	130005.0
2024-03-15 17:30:00	SPY	ETF	509.85	509.91	509.72	509.75	116672.0
2024-03-15 18:00:00	SPY	ETF	509.83	510.0	509.67	509.94	308956.0
2024-03-15 18:30:00	SPY	ETF	509.94	509.9898	509.72	509.75	18404.0
2024-03-15 19:00:00	SPY	ETF	509.75	510.0	509.75	509.85	13494.0
2024-03-15 19:30:00	SPY	ETF	509.83	509.87	509.74	509.79	5720.0
2024-03-15 04:00:00	QQQ	ETF	437.7	438.55	437.7	438.36	29826.0
2024-03-15 04:30:00	QQQ	ETF	438.45	438.93	438.24	438.84	17468.0
2024-03-15 05:00:00	QQQ	ETF	438.88	439.19	438.69	438.69	13788.0
2024-03-15 05:30:00	QQQ	ETF	439.03	439.81	439.03	439.53	42950.0
2024-03-15 06:00:00	QQQ	ETF	439.56	440.07	439.56	439.89	16536.0
2024-03-15 06:30:00	QQQ	ETF	439.84	440.35	439.84	440.02	39786.0
2024-03-15 07:00:00	QQQ	ETF	439.98	439.98	439.62	439.82	37816.0
2024-03-15 07:30:00	QQQ	ETF	439.8	440.02	439.201	439.35	47593.0
2024-03-15 08:00:00	QQQ	ETF	439.96	440.1504	437.58	438.8	245364.0
2024-03-15 08:30:00	QQQ	ETF	438.87	439.24	438.2	438.65	265800.0
2024-03-15 09:00:00	QQQ	ETF	438.62	438.7	435.6	436.16	1817289.0
2024-03-15 09:30:00	QQQ	ETF	436.07	436.78	434.22	434.87	7133150.0
2024-03-15 10:00:00	QQQ	ETF	434.83	435.62	433.3	435.12	3936164.0
2024-03-15 10:30:00	QQQ	ETF	435.14	436.69	434.85	435.55	2971830.0
2024-03-15 11:00:00	QQQ	ETF	435.58	435.68	434.51	435.04	1821712.0
2024-03-15 11:30:00	QQQ	ETF	435.04	435.22	433.76	434.105	1702577.0
2024-03-15 12:00:00	QQQ	ETF	434.1	434.39	433.12	433.56	1942624.0
2024-03-15 12:30:00	QQQ	ETF	433.55	434.21	432.7417	432.85	2238269.0

> showing 50 of 31,288 rows — these rows as CSV

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