PREVIEW / etf_30min / 2021-03-15

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-15.parquet
  size:    633 KB
  rows:    24,268

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-03-15 04:00:00	SPY	ETF	393.86	394.6	393.78	394.41	10342.0
2021-03-15 04:30:00	SPY	ETF	394.67	395.0	394.41	394.87	6071.0
2021-03-15 05:00:00	SPY	ETF	395.02	395.3	395.0	395.15	7665.0
2021-03-15 05:30:00	SPY	ETF	395.25	395.45	395.23	395.23	7300.0
2021-03-15 06:00:00	SPY	ETF	395.14	395.22	394.89	395.02	10987.0
2021-03-15 06:30:00	SPY	ETF	394.89	394.98	394.56	394.84	27575.0
2021-03-15 07:00:00	SPY	ETF	394.82	394.93	394.53	394.54	50631.0
2021-03-15 07:30:00	SPY	ETF	394.6	394.61	394.35	394.44	40973.0
2021-03-15 08:00:00	SPY	ETF	394.6699	395.1896	393.4	393.81	121556.0
2021-03-15 08:30:00	SPY	ETF	393.9	393.92	393.52	393.82	172076.0
2021-03-15 09:00:00	SPY	ETF	393.85	394.41	393.76	394.37	171009.0
2021-03-15 09:30:00	SPY	ETF	394.33	394.675	393.67	393.989	6065751.0
2021-03-15 10:00:00	SPY	ETF	393.98	394.13	393.3501	393.6	3647485.0
2021-03-15 10:30:00	SPY	ETF	393.59	393.985	393.33	393.95	3168321.0
2021-03-15 11:00:00	SPY	ETF	393.95	394.17	392.87	392.99	3733473.0
2021-03-15 11:30:00	SPY	ETF	392.99	393.21	392.03	393.075	4978540.0
2021-03-15 12:00:00	SPY	ETF	393.07	393.66	392.97	393.605	2701407.0
2021-03-15 12:30:00	SPY	ETF	393.6079	394.18	393.5216	394.159	2512794.0
2021-03-15 13:00:00	SPY	ETF	394.16	394.2386	393.88	394.165	1798456.0
2021-03-15 13:30:00	SPY	ETF	394.1619	394.6599	394.095	394.65	1721928.0
2021-03-15 14:00:00	SPY	ETF	394.659	395.3	394.651	395.3	3088677.0
2021-03-15 14:30:00	SPY	ETF	395.3014	395.51	395.02	395.23	2553888.0
2021-03-15 15:00:00	SPY	ETF	395.23	395.365	394.59	394.73	3666393.0
2021-03-15 15:30:00	SPY	ETF	394.73	396.685	394.5	396.47	11118936.0
2021-03-15 16:00:00	SPY	ETF	396.47	396.73	396.3	396.37	4512966.0
2021-03-15 16:30:00	SPY	ETF	396.36	396.4999	396.32	396.38	195075.0
2021-03-15 17:00:00	SPY	ETF	396.42	396.56	396.28	396.47	75772.0
2021-03-15 17:30:00	SPY	ETF	396.41	396.57	396.41	396.45	62986.0
2021-03-15 18:00:00	SPY	ETF	396.45	396.45	396.01	396.06	118652.0
2021-03-15 18:30:00	SPY	ETF	396.41	396.41	395.91	395.99	58351.0
2021-03-15 19:00:00	SPY	ETF	395.93	396.15	395.88	396.04	19691.0
2021-03-15 19:30:00	SPY	ETF	396.08	396.15	395.9	395.92	20846.0
2021-03-15 04:00:00	QQQ	ETF	314.56	315.6	314.34	315.35	25147.0
2021-03-15 04:30:00	QQQ	ETF	315.4	316.04	315.22	316.0	13980.0
2021-03-15 05:00:00	QQQ	ETF	316.08	316.49	316.08	316.42	10119.0
2021-03-15 05:30:00	QQQ	ETF	316.41	316.91	316.41	316.63	19096.0
2021-03-15 06:00:00	QQQ	ETF	316.63	316.69	316.07	316.28	40037.0
2021-03-15 06:30:00	QQQ	ETF	316.17	316.63	315.81	316.32	26053.0
2021-03-15 07:00:00	QQQ	ETF	316.3	316.57	315.86	315.91	100597.0
2021-03-15 07:30:00	QQQ	ETF	315.92	316.03	315.25	315.48	143308.0
2021-03-15 08:00:00	QQQ	ETF	316.18	316.5804	313.99	315.0	131456.0
2021-03-15 08:30:00	QQQ	ETF	315.09	315.39	314.82	315.29	113718.0
2021-03-15 09:00:00	QQQ	ETF	315.24	315.96	315.2	315.81	203345.0
2021-03-15 09:30:00	QQQ	ETF	315.81	316.59	314.52	316.08	6151791.0
2021-03-15 10:00:00	QQQ	ETF	316.07	316.9	315.16	315.42	3077054.0
2021-03-15 10:30:00	QQQ	ETF	315.429	316.43	314.77	316.39	2785240.0
2021-03-15 11:00:00	QQQ	ETF	316.38	316.7	314.71	314.92	2391320.0
2021-03-15 11:30:00	QQQ	ETF	314.92	315.55	314.095	315.34	2518956.0
2021-03-15 12:00:00	QQQ	ETF	315.32	315.89	315.17	315.62	1613933.0
2021-03-15 12:30:00	QQQ	ETF	315.61	316.28	315.46	316.04	1475245.0

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

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