PREVIEW / etf_30min / 2024-06-07

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-07.parquet
  size:    786 KB
  rows:    31,444

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-06-07 04:00:00	SPY	ETF	535.0	535.19	534.88	535.12	15480.0
2024-06-07 04:30:00	SPY	ETF	535.06	535.1	534.6	534.6	6500.0
2024-06-07 05:00:00	SPY	ETF	534.7	534.76	534.55	534.67	3171.0
2024-06-07 05:30:00	SPY	ETF	534.75	534.89	534.7	534.75	2163.0
2024-06-07 06:00:00	SPY	ETF	534.83	534.86	534.58	534.63	3624.0
2024-06-07 06:30:00	SPY	ETF	534.71	534.71	534.43	534.59	5800.0
2024-06-07 07:00:00	SPY	ETF	534.53	534.54	534.13	534.265	33212.0
2024-06-07 07:30:00	SPY	ETF	534.4	535.02	534.4	534.99	27453.0
2024-06-07 08:00:00	SPY	ETF	534.49	535.57	534.31	535.14	154774.0
2024-06-07 08:30:00	SPY	ETF	535.19	536.27	531.3	532.5	1560894.0
2024-06-07 09:00:00	SPY	ETF	532.36	533.75	532.19	533.66	393441.0
2024-06-07 09:30:00	SPY	ETF	533.66	534.31	532.535	534.0399	2941915.0
2024-06-07 10:00:00	SPY	ETF	534.05	534.76	533.87	534.64	2192991.0
2024-06-07 10:30:00	SPY	ETF	534.63	536.3999	534.38	535.3	2424306.0
2024-06-07 11:00:00	SPY	ETF	535.31	535.34	533.95	534.95	1874843.0
2024-06-07 11:30:00	SPY	ETF	534.955	535.43	534.68	535.1989	867965.0
2024-06-07 12:00:00	SPY	ETF	535.19	535.94	534.8192	535.9099	780337.0
2024-06-07 12:30:00	SPY	ETF	535.91	536.42	534.92	536.3468	1181001.0
2024-06-07 13:00:00	SPY	ETF	536.3486	536.89	535.755	536.1701	1044861.0
2024-06-07 13:30:00	SPY	ETF	536.18	536.41	535.815	535.8899	936155.0
2024-06-07 14:00:00	SPY	ETF	535.88	535.9	533.49	534.69	2783190.0
2024-06-07 14:30:00	SPY	ETF	534.7	535.44	534.51	535.08	1174390.0
2024-06-07 15:00:00	SPY	ETF	535.09	535.41	533.795	534.73	1704774.0
2024-06-07 15:30:00	SPY	ETF	534.74	534.88	533.72	533.96	5011318.0
2024-06-07 16:00:00	SPY	ETF	533.94	534.01	533.51	533.58	2688458.0
2024-06-07 16:30:00	SPY	ETF	533.54	533.87	533.51	533.75	291867.0
2024-06-07 17:00:00	SPY	ETF	533.68	533.93	533.4994	533.55	92440.0
2024-06-07 17:30:00	SPY	ETF	533.53	533.53	532.96	533.25	56338.0
2024-06-07 18:00:00	SPY	ETF	533.24	533.31	533.2	533.22	12937.0
2024-06-07 18:30:00	SPY	ETF	533.3	533.33	533.25	533.3	4668.0
2024-06-07 19:00:00	SPY	ETF	533.23	533.43	533.22	533.42	4296.0
2024-06-07 19:30:00	SPY	ETF	533.42	533.42	533.25	533.35	3805.0
2024-06-07 04:00:00	QQQ	ETF	463.96	464.37	463.9	464.16	20194.0
2024-06-07 04:30:00	QQQ	ETF	464.23	464.34	463.81	463.86	18124.0
2024-06-07 05:00:00	QQQ	ETF	463.93	464.02	463.74	463.91	8683.0
2024-06-07 05:30:00	QQQ	ETF	464.02	464.06	463.9	463.9	2450.0
2024-06-07 06:00:00	QQQ	ETF	463.93	463.93	463.74	463.8	6155.0
2024-06-07 06:30:00	QQQ	ETF	463.85	463.9	463.62	463.76	7921.0
2024-06-07 07:00:00	QQQ	ETF	463.65	463.73	463.3	463.53	41605.0
2024-06-07 07:30:00	QQQ	ETF	463.56	464.31	463.56	464.17	18328.0
2024-06-07 08:00:00	QQQ	ETF	463.5017	464.42	463.023	464.22	170955.0
2024-06-07 08:30:00	QQQ	ETF	464.5	465.55	460.54	461.6	1225313.0
2024-06-07 09:00:00	QQQ	ETF	461.6	463.07	461.38	463.02	399211.0
2024-06-07 09:30:00	QQQ	ETF	463.0	463.58	461.84	462.81	2026129.0
2024-06-07 10:00:00	QQQ	ETF	462.8	463.31	462.5	462.94	883173.0
2024-06-07 10:30:00	QQQ	ETF	462.91	464.85	462.81	463.83	1176359.0
2024-06-07 11:00:00	QQQ	ETF	463.86	463.875	462.4	463.625	1123841.0
2024-06-07 11:30:00	QQQ	ETF	463.63	465.6927	463.37	464.021	716732.0
2024-06-07 12:00:00	QQQ	ETF	464.04	464.79	463.74	464.74	613816.0
2024-06-07 12:30:00	QQQ	ETF	464.75	465.51	463.9	465.43	1147225.0

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

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