PREVIEW / etf_30min / 2022-09-12

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-12.parquet
  size:    659 KB
  rows:    26,130

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-12 04:00:00	SPY	ETF	406.74	408.31	406.74	408.22	12358.0
2022-09-12 04:30:00	SPY	ETF	408.36	409.24	408.36	409.24	26462.0
2022-09-12 05:00:00	SPY	ETF	409.25	409.53	409.14	409.14	19721.0
2022-09-12 05:30:00	SPY	ETF	409.04	409.07	408.72	408.75	14957.0
2022-09-12 06:00:00	SPY	ETF	408.64	408.65	408.3	408.6	19401.0
2022-09-12 06:30:00	SPY	ETF	408.63	408.77	408.45	408.45	13525.0
2022-09-12 07:00:00	SPY	ETF	408.37	408.7	408.13	408.63	48481.0
2022-09-12 07:30:00	SPY	ETF	408.55	409.01	408.4	408.9	169613.0
2022-09-12 08:00:00	SPY	ETF	408.4097	409.3296	406.7	407.6	153989.0
2022-09-12 08:30:00	SPY	ETF	407.65	408.53	407.65	408.42	133971.0
2022-09-12 09:00:00	SPY	ETF	408.44	408.86	408.07	408.78	177655.0
2022-09-12 09:30:00	SPY	ETF	408.78	411.03	408.46	411.01	7038032.0
2022-09-12 10:00:00	SPY	ETF	411.02	411.73	410.62	411.37	4858097.0
2022-09-12 10:30:00	SPY	ETF	411.38	411.53	410.3	410.51	4181505.0
2022-09-12 11:00:00	SPY	ETF	410.52	411.09	409.84	411.08	3208607.0
2022-09-12 11:30:00	SPY	ETF	411.08	411.23	408.63	409.2083	3598820.0
2022-09-12 12:00:00	SPY	ETF	409.22	409.76	408.47	409.62	3358983.0
2022-09-12 12:30:00	SPY	ETF	409.63	410.28	409.27	410.25	2571109.0
2022-09-12 13:00:00	SPY	ETF	410.26	411.015	409.51	410.98	2401838.0
2022-09-12 13:30:00	SPY	ETF	410.98	411.08	410.265	410.92	2026585.0
2022-09-12 14:00:00	SPY	ETF	410.91	410.98	409.74	409.87	2383135.0
2022-09-12 14:30:00	SPY	ETF	409.86	410.57	409.46	410.29	2274259.0
2022-09-12 15:00:00	SPY	ETF	410.28	410.85	409.99	410.1	2522402.0
2022-09-12 15:30:00	SPY	ETF	410.1	411.05	409.79	410.95	7438495.0
2022-09-12 16:00:00	SPY	ETF	410.93	411.6	410.82	411.5	3476010.0
2022-09-12 16:30:00	SPY	ETF	411.51	411.67	411.48	411.62	131994.0
2022-09-12 17:00:00	SPY	ETF	411.63	411.66	410.97	411.55	105192.0
2022-09-12 17:30:00	SPY	ETF	411.55	411.67	411.54	411.65	77124.0
2022-09-12 18:00:00	SPY	ETF	411.67	411.94	411.36	411.42	66711.0
2022-09-12 18:30:00	SPY	ETF	411.41	411.41	411.24	411.37	36326.0
2022-09-12 19:00:00	SPY	ETF	411.38	411.6	411.29	411.55	18690.0
2022-09-12 19:30:00	SPY	ETF	411.55	411.57	411.31	411.38	37102.0
2022-09-12 04:00:00	QQQ	ETF	308.02	308.52	307.82	308.35	65192.0
2022-09-12 04:30:00	QQQ	ETF	308.53	309.41	308.53	309.3	68584.0
2022-09-12 05:00:00	QQQ	ETF	309.35	309.64	309.3	309.3	13548.0
2022-09-12 05:30:00	QQQ	ETF	309.27	309.27	308.85	308.95	21563.0
2022-09-12 06:00:00	QQQ	ETF	308.87	308.9	308.43	308.61	23434.0
2022-09-12 06:30:00	QQQ	ETF	308.64	308.83	308.6	308.63	20487.0
2022-09-12 07:00:00	QQQ	ETF	308.52	308.89	308.29	308.86	66729.0
2022-09-12 07:30:00	QQQ	ETF	308.79	309.24	308.6	309.09	85868.0
2022-09-12 08:00:00	QQQ	ETF	309.11	309.3001	307.25	307.58	337521.0
2022-09-12 08:30:00	QQQ	ETF	307.63	308.4	307.6	308.35	219286.0
2022-09-12 09:00:00	QQQ	ETF	308.33	308.54	308.02	308.5	202030.0
2022-09-12 09:30:00	QQQ	ETF	308.5	310.62	308.28	310.6	4434644.0
2022-09-12 10:00:00	QQQ	ETF	310.62	311.08	310.24	310.67	2788845.0
2022-09-12 10:30:00	QQQ	ETF	310.69	310.88	309.57	309.76	3490784.0
2022-09-12 11:00:00	QQQ	ETF	309.76	310.52	309.08	310.5093	2056697.0
2022-09-12 11:30:00	QQQ	ETF	310.52	310.65	308.31	308.7702	2944660.0
2022-09-12 12:00:00	QQQ	ETF	308.775	309.43	308.18	309.39	1908765.0
2022-09-12 12:30:00	QQQ	ETF	309.385	310.11	309.02	310.01	1300648.0

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

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