PREVIEW / etf_30min / 2021-12-21

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-21.parquet
  size:    667 KB
  rows:    26,145

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-21 04:00:00	SPY	ETF	457.56	458.43	457.47	458.28	26492.0
2021-12-21 04:30:00	SPY	ETF	458.33	458.35	457.2	457.2	13847.0
2021-12-21 05:00:00	SPY	ETF	457.1	458.09	457.09	457.82	5232.0
2021-12-21 05:30:00	SPY	ETF	457.82	458.41	457.77	458.41	9039.0
2021-12-21 06:00:00	SPY	ETF	458.37	459.53	458.34	459.49	55061.0
2021-12-21 06:30:00	SPY	ETF	459.6	459.6	459.21	459.41	57073.0
2021-12-21 07:00:00	SPY	ETF	459.47	459.58	459.19	459.41	112685.0
2021-12-21 07:30:00	SPY	ETF	459.45	459.75	459.19	459.56	65153.0
2021-12-21 08:00:00	SPY	ETF	459.62	459.69	455.321	458.9	343761.0
2021-12-21 08:30:00	SPY	ETF	458.9	459.29	458.75	459.17	224055.0
2021-12-21 09:00:00	SPY	ETF	459.16	459.22	458.51	458.61	255855.0
2021-12-21 09:30:00	SPY	ETF	458.57	459.5	457.1	457.39	6007056.0
2021-12-21 10:00:00	SPY	ETF	457.4	458.77	456.62	456.83	4264487.0
2021-12-21 10:30:00	SPY	ETF	456.85	457.64	456.31	457.48	3384089.0
2021-12-21 11:00:00	SPY	ETF	457.475	458.72	457.21	458.31	3146126.0
2021-12-21 11:30:00	SPY	ETF	458.32	460.36	458.28	459.785	3687398.0
2021-12-21 12:00:00	SPY	ETF	459.78	461.08	459.7	461.049	2465056.0
2021-12-21 12:30:00	SPY	ETF	461.05	461.94	460.97	461.86	2708671.0
2021-12-21 13:00:00	SPY	ETF	461.87	461.91	461.265	461.78	2357569.0
2021-12-21 13:30:00	SPY	ETF	461.79	462.54	461.77	462.1475	2906570.0
2021-12-21 14:00:00	SPY	ETF	462.15	462.55	461.86	462.23	2371892.0
2021-12-21 14:30:00	SPY	ETF	462.25	462.78	461.71	462.77	2498294.0
2021-12-21 15:00:00	SPY	ETF	462.77	462.899	462.26	462.37	3340701.0
2021-12-21 15:30:00	SPY	ETF	462.37	463.21	461.23	463.05	9853247.0
2021-12-21 16:00:00	SPY	ETF	463.03	463.44	462.53	463.24	3361769.0
2021-12-21 16:30:00	SPY	ETF	463.26	463.32	463.06	463.23	112760.0
2021-12-21 17:00:00	SPY	ETF	463.3	463.36	463.17	463.35	48441.0
2021-12-21 17:30:00	SPY	ETF	463.3	463.32	463.0499	463.05	87487.0
2021-12-21 18:00:00	SPY	ETF	463.11	463.22	462.75	462.81	104590.0
2021-12-21 18:30:00	SPY	ETF	463.06	463.06	462.69	462.84	25149.0
2021-12-21 19:00:00	SPY	ETF	462.78	463.06	462.5	462.98	43970.0
2021-12-21 19:30:00	SPY	ETF	462.92	462.99	462.6	462.71	30820.0
2021-12-21 04:00:00	QQQ	ETF	383.99	384.42	383.74	384.19	45853.0
2021-12-21 04:30:00	QQQ	ETF	384.26	384.29	383.17	383.28	24013.0
2021-12-21 05:00:00	QQQ	ETF	383.18	383.84	382.92	383.68	28775.0
2021-12-21 05:30:00	QQQ	ETF	383.4	383.95	383.4	383.87	24370.0
2021-12-21 06:00:00	QQQ	ETF	383.89	385.0	383.78	384.95	34842.0
2021-12-21 06:30:00	QQQ	ETF	384.93	385.07	384.66	384.85	38398.0
2021-12-21 07:00:00	QQQ	ETF	384.85	385.18	384.61	385.06	56919.0
2021-12-21 07:30:00	QQQ	ETF	385.02	385.41	384.89	385.23	64599.0
2021-12-21 08:00:00	QQQ	ETF	384.7101	385.5	380.975	384.62	127060.0
2021-12-21 08:30:00	QQQ	ETF	384.64	385.08	384.57	385.01	117133.0
2021-12-21 09:00:00	QQQ	ETF	385.0	385.04	383.94	384.0	247444.0
2021-12-21 09:30:00	QQQ	ETF	384.05	384.92	381.61	381.63	4821396.0
2021-12-21 10:00:00	QQQ	ETF	381.64	382.67	380.38	380.69	3735366.0
2021-12-21 10:30:00	QQQ	ETF	380.73	381.99	380.201	381.81	2488936.0
2021-12-21 11:00:00	QQQ	ETF	381.805	383.52	381.52	383.044	2209802.0
2021-12-21 11:30:00	QQQ	ETF	383.07	384.985	383.03	384.4899	2128479.0
2021-12-21 12:00:00	QQQ	ETF	384.47	385.915	384.25	385.8675	1714255.0
2021-12-21 12:30:00	QQQ	ETF	385.87	386.61	385.73	386.55	1504118.0

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

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