PREVIEW / etf_30min / 2023-02-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-10.parquet
  size:    691 KB
  rows:    27,259

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-02-10 04:00:00	SPY	ETF	407.37	407.6	406.72	407.0	13867.0
2023-02-10 04:30:00	SPY	ETF	407.0	407.17	405.85	405.91	34082.0
2023-02-10 05:00:00	SPY	ETF	405.9	406.06	405.12	405.28	22435.0
2023-02-10 05:30:00	SPY	ETF	405.33	405.7	405.26	405.59	28910.0
2023-02-10 06:00:00	SPY	ETF	405.6	405.6	404.5	404.54	116402.0
2023-02-10 06:30:00	SPY	ETF	404.61	404.74	404.39	404.49	34063.0
2023-02-10 07:00:00	SPY	ETF	404.57	405.06	404.3	404.96	158586.0
2023-02-10 07:30:00	SPY	ETF	404.94	404.97	404.15	404.3	90653.0
2023-02-10 08:00:00	SPY	ETF	404.69	407.18	404.15	405.29	288969.0
2023-02-10 08:30:00	SPY	ETF	405.3	405.67	405.13	405.27	416471.0
2023-02-10 09:00:00	SPY	ETF	405.27	405.88	405.1	405.84	288866.0
2023-02-10 09:30:00	SPY	ETF	405.88	406.99	405.47	406.42	6603333.0
2023-02-10 10:00:00	SPY	ETF	406.48	408.11	405.01	407.58	7002321.0
2023-02-10 10:30:00	SPY	ETF	407.5899	407.95	405.86	406.62	3803084.0
2023-02-10 11:00:00	SPY	ETF	406.63	407.49	406.5	406.8599	3221791.0
2023-02-10 11:30:00	SPY	ETF	406.86	407.07	406.1001	406.2401	2411803.0
2023-02-10 12:00:00	SPY	ETF	406.22	406.3999	405.26	405.8701	2884803.0
2023-02-10 12:30:00	SPY	ETF	405.865	406.91	405.7401	406.9	2589403.0
2023-02-10 13:00:00	SPY	ETF	406.895	408.14	406.69	407.55	3265422.0
2023-02-10 13:30:00	SPY	ETF	407.55	407.68	406.7101	406.73	2390464.0
2023-02-10 14:00:00	SPY	ETF	406.74	407.06	406.36	406.44	2735401.0
2023-02-10 14:30:00	SPY	ETF	406.44	407.47	406.2	407.41	2840194.0
2023-02-10 15:00:00	SPY	ETF	407.41	407.81	406.73	407.14	3559004.0
2023-02-10 15:30:00	SPY	ETF	407.144	408.44	407.13	408.03	7486009.0
2023-02-10 16:00:00	SPY	ETF	408.01	408.07	407.55	407.94	3477980.0
2023-02-10 16:30:00	SPY	ETF	407.95	408.0	407.9	407.96	129564.0
2023-02-10 17:00:00	SPY	ETF	407.94	408.15	407.92	408.15	66787.0
2023-02-10 17:30:00	SPY	ETF	408.05	408.08	407.66	407.8	37662.0
2023-02-10 18:00:00	SPY	ETF	407.8	407.99	407.7	407.98	22528.0
2023-02-10 18:30:00	SPY	ETF	407.98	407.98	407.94	407.94	1879.0
2023-02-10 19:00:00	SPY	ETF	407.98	407.98	407.94	407.94	4878.0
2023-02-10 19:30:00	SPY	ETF	408.06	408.25	408.06	408.2	4539.0
2023-02-10 04:00:00	QQQ	ETF	301.49	301.73	300.72	300.91	52791.0
2023-02-10 04:30:00	QQQ	ETF	300.9	301.05	299.36	299.36	60818.0
2023-02-10 05:00:00	QQQ	ETF	299.5	299.7	298.63	298.75	70521.0
2023-02-10 05:30:00	QQQ	ETF	298.8	299.34	298.76	299.21	45075.0
2023-02-10 06:00:00	QQQ	ETF	299.2	299.2	298.04	298.05	92160.0
2023-02-10 06:30:00	QQQ	ETF	298.13	298.36	297.96	298.34	73106.0
2023-02-10 07:00:00	QQQ	ETF	298.37	298.82	297.96	298.74	249517.0
2023-02-10 07:30:00	QQQ	ETF	298.71	298.77	298.18	298.3	84426.0
2023-02-10 08:00:00	QQQ	ETF	298.53	302.2	297.93	299.37	501226.0
2023-02-10 08:30:00	QQQ	ETF	299.35	299.83	299.2	299.41	233794.0
2023-02-10 09:00:00	QQQ	ETF	299.41	299.64	299.04	299.48	271559.0
2023-02-10 09:30:00	QQQ	ETF	299.48	300.92	298.93	299.71	5603527.0
2023-02-10 10:00:00	QQQ	ETF	299.78	301.57	298.23	300.65	5169124.0
2023-02-10 10:30:00	QQQ	ETF	300.64	301.25	298.82	299.435	2884455.0
2023-02-10 11:00:00	QQQ	ETF	299.41	300.0801	299.03	299.34	2024011.0
2023-02-10 11:30:00	QQQ	ETF	299.34	299.43	298.09	298.18	2005672.0
2023-02-10 12:00:00	QQQ	ETF	298.2	298.375	297.25	297.81	2277712.0
2023-02-10 12:30:00	QQQ	ETF	297.79	298.78	297.69	298.7	1628099.0

> showing 50 of 27,259 rows — these rows as CSV

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