PREVIEW / etf_30min / 2021-10-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-29.parquet
  size:    633 KB
  rows:    24,127

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-10-29 04:00:00	SPY	ETF	456.6	456.6	455.91	455.91	29760.0
2021-10-29 04:30:00	SPY	ETF	455.89	456.22	455.81	456.22	10926.0
2021-10-29 05:00:00	SPY	ETF	456.11	456.4	455.8	456.02	6120.0
2021-10-29 05:30:00	SPY	ETF	456.08	456.2	455.92	456.18	3528.0
2021-10-29 06:00:00	SPY	ETF	456.29	456.32	455.5	455.6	65853.0
2021-10-29 06:30:00	SPY	ETF	455.62	456.09	455.61	456.09	37750.0
2021-10-29 07:00:00	SPY	ETF	455.99	456.18	455.95	456.1	93052.0
2021-10-29 07:30:00	SPY	ETF	456.1	456.5	455.95	456.15	120000.0
2021-10-29 08:00:00	SPY	ETF	456.12	456.48	455.8904	456.33	114664.0
2021-10-29 08:30:00	SPY	ETF	456.31	456.69	455.53	455.81	264557.0
2021-10-29 09:00:00	SPY	ETF	455.79	456.15	455.45	455.83	250514.0
2021-10-29 09:30:00	SPY	ETF	455.87	457.64	455.56	457.12	5143102.0
2021-10-29 10:00:00	SPY	ETF	457.13	457.595	456.57	456.74	2808321.0
2021-10-29 10:30:00	SPY	ETF	456.77	457.57	456.48	457.32	2439393.0
2021-10-29 11:00:00	SPY	ETF	457.32	458.21	457.29	458.06	2274488.0
2021-10-29 11:30:00	SPY	ETF	458.05	458.48	457.79	458.06	2253976.0
2021-10-29 12:00:00	SPY	ETF	458.07	459.165	457.94	459.14	2032049.0
2021-10-29 12:30:00	SPY	ETF	459.14	459.15	458.65	458.73	1616747.0
2021-10-29 13:00:00	SPY	ETF	458.74	459.13	458.675	458.85	1108353.0
2021-10-29 13:30:00	SPY	ETF	458.86	458.94	458.42	458.7	1258225.0
2021-10-29 14:00:00	SPY	ETF	458.7	458.78	457.82	457.83	2222043.0
2021-10-29 14:30:00	SPY	ETF	457.84	458.36	457.73	458.19	2621777.0
2021-10-29 15:00:00	SPY	ETF	458.205	458.35	457.58	457.905	3507381.0
2021-10-29 15:30:00	SPY	ETF	457.9	459.56	457.79	459.23	12762784.0
2021-10-29 16:00:00	SPY	ETF	459.22	459.68	459.07	459.65	5182828.0
2021-10-29 16:30:00	SPY	ETF	459.64	459.77	459.25	459.66	197112.0
2021-10-29 17:00:00	SPY	ETF	459.62	459.73	459.55	459.56	31930.0
2021-10-29 17:30:00	SPY	ETF	459.55	459.64	459.49	459.61	38076.0
2021-10-29 18:00:00	SPY	ETF	459.59	459.7	459.59	459.7	12491.0
2021-10-29 18:30:00	SPY	ETF	459.25	459.7	459.25	459.59	11535.0
2021-10-29 19:00:00	SPY	ETF	459.68	459.79	459.57	459.79	8353.0
2021-10-29 19:30:00	SPY	ETF	459.67	459.7	459.5801	459.7	19538.0
2021-10-29 04:00:00	QQQ	ETF	381.51	381.57	381.05	381.05	56510.0
2021-10-29 04:30:00	QQQ	ETF	381.07	381.32	381.0	381.23	28525.0
2021-10-29 05:00:00	QQQ	ETF	381.12	381.38	380.79	380.93	59997.0
2021-10-29 05:30:00	QQQ	ETF	381.02	381.17	380.9	381.03	56651.0
2021-10-29 06:00:00	QQQ	ETF	381.04	381.18	380.28	380.33	84735.0
2021-10-29 06:30:00	QQQ	ETF	380.37	381.01	380.37	381.01	65101.0
2021-10-29 07:00:00	QQQ	ETF	380.91	381.13	380.91	380.93	116728.0
2021-10-29 07:30:00	QQQ	ETF	380.94	381.41	380.74	381.14	236075.0
2021-10-29 08:00:00	QQQ	ETF	381.0101	381.66	380.3396	381.5	354243.0
2021-10-29 08:30:00	QQQ	ETF	381.46	381.62	380.56	380.97	692313.0
2021-10-29 09:00:00	QQQ	ETF	380.94	381.4	380.7	381.0	289329.0
2021-10-29 09:30:00	QQQ	ETF	381.06	382.74	380.7	382.3298	4790020.0
2021-10-29 10:00:00	QQQ	ETF	382.3383	382.91	381.96	382.21	2405930.0
2021-10-29 10:30:00	QQQ	ETF	382.2396	382.92	381.99	382.56	1713266.0
2021-10-29 11:00:00	QQQ	ETF	382.56	383.68	382.51	383.5	1583704.0
2021-10-29 11:30:00	QQQ	ETF	383.505	383.8603	383.37	383.6432	1496462.0
2021-10-29 12:00:00	QQQ	ETF	383.66	385.03	383.555	384.99	2014690.0
2021-10-29 12:30:00	QQQ	ETF	384.99	385.01	384.6224	384.7601	1308986.0

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

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