PREVIEW / etf_30min / 2024-02-27

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-27.parquet
  size:    800 KB
  rows:    31,435

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-02-27 04:00:00	SPY	ETF	506.0	506.69	506.0	506.69	11932.0
2024-02-27 04:30:00	SPY	ETF	506.67	506.68	506.52	506.58	4257.0
2024-02-27 05:00:00	SPY	ETF	506.62	506.73	506.47	506.61	9169.0
2024-02-27 05:30:00	SPY	ETF	506.55	506.64	506.38	506.64	5244.0
2024-02-27 06:00:00	SPY	ETF	506.69	506.69	506.41	506.41	5679.0
2024-02-27 06:30:00	SPY	ETF	506.32	506.51	506.31	506.49	13491.0
2024-02-27 07:00:00	SPY	ETF	506.44	506.78	506.44	506.78	49789.0
2024-02-27 07:30:00	SPY	ETF	506.8	507.01	506.78	506.88	54616.0
2024-02-27 08:00:00	SPY	ETF	506.48	507.0101	505.55	506.21	193601.0
2024-02-27 08:30:00	SPY	ETF	506.21	506.87	506.07	506.77	97734.0
2024-02-27 09:00:00	SPY	ETF	506.75	506.92	506.45	506.69	120446.0
2024-02-27 09:30:00	SPY	ETF	506.69	506.74	505.53	506.12	3364109.0
2024-02-27 10:00:00	SPY	ETF	506.1	506.58	505.63	506.24	2544024.0
2024-02-27 10:30:00	SPY	ETF	506.245	506.3399	505.59	506.1303	2251766.0
2024-02-27 11:00:00	SPY	ETF	506.14	506.165	505.615	505.68	1595564.0
2024-02-27 11:30:00	SPY	ETF	505.685	505.98	505.46	505.9	1432779.0
2024-02-27 12:00:00	SPY	ETF	505.92	506.0	505.3312	505.5279	1770836.0
2024-02-27 12:30:00	SPY	ETF	505.53	505.77	504.99	505.0597	1804984.0
2024-02-27 13:00:00	SPY	ETF	505.05	505.705	504.75	505.22	2353266.0
2024-02-27 13:30:00	SPY	ETF	505.23	505.89	505.11	505.7726	1742325.0
2024-02-27 14:00:00	SPY	ETF	505.79	506.469	505.74	506.31	2241541.0
2024-02-27 14:30:00	SPY	ETF	506.31	506.71	506.09	506.66	2363628.0
2024-02-27 15:00:00	SPY	ETF	506.66	506.87	506.2201	506.76	2093301.0
2024-02-27 15:30:00	SPY	ETF	506.755	507.16	506.42	506.87	7113445.0
2024-02-27 16:00:00	SPY	ETF	506.87	507.31	506.81	507.26	2952745.0
2024-02-27 16:30:00	SPY	ETF	507.26	507.26	507.05	507.08	133928.0
2024-02-27 17:00:00	SPY	ETF	507.06	507.1	506.95	507.04	43278.0
2024-02-27 17:30:00	SPY	ETF	507.05	507.1	506.94	507.1	25564.0
2024-02-27 18:00:00	SPY	ETF	507.0	507.11	506.91	507.0	51947.0
2024-02-27 18:30:00	SPY	ETF	506.93	506.93	506.76	506.78	28638.0
2024-02-27 19:00:00	SPY	ETF	506.77	506.87	506.75	506.87	4043.0
2024-02-27 19:30:00	SPY	ETF	506.88	506.88	506.7	506.7	33026.0
2024-02-27 04:00:00	QQQ	ETF	436.49	437.49	436.49	437.48	69419.0
2024-02-27 04:30:00	QQQ	ETF	437.5	437.56	437.38	437.53	12919.0
2024-02-27 05:00:00	QQQ	ETF	437.64	437.8	437.44	437.51	23563.0
2024-02-27 05:30:00	QQQ	ETF	437.47	437.72	437.26	437.57	12542.0
2024-02-27 06:00:00	QQQ	ETF	437.6	437.63	437.28	437.32	15981.0
2024-02-27 06:30:00	QQQ	ETF	437.27	437.4	437.23	437.4	11939.0
2024-02-27 07:00:00	QQQ	ETF	437.33	438.01	437.33	437.99	43671.0
2024-02-27 07:30:00	QQQ	ETF	438.02	438.19	437.88	437.95	35181.0
2024-02-27 08:00:00	QQQ	ETF	437.37	438.16	435.58	437.17	176482.0
2024-02-27 08:30:00	QQQ	ETF	437.19	438.02	437.01	437.8907	131487.0
2024-02-27 09:00:00	QQQ	ETF	437.84	437.89	437.47	437.71	142344.0
2024-02-27 09:30:00	QQQ	ETF	437.67	437.89	435.81	436.97	3761390.0
2024-02-27 10:00:00	QQQ	ETF	436.97	437.99	436.69	437.47	2647893.0
2024-02-27 10:30:00	QQQ	ETF	437.48	437.87	436.74	437.5399	1919780.0
2024-02-27 11:00:00	QQQ	ETF	437.54	437.6	436.58	436.65	1409113.0
2024-02-27 11:30:00	QQQ	ETF	436.63	437.365	436.39	437.24	1604726.0
2024-02-27 12:00:00	QQQ	ETF	437.25	437.47	436.36	436.62	1529409.0
2024-02-27 12:30:00	QQQ	ETF	436.63	436.84	435.34	435.4961	1468588.0

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

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