PREVIEW / etf_30min / 2021-12-06

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-06.parquet
  size:    660 KB
  rows:    25,576

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-06 04:00:00	SPY	ETF	455.5	456.81	455.5	456.62	31814.0
2021-12-06 04:30:00	SPY	ETF	456.65	456.65	454.3	454.4	67233.0
2021-12-06 05:00:00	SPY	ETF	454.51	454.76	453.32	453.48	51421.0
2021-12-06 05:30:00	SPY	ETF	453.38	453.71	453.0	453.04	60524.0
2021-12-06 06:00:00	SPY	ETF	453.24	454.34	453.24	453.89	56019.0
2021-12-06 06:30:00	SPY	ETF	454.02	455.3	454.02	455.29	79169.0
2021-12-06 07:00:00	SPY	ETF	455.34	455.5	454.36	454.59	143075.0
2021-12-06 07:30:00	SPY	ETF	454.5	454.96	454.38	454.61	95681.0
2021-12-06 08:00:00	SPY	ETF	454.68	456.4004	453.4204	454.9	175788.0
2021-12-06 08:30:00	SPY	ETF	454.92	455.59	454.57	455.59	283571.0
2021-12-06 09:00:00	SPY	ETF	455.57	456.17	455.16	456.11	339924.0
2021-12-06 09:30:00	SPY	ETF	456.14	456.71	453.56	456.25	10983787.0
2021-12-06 10:00:00	SPY	ETF	456.24	458.29	454.85	458.1	7931221.0
2021-12-06 10:30:00	SPY	ETF	458.11	458.4	456.83	458.318	4328940.0
2021-12-06 11:00:00	SPY	ETF	458.32	458.47	456.52	457.49	3395894.0
2021-12-06 11:30:00	SPY	ETF	457.49	458.26	456.922	457.37	2863634.0
2021-12-06 12:00:00	SPY	ETF	457.37	458.9	457.25	458.69	2996665.0
2021-12-06 12:30:00	SPY	ETF	458.71	459.65	458.34	459.63	3092706.0
2021-12-06 13:00:00	SPY	ETF	459.63	460.64	459.29	460.34	3830815.0
2021-12-06 13:30:00	SPY	ETF	460.34	460.5479	460.01	460.355	3651022.0
2021-12-06 14:00:00	SPY	ETF	460.36	460.79	460.04	460.2	3477920.0
2021-12-06 14:30:00	SPY	ETF	460.21	460.49	458.76	458.87	3706010.0
2021-12-06 15:00:00	SPY	ETF	458.86	459.62	458.56	459.02	4320738.0
2021-12-06 15:30:00	SPY	ETF	459.01	459.55	458.32	458.78	11892050.0
2021-12-06 16:00:00	SPY	ETF	458.78	459.02	458.44	459.01	6229695.0
2021-12-06 16:30:00	SPY	ETF	459.0	459.14	458.96	459.12	273935.0
2021-12-06 17:00:00	SPY	ETF	459.02	459.09	458.99	459.0	70045.0
2021-12-06 17:30:00	SPY	ETF	459.02	459.11	458.99	459.1	42851.0
2021-12-06 18:00:00	SPY	ETF	459.1	459.36	458.66	458.91	86037.0
2021-12-06 18:30:00	SPY	ETF	458.79	459.04	458.69	459.04	15398.0
2021-12-06 19:00:00	SPY	ETF	459.03	459.1	458.45	458.65	31483.0
2021-12-06 19:30:00	SPY	ETF	458.64	458.96	458.5	458.96	28511.0
2021-12-06 04:00:00	QQQ	ETF	384.13	385.4	384.13	385.03	63207.0
2021-12-06 04:30:00	QQQ	ETF	385.02	385.07	382.28	382.3	39377.0
2021-12-06 05:00:00	QQQ	ETF	382.48	382.84	381.27	381.48	41860.0
2021-12-06 05:30:00	QQQ	ETF	381.36	381.53	380.23	380.33	48089.0
2021-12-06 06:00:00	QQQ	ETF	380.27	381.78	380.27	381.24	38192.0
2021-12-06 06:30:00	QQQ	ETF	381.36	382.53	381.16	382.48	30129.0
2021-12-06 07:00:00	QQQ	ETF	382.48	382.6	381.25	381.48	142790.0
2021-12-06 07:30:00	QQQ	ETF	381.33	382.1	381.27	381.71	106641.0
2021-12-06 08:00:00	QQQ	ETF	382.09	385.1796	381.1696	382.38	205267.0
2021-12-06 08:30:00	QQQ	ETF	382.45	383.2	381.9	383.09	187009.0
2021-12-06 09:00:00	QQQ	ETF	383.01	383.95	382.61	383.58	218277.0
2021-12-06 09:30:00	QQQ	ETF	383.63	384.25	379.3	381.98	10288609.0
2021-12-06 10:00:00	QQQ	ETF	381.97	384.92	380.37	384.4	8161017.0
2021-12-06 10:30:00	QQQ	ETF	384.44	384.8568	381.7357	383.58	5426434.0
2021-12-06 11:00:00	QQQ	ETF	383.57	383.8	381.78	382.94	4129164.0
2021-12-06 11:30:00	QQQ	ETF	382.95	384.45	382.55	383.2174	3087430.0
2021-12-06 12:00:00	QQQ	ETF	383.22	384.99	382.9	384.742	2157767.0
2021-12-06 12:30:00	QQQ	ETF	384.75	385.93	384.45	385.92	2214860.0

> showing 50 of 25,576 rows — these rows as CSV

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