PREVIEW / etf_30min / 2022-08-11

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-11.parquet
  size:    671 KB
  rows:    26,312

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-08-11 04:00:00	SPY	ETF	421.0	421.0	420.5	420.5	17615.0
2022-08-11 04:30:00	SPY	ETF	420.53	420.76	420.3	420.75	10646.0
2022-08-11 05:00:00	SPY	ETF	420.88	421.01	420.65	421.01	19940.0
2022-08-11 05:30:00	SPY	ETF	421.02	421.52	421.02	421.27	23877.0
2022-08-11 06:00:00	SPY	ETF	421.3	421.3	420.82	421.09	20593.0
2022-08-11 06:30:00	SPY	ETF	421.07	421.32	420.98	421.17	16813.0
2022-08-11 07:00:00	SPY	ETF	421.16	421.38	421.05	421.33	67565.0
2022-08-11 07:30:00	SPY	ETF	421.33	421.9	421.32	421.7	62155.0
2022-08-11 08:00:00	SPY	ETF	421.73	422.5	420.7112	422.5	240537.0
2022-08-11 08:30:00	SPY	ETF	422.52	423.49	422.04	423.35	636759.0
2022-08-11 09:00:00	SPY	ETF	423.37	423.38	422.63	422.98	317436.0
2022-08-11 09:30:00	SPY	ETF	422.99	423.53	422.24	423.32	5030631.0
2022-08-11 10:00:00	SPY	ETF	423.32	424.95	423.31	423.93	4398764.0
2022-08-11 10:30:00	SPY	ETF	423.93	424.75	423.22	423.595	3522215.0
2022-08-11 11:00:00	SPY	ETF	423.59	423.67	421.32	422.19	4037706.0
2022-08-11 11:30:00	SPY	ETF	422.18	422.43	421.1	421.62	2172924.0
2022-08-11 12:00:00	SPY	ETF	421.63	422.04	421.14	422.04	1776286.0
2022-08-11 12:30:00	SPY	ETF	422.03	422.52	421.9	422.4	1649452.0
2022-08-11 13:00:00	SPY	ETF	422.4	423.0	421.98	422.47	1710632.0
2022-08-11 13:30:00	SPY	ETF	422.45	422.63	421.74	421.95	1493352.0
2022-08-11 14:00:00	SPY	ETF	421.95	421.95	420.79	421.23	2169297.0
2022-08-11 14:30:00	SPY	ETF	421.242	421.265	419.53	420.13	3395968.0
2022-08-11 15:00:00	SPY	ETF	420.14	420.24	419.21	419.9359	3286988.0
2022-08-11 15:30:00	SPY	ETF	419.925	420.36	419.275	420.01	6484174.0
2022-08-11 16:00:00	SPY	ETF	420.0	420.79	419.8394	420.79	2452927.0
2022-08-11 16:30:00	SPY	ETF	420.8	420.84	420.59	420.73	178607.0
2022-08-11 17:00:00	SPY	ETF	420.7	420.74	420.5	420.65	30485.0
2022-08-11 17:30:00	SPY	ETF	420.65	420.69	420.6	420.69	26076.0
2022-08-11 18:00:00	SPY	ETF	420.7	420.75	420.38	420.42	46952.0
2022-08-11 18:30:00	SPY	ETF	420.36	420.41	420.14	420.29	55883.0
2022-08-11 19:00:00	SPY	ETF	420.28	420.42	420.2	420.41	8618.0
2022-08-11 19:30:00	SPY	ETF	420.36	420.45	420.32	420.4	73968.0
2022-08-11 04:00:00	QQQ	ETF	326.51	327.15	326.46	326.46	53129.0
2022-08-11 04:30:00	QQQ	ETF	326.5	326.7	325.88	326.31	43459.0
2022-08-11 05:00:00	QQQ	ETF	326.44	326.66	326.17	326.66	12020.0
2022-08-11 05:30:00	QQQ	ETF	326.58	327.05	326.58	326.84	17124.0
2022-08-11 06:00:00	QQQ	ETF	326.82	326.82	326.24	326.46	30868.0
2022-08-11 06:30:00	QQQ	ETF	326.45	326.61	326.3	326.59	11477.0
2022-08-11 07:00:00	QQQ	ETF	326.45	326.76	326.3	326.74	80508.0
2022-08-11 07:30:00	QQQ	ETF	326.75	327.38	326.68	327.32	116676.0
2022-08-11 08:00:00	QQQ	ETF	326.4299	328.12	325.9396	327.96	255672.0
2022-08-11 08:30:00	QQQ	ETF	327.96	328.75	327.41	328.64	800752.0
2022-08-11 09:00:00	QQQ	ETF	328.64	328.65	328.04	328.3	273773.0
2022-08-11 09:30:00	QQQ	ETF	328.29	328.82	327.47	328.38	5257378.0
2022-08-11 10:00:00	QQQ	ETF	328.38	330.36	328.38	329.09	3976766.0
2022-08-11 10:30:00	QQQ	ETF	329.11	329.69	327.69	328.1601	3142851.0
2022-08-11 11:00:00	QQQ	ETF	328.19	328.34	325.51	326.49	4217876.0
2022-08-11 11:30:00	QQQ	ETF	326.51	326.97	325.16	325.87	1965445.0
2022-08-11 12:00:00	QQQ	ETF	325.8802	326.31	325.4447	326.27	1681891.0
2022-08-11 12:30:00	QQQ	ETF	326.29	326.85	326.18	326.64	1281476.0

> showing 50 of 26,312 rows — these rows as CSV

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