PREVIEW / etf_30min / 2022-09-09

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-09.parquet
  size:    643 KB
  rows:    25,620

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
2022-09-09 04:00:00	SPY	ETF	402.02	403.69	402.02	403.62	24166.0
2022-09-09 04:30:00	SPY	ETF	403.7	403.79	403.12	403.69	23444.0
2022-09-09 05:00:00	SPY	ETF	403.71	403.79	403.44	403.58	16200.0
2022-09-09 05:30:00	SPY	ETF	403.66	403.79	403.11	403.37	12439.0
2022-09-09 06:00:00	SPY	ETF	403.53	403.64	403.11	403.61	39689.0
2022-09-09 06:30:00	SPY	ETF	403.64	404.28	403.63	403.94	77369.0
2022-09-09 07:00:00	SPY	ETF	403.91	403.96	403.44	403.58	94876.0
2022-09-09 07:30:00	SPY	ETF	403.54	403.54	403.17	403.38	49319.0
2022-09-09 08:00:00	SPY	ETF	403.67	403.8499	401.1	403.49	273087.0
2022-09-09 08:30:00	SPY	ETF	403.47	404.27	403.33	403.42	318260.0
2022-09-09 09:00:00	SPY	ETF	403.44	403.6	402.5	402.73	265428.0
2022-09-09 09:30:00	SPY	ETF	402.73	404.3	402.46	404.27	6531308.0
2022-09-09 10:00:00	SPY	ETF	404.28	405.57	404.11	405.13	6478810.0
2022-09-09 10:30:00	SPY	ETF	405.14	406.19	404.91	405.95	4792277.0
2022-09-09 11:00:00	SPY	ETF	405.97	406.1701	404.81	405.515	3608491.0
2022-09-09 11:30:00	SPY	ETF	405.55	406.07	405.065	405.64	2556497.0
2022-09-09 12:00:00	SPY	ETF	405.65	405.79	404.34	404.79	3093020.0
2022-09-09 12:30:00	SPY	ETF	404.79	406.0	404.555	405.97	2372846.0
2022-09-09 13:00:00	SPY	ETF	405.98	406.6	405.47	406.2775	2360817.0
2022-09-09 13:30:00	SPY	ETF	406.29	406.82	406.09	406.54	2308246.0
2022-09-09 14:00:00	SPY	ETF	406.54	406.94	405.97	406.9	2584161.0
2022-09-09 14:30:00	SPY	ETF	406.9	406.93	406.1607	406.73	2447624.0
2022-09-09 15:00:00	SPY	ETF	406.74	407.3199	406.575	407.1	3675321.0
2022-09-09 15:30:00	SPY	ETF	407.11	407.51	406.48	406.55	8992746.0
2022-09-09 16:00:00	SPY	ETF	406.56	406.6901	405.7884	406.36	4700189.0
2022-09-09 16:30:00	SPY	ETF	406.38	406.47	406.27	406.44	174821.0
2022-09-09 17:00:00	SPY	ETF	406.51	406.51	406.2	406.3	64018.0
2022-09-09 17:30:00	SPY	ETF	406.31	406.51	406.27	406.47	30444.0
2022-09-09 18:00:00	SPY	ETF	406.45	406.58	406.34	406.44	17955.0
2022-09-09 18:30:00	SPY	ETF	406.48	406.5	406.29	406.38	38639.0
2022-09-09 19:00:00	SPY	ETF	406.36	406.38	406.3	406.37	2847.0
2022-09-09 19:30:00	SPY	ETF	406.37	406.44	406.2	406.2	15716.0
2022-09-09 04:00:00	QQQ	ETF	302.22	303.6	301.82	303.6	53657.0
2022-09-09 04:30:00	QQQ	ETF	303.62	303.65	303.05	303.6	29642.0
2022-09-09 05:00:00	QQQ	ETF	303.54	303.71	303.41	303.51	15542.0
2022-09-09 05:30:00	QQQ	ETF	303.63	303.84	303.4	303.63	27596.0
2022-09-09 06:00:00	QQQ	ETF	303.67	303.67	303.26	303.67	25004.0
2022-09-09 06:30:00	QQQ	ETF	303.64	304.34	303.64	303.96	48272.0
2022-09-09 07:00:00	QQQ	ETF	303.96	303.96	303.54	303.6	76685.0
2022-09-09 07:30:00	QQQ	ETF	303.6	303.62	303.24	303.51	74521.0
2022-09-09 08:00:00	QQQ	ETF	303.74	304.1696	300.745	303.45	223337.0
2022-09-09 08:30:00	QQQ	ETF	303.46	304.15	303.38	303.5	425358.0
2022-09-09 09:00:00	QQQ	ETF	303.5	303.64	302.58	302.81	437947.0
2022-09-09 09:30:00	QQQ	ETF	302.83	304.9	302.79	304.86	6215205.0
2022-09-09 10:00:00	QQQ	ETF	304.91	305.9	304.5	305.44	4258772.0
2022-09-09 10:30:00	QQQ	ETF	305.44	306.48	305.1167	306.23	3050281.0
2022-09-09 11:00:00	QQQ	ETF	306.245	306.47	305.32	306.23	2870354.0
2022-09-09 11:30:00	QQQ	ETF	306.24	306.72	305.81	306.21	2487177.0
2022-09-09 12:00:00	QQQ	ETF	306.2	306.33	305.05	305.51	2078620.0
2022-09-09 12:30:00	QQQ	ETF	305.51	306.62	305.32	306.59	1714143.0

> showing 50 of 25,620 rows — these rows as CSV

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