PREVIEW / etf_30min / 2021-12-31

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-31.parquet
  size:    631 KB
  rows:    24,473

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
2021-12-31 04:00:00	SPY	ETF	475.83	476.08	475.59	475.65	3505.0
2021-12-31 04:30:00	SPY	ETF	475.67	475.83	475.67	475.79	900.0
2021-12-31 05:00:00	SPY	ETF	475.88	475.88	475.7	475.74	1921.0
2021-12-31 05:30:00	SPY	ETF	475.79	475.82	475.43	475.51	6115.0
2021-12-31 06:00:00	SPY	ETF	475.48	475.56	475.09	475.42	30307.0
2021-12-31 06:30:00	SPY	ETF	475.43	475.43	474.96	475.07	69785.0
2021-12-31 07:00:00	SPY	ETF	475.06	475.43	474.69	475.43	91632.0
2021-12-31 07:30:00	SPY	ETF	475.42	475.77	475.38	475.66	30555.0
2021-12-31 08:00:00	SPY	ETF	475.6796	476.0	474.79	475.66	51296.0
2021-12-31 08:30:00	SPY	ETF	475.65	475.92	475.54	475.68	74354.0
2021-12-31 09:00:00	SPY	ETF	475.67	475.9	475.57	475.6	100303.0
2021-12-31 09:30:00	SPY	ETF	475.64	476.86	475.44	475.71	3946591.0
2021-12-31 10:00:00	SPY	ETF	475.7	476.26	474.87	475.995	2927527.0
2021-12-31 10:30:00	SPY	ETF	476.0	476.0512	475.095	475.8	2378122.0
2021-12-31 11:00:00	SPY	ETF	475.8	475.95	475.34	475.91	1594351.0
2021-12-31 11:30:00	SPY	ETF	475.89	475.9301	475.26	475.32	1225883.0
2021-12-31 12:00:00	SPY	ETF	475.34	475.64	474.94	475.17	1817561.0
2021-12-31 12:30:00	SPY	ETF	475.18	476.1701	475.08	476.1371	1372792.0
2021-12-31 13:00:00	SPY	ETF	476.13	476.36	476.04	476.285	1183673.0
2021-12-31 13:30:00	SPY	ETF	476.27	476.49	475.87	476.32	1481105.0
2021-12-31 14:00:00	SPY	ETF	476.32	476.66	475.85	476.09	2497855.0
2021-12-31 14:30:00	SPY	ETF	476.075	476.33	475.75	475.96	2090070.0
2021-12-31 15:00:00	SPY	ETF	475.945	476.5499	475.87	476.44	3004264.0
2021-12-31 15:30:00	SPY	ETF	476.45	476.7	474.67	474.88	12388303.0
2021-12-31 16:00:00	SPY	ETF	474.88	475.55	474.7634	475.21	4184109.0
2021-12-31 16:30:00	SPY	ETF	475.19	475.22	474.99	475.03	104014.0
2021-12-31 17:00:00	SPY	ETF	474.95	475.33	474.95	475.33	40563.0
2021-12-31 17:30:00	SPY	ETF	475.25	475.33	475.07	475.15	7287.0
2021-12-31 18:00:00	SPY	ETF	475.15	475.23	475.1	475.15	4217.0
2021-12-31 18:30:00	SPY	ETF	474.96	475.21	474.96	475.13	3119.0
2021-12-31 19:00:00	SPY	ETF	475.07	475.08	475.05	475.08	1800.0
2021-12-31 19:30:00	SPY	ETF	475.15	475.32	475.04	475.32	16622.0
2021-12-31 04:00:00	QQQ	ETF	400.0	400.14	399.42	399.49	17148.0
2021-12-31 04:30:00	QQQ	ETF	399.7	399.86	399.7	399.86	3368.0
2021-12-31 05:00:00	QQQ	ETF	399.82	399.82	399.65	399.77	2763.0
2021-12-31 05:30:00	QQQ	ETF	399.79	399.81	399.5	399.6	6328.0
2021-12-31 06:00:00	QQQ	ETF	399.5	399.5	399.15	399.33	4287.0
2021-12-31 06:30:00	QQQ	ETF	399.31	399.46	398.98	399.11	14409.0
2021-12-31 07:00:00	QQQ	ETF	399.13	399.54	398.77	399.52	42504.0
2021-12-31 07:30:00	QQQ	ETF	399.561	399.93	399.48	399.88	21700.0
2021-12-31 08:00:00	QQQ	ETF	399.28	400.05	398.82	400.03	42309.0
2021-12-31 08:30:00	QQQ	ETF	400.03	400.4	399.99	400.1996	99085.0
2021-12-31 09:00:00	QQQ	ETF	400.14	400.35	399.63	399.63	153204.0
2021-12-31 09:30:00	QQQ	ETF	399.69	401.0589	399.1	399.34	3181439.0
2021-12-31 10:00:00	QQQ	ETF	399.38	399.99	398.37	399.53	1924274.0
2021-12-31 10:30:00	QQQ	ETF	399.53	399.68	398.47	399.19	1440360.0
2021-12-31 11:00:00	QQQ	ETF	399.16	399.595	398.42	399.45	1434784.0
2021-12-31 11:30:00	QQQ	ETF	399.45	399.53	398.69	398.82	801782.0
2021-12-31 12:00:00	QQQ	ETF	398.84	399.15	398.2	398.55	1101738.0
2021-12-31 12:30:00	QQQ	ETF	398.55	399.2	398.415	399.17	1174440.0

> showing 50 of 24,473 rows — these rows as CSV

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