PREVIEW / etf_30min / 2022-12-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-28.parquet
  size:    716 KB
  rows:    28,549

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-12-28 04:00:00	SPY	ETF	382.0	382.0	381.15	381.15	26769.0
2022-12-28 04:30:00	SPY	ETF	381.22	381.71	381.22	381.67	12290.0
2022-12-28 05:00:00	SPY	ETF	381.7	381.95	381.6	381.67	5456.0
2022-12-28 05:30:00	SPY	ETF	381.66	382.34	381.52	382.18	18812.0
2022-12-28 06:00:00	SPY	ETF	382.21	382.3	381.94	382.08	18393.0
2022-12-28 06:30:00	SPY	ETF	382.03	382.52	381.99	382.45	9234.0
2022-12-28 07:00:00	SPY	ETF	382.46	382.46	382.25	382.45	109995.0
2022-12-28 07:30:00	SPY	ETF	382.5	382.68	382.3	382.55	120957.0
2022-12-28 08:00:00	SPY	ETF	382.38	382.7	381.3304	382.12	124523.0
2022-12-28 08:30:00	SPY	ETF	382.12	382.12	381.48	381.71	85362.0
2022-12-28 09:00:00	SPY	ETF	381.71	381.9	381.26	381.34	89289.0
2022-12-28 09:30:00	SPY	ETF	381.34	383.39	380.62	382.12	3997538.0
2022-12-28 10:00:00	SPY	ETF	382.09	382.95	380.25	380.67	3230131.0
2022-12-28 10:30:00	SPY	ETF	380.65	381.05	379.34	379.45	3196587.0
2022-12-28 11:00:00	SPY	ETF	379.39	379.67	378.49	379.15	3433459.0
2022-12-28 11:30:00	SPY	ETF	379.15	379.26	378.1	378.22	2623999.0
2022-12-28 12:00:00	SPY	ETF	378.225	378.42	377.3	377.85	3518058.0
2022-12-28 12:30:00	SPY	ETF	377.86	379.53	377.8	379.33	2868404.0
2022-12-28 13:00:00	SPY	ETF	379.31	380.2397	379.1	379.32	2821902.0
2022-12-28 13:30:00	SPY	ETF	379.32	379.349	378.485	378.67	1782141.0
2022-12-28 14:00:00	SPY	ETF	378.7	379.02	378.13	378.38	1848773.0
2022-12-28 14:30:00	SPY	ETF	378.38	379.39	378.155	378.44	4376424.0
2022-12-28 15:00:00	SPY	ETF	378.44	378.47	376.84	377.091	3709195.0
2022-12-28 15:30:00	SPY	ETF	377.09	377.52	376.42	376.68	8135356.0
2022-12-28 16:00:00	SPY	ETF	376.67	377.25	376.5	376.8	2778178.0
2022-12-28 16:30:00	SPY	ETF	376.78	381.3534	376.66	377.04	256667.0
2022-12-28 17:00:00	SPY	ETF	377.0	377.05	376.66	376.66	623799.0
2022-12-28 17:30:00	SPY	ETF	376.66	377.1496	376.66	377.0	34487.0
2022-12-28 18:00:00	SPY	ETF	377.1	377.4	376.95	377.08	31485.0
2022-12-28 18:30:00	SPY	ETF	377.08	377.35	377.07	377.28	10335.0
2022-12-28 19:00:00	SPY	ETF	377.28	377.3499	376.68	376.68	29016.0
2022-12-28 19:30:00	SPY	ETF	376.73	377.07	376.67	377.07	26537.0
2022-12-28 04:00:00	QQQ	ETF	263.82	263.94	262.98	263.11	65294.0
2022-12-28 04:30:00	QQQ	ETF	263.06	263.45	263.06	263.4	8320.0
2022-12-28 05:00:00	QQQ	ETF	263.38	263.54	263.3	263.4	10270.0
2022-12-28 05:30:00	QQQ	ETF	263.4	264.18	263.23	263.92	64059.0
2022-12-28 06:00:00	QQQ	ETF	263.88	264.0	263.7	263.77	22918.0
2022-12-28 06:30:00	QQQ	ETF	263.7	264.27	263.7	264.19	62853.0
2022-12-28 07:00:00	QQQ	ETF	264.07	264.14	263.86	264.14	106350.0
2022-12-28 07:30:00	QQQ	ETF	264.15	264.41	264.05	264.22	65436.0
2022-12-28 08:00:00	QQQ	ETF	264.0198	264.41	263.2796	263.96	165214.0
2022-12-28 08:30:00	QQQ	ETF	263.91	263.92	263.33	263.54	207960.0
2022-12-28 09:00:00	QQQ	ETF	263.5409	263.77	263.04	263.13	163834.0
2022-12-28 09:30:00	QQQ	ETF	263.13	265.47	262.22	264.33	4972117.0
2022-12-28 10:00:00	QQQ	ETF	264.35	265.16	262.95	263.19	2996626.0
2022-12-28 10:30:00	QQQ	ETF	263.155	263.65	261.36	261.42	3092937.0
2022-12-28 11:00:00	QQQ	ETF	261.39	261.65	260.82	261.4	2741609.0
2022-12-28 11:30:00	QQQ	ETF	261.42	261.524	260.51	260.58	1850638.0
2022-12-28 12:00:00	QQQ	ETF	260.54	260.8756	260.09	260.69	2031469.0
2022-12-28 12:30:00	QQQ	ETF	260.7	262.25	260.66	262.08	1461173.0

> showing 50 of 28,549 rows — these rows as CSV

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