PREVIEW / etf_30min / 2022-01-05

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-05.parquet
  size:    694 KB
  rows:    27,361

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-01-05 04:00:00	SPY	ETF	477.06	477.74	476.87	477.55	13394.0
2022-01-05 04:30:00	SPY	ETF	477.55	477.6	477.38	477.52	7433.0
2022-01-05 05:00:00	SPY	ETF	477.6	477.94	477.52	477.75	18640.0
2022-01-05 05:30:00	SPY	ETF	477.89	477.92	477.32	477.51	15002.0
2022-01-05 06:00:00	SPY	ETF	477.3	477.37	477.0	477.06	19217.0
2022-01-05 06:30:00	SPY	ETF	477.08	477.33	477.01	477.3	20865.0
2022-01-05 07:00:00	SPY	ETF	477.29	477.49	477.13	477.4	25765.0
2022-01-05 07:30:00	SPY	ETF	477.4	477.46	476.85	477.05	27812.0
2022-01-05 08:00:00	SPY	ETF	477.09	477.908	476.0	477.22	80769.0
2022-01-05 08:30:00	SPY	ETF	477.29	477.53	476.99	477.39	260697.0
2022-01-05 09:00:00	SPY	ETF	477.41	477.51	477.01	477.2	144158.0
2022-01-05 09:30:00	SPY	ETF	477.16	477.66	476.13	477.21	5525008.0
2022-01-05 10:00:00	SPY	ETF	477.22	477.98	476.75	477.74	3051335.0
2022-01-05 10:30:00	SPY	ETF	477.72	477.73	476.92	477.3101	2157632.0
2022-01-05 11:00:00	SPY	ETF	477.305	477.395	476.475	477.2299	1949598.0
2022-01-05 11:30:00	SPY	ETF	477.23	477.285	476.3	476.56	2013855.0
2022-01-05 12:00:00	SPY	ETF	476.542	477.25	476.37	477.14	1914926.0
2022-01-05 12:30:00	SPY	ETF	477.13	477.18	475.87	475.95	3043877.0
2022-01-05 13:00:00	SPY	ETF	475.9427	476.05	475.305	475.86	2643992.0
2022-01-05 13:30:00	SPY	ETF	475.86	476.14	475.59	475.85	1882440.0
2022-01-05 14:00:00	SPY	ETF	475.84	476.91	473.22	473.4	8740312.0
2022-01-05 14:30:00	SPY	ETF	473.42	473.87	471.11	471.6901	7870517.0
2022-01-05 15:00:00	SPY	ETF	471.7	471.7	469.95	470.295	9055396.0
2022-01-05 15:30:00	SPY	ETF	470.3	471.19	468.2801	468.38	16318581.0
2022-01-05 16:00:00	SPY	ETF	468.38	469.08	468.12	468.68	4323886.0
2022-01-05 16:30:00	SPY	ETF	468.69	468.75	468.22	468.4	207842.0
2022-01-05 17:00:00	SPY	ETF	468.34	468.47	468.28	468.35	2836048.0
2022-01-05 17:30:00	SPY	ETF	468.35	468.48	468.31	468.35	60181.0
2022-01-05 18:00:00	SPY	ETF	468.35	468.7	467.41	468.69	163566.0
2022-01-05 18:30:00	SPY	ETF	468.38	469.08	468.38	469.01	111517.0
2022-01-05 19:00:00	SPY	ETF	468.98	469.4	468.95	469.29	46484.0
2022-01-05 19:30:00	SPY	ETF	469.26	469.43	468.4	468.95	134251.0
2022-01-05 04:00:00	QQQ	ETF	395.28	395.8	395.17	395.64	14555.0
2022-01-05 04:30:00	QQQ	ETF	395.5	395.53	395.36	395.43	6641.0
2022-01-05 05:00:00	QQQ	ETF	395.61	396.0	395.61	395.9	13836.0
2022-01-05 05:30:00	QQQ	ETF	396.05	396.15	395.34	395.57	9471.0
2022-01-05 06:00:00	QQQ	ETF	395.39	395.4	394.86	394.96	10434.0
2022-01-05 06:30:00	QQQ	ETF	395.0	395.28	394.74	395.16	18159.0
2022-01-05 07:00:00	QQQ	ETF	395.22	395.45	395.0	395.27	33053.0
2022-01-05 07:30:00	QQQ	ETF	395.39	395.39	394.64	394.97	51186.0
2022-01-05 08:00:00	QQQ	ETF	395.1601	396.767	394.25	394.93	172991.0
2022-01-05 08:30:00	QQQ	ETF	394.93	395.4299	394.74	395.3	194869.0
2022-01-05 09:00:00	QQQ	ETF	395.28	395.32	394.49	394.74	315996.0
2022-01-05 09:30:00	QQQ	ETF	394.74	395.37	392.36	395.07	6916980.0
2022-01-05 10:00:00	QQQ	ETF	395.07	395.89	393.69	394.6918	3658578.0
2022-01-05 10:30:00	QQQ	ETF	394.66	394.69	392.88	394.0951	2916541.0
2022-01-05 11:00:00	QQQ	ETF	394.09	394.44	393.13	394.04	1875540.0
2022-01-05 11:30:00	QQQ	ETF	394.05	394.21	392.76	393.17	1892667.0
2022-01-05 12:00:00	QQQ	ETF	393.13	393.56	392.6901	393.07	1642476.0
2022-01-05 12:30:00	QQQ	ETF	393.0499	393.08	391.03	391.16	3388382.0

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

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