PREVIEW / etf_30min / 2021-01-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-22.parquet
  size:    624 KB
  rows:    23,361

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-01-22 04:00:00	SPY	ETF	382.59	382.71	382.06	382.17	21433.0
2021-01-22 04:30:00	SPY	ETF	382.0	382.0	381.38	381.73	22769.0
2021-01-22 05:00:00	SPY	ETF	381.6	381.98	381.5	381.94	45241.0
2021-01-22 05:30:00	SPY	ETF	382.05	382.05	381.36	381.43	43274.0
2021-01-22 06:00:00	SPY	ETF	381.59	381.59	381.08	381.42	162097.0
2021-01-22 06:30:00	SPY	ETF	381.33	381.62	381.02	381.61	44636.0
2021-01-22 07:00:00	SPY	ETF	381.46	381.78	381.23	381.27	164208.0
2021-01-22 07:30:00	SPY	ETF	381.42	381.64	380.97	381.64	258859.0
2021-01-22 08:00:00	SPY	ETF	381.6	383.4	381.0	381.55	295921.0
2021-01-22 08:30:00	SPY	ETF	381.54	381.9	381.4	381.72	238942.0
2021-01-22 09:00:00	SPY	ETF	381.66	382.275	381.59	382.2	412180.0
2021-01-22 09:30:00	SPY	ETF	382.25	383.0707	382.1599	382.9299	4430398.0
2021-01-22 10:00:00	SPY	ETF	382.915	383.32	381.95	382.205	2799143.0
2021-01-22 10:30:00	SPY	ETF	382.205	382.775	381.835	382.75	2558975.0
2021-01-22 11:00:00	SPY	ETF	382.74	383.07	382.6	382.71	2005636.0
2021-01-22 11:30:00	SPY	ETF	382.73	383.695	382.61	383.61	1704030.0
2021-01-22 12:00:00	SPY	ETF	383.61	383.84	383.28	383.69	1462035.0
2021-01-22 12:30:00	SPY	ETF	383.708	383.7363	383.4	383.4831	786435.0
2021-01-22 13:00:00	SPY	ETF	383.483	383.58	382.94	383.43	1369987.0
2021-01-22 13:30:00	SPY	ETF	383.43	383.73	383.21	383.22	1011445.0
2021-01-22 14:00:00	SPY	ETF	383.225	383.5	383.025	383.285	1831125.0
2021-01-22 14:30:00	SPY	ETF	383.29	383.76	383.23	383.73	1533374.0
2021-01-22 15:00:00	SPY	ETF	383.732	383.91	383.16	383.88	2153239.0
2021-01-22 15:30:00	SPY	ETF	383.87	384.08	382.8	382.86	5684145.0
2021-01-22 16:00:00	SPY	ETF	382.85	383.1	382.66	382.86	4142179.0
2021-01-22 16:30:00	SPY	ETF	382.87	382.97	382.63	382.64	898594.0
2021-01-22 17:00:00	SPY	ETF	382.74	382.88	382.66	382.88	153279.0
2021-01-22 17:30:00	SPY	ETF	382.88	382.88	382.67	382.72	48253.0
2021-01-22 18:00:00	SPY	ETF	382.7	382.8	382.5	382.69	36066.0
2021-01-22 18:30:00	SPY	ETF	382.88	382.88	382.5	382.6	14749.0
2021-01-22 19:00:00	SPY	ETF	382.66	382.75	382.52	382.75	30341.0
2021-01-22 19:30:00	SPY	ETF	382.68	382.83	382.6	382.74	33968.0
2021-01-22 04:00:00	QQQ	ETF	325.21	325.21	324.85	324.9	30560.0
2021-01-22 04:30:00	QQQ	ETF	324.91	324.93	324.42	324.82	21761.0
2021-01-22 05:00:00	QQQ	ETF	324.76	324.99	324.58	324.99	32475.0
2021-01-22 05:30:00	QQQ	ETF	324.96	324.98	324.51	324.64	21292.0
2021-01-22 06:00:00	QQQ	ETF	324.74	324.75	324.41	324.64	14818.0
2021-01-22 06:30:00	QQQ	ETF	324.6	324.75	324.33	324.66	28778.0
2021-01-22 07:00:00	QQQ	ETF	324.74	324.92	324.43	324.57	57803.0
2021-01-22 07:30:00	QQQ	ETF	324.58	324.67	324.15	324.62	93374.0
2021-01-22 08:00:00	QQQ	ETF	324.61	326.36	324.17	324.46	97988.0
2021-01-22 08:30:00	QQQ	ETF	324.38	324.77	324.25	324.73	203771.0
2021-01-22 09:00:00	QQQ	ETF	324.66	325.33	324.64	325.32	188328.0
2021-01-22 09:30:00	QQQ	ETF	325.3	326.35	324.81	326.1528	2658252.0
2021-01-22 10:00:00	QQQ	ETF	326.16	326.36	325.01	325.31	1488581.0
2021-01-22 10:30:00	QQQ	ETF	325.31	325.62	324.71	325.3702	1366529.0
2021-01-22 11:00:00	QQQ	ETF	325.38	325.85	325.19	325.27	708378.0
2021-01-22 11:30:00	QQQ	ETF	325.3	326.0	325.0599	325.78	857848.0
2021-01-22 12:00:00	QQQ	ETF	325.8	326.04	325.47	325.8895	616155.0
2021-01-22 12:30:00	QQQ	ETF	325.92	325.921	325.4216	325.54	612165.0

> showing 50 of 23,361 rows — these rows as CSV

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