PREVIEW / etf_30min / 2021-02-03

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-03.parquet
  size:    619 KB
  rows:    23,422

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-02-03 04:00:00	SPY	ETF	383.17	383.3	382.54	382.85	31991.0
2021-02-03 04:30:00	SPY	ETF	382.92	382.94	382.64	382.74	8770.0
2021-02-03 05:00:00	SPY	ETF	382.71	382.89	382.61	382.72	11365.0
2021-02-03 05:30:00	SPY	ETF	382.71	383.23	382.66	383.12	12001.0
2021-02-03 06:00:00	SPY	ETF	383.1	383.14	382.9	382.9	37795.0
2021-02-03 06:30:00	SPY	ETF	382.89	383.2	382.83	383.16	109327.0
2021-02-03 07:00:00	SPY	ETF	383.13	383.18	382.46	382.63	104442.0
2021-02-03 07:30:00	SPY	ETF	382.59	382.92	382.45	382.56	90342.0
2021-02-03 08:00:00	SPY	ETF	382.54	383.5	382.41	382.71	349219.0
2021-02-03 08:30:00	SPY	ETF	382.76	383.04	382.67	382.99	104983.0
2021-02-03 09:00:00	SPY	ETF	382.96	383.05	381.55	382.45	276655.0
2021-02-03 09:30:00	SPY	ETF	382.44	382.92	381.77	382.893	5393308.0
2021-02-03 10:00:00	SPY	ETF	382.91	383.08	380.72	380.7725	4168633.0
2021-02-03 10:30:00	SPY	ETF	380.763	381.99	380.48	381.65	2757112.0
2021-02-03 11:00:00	SPY	ETF	381.66	382.16	381.42	381.91	1516001.0
2021-02-03 11:30:00	SPY	ETF	381.95	382.7699	381.58	382.69	1661463.0
2021-02-03 12:00:00	SPY	ETF	382.69	382.715	382.39	382.5101	1329889.0
2021-02-03 12:30:00	SPY	ETF	382.52	382.99	382.19	382.88	1210715.0
2021-02-03 13:00:00	SPY	ETF	382.88	382.98	382.64	382.91	932169.0
2021-02-03 13:30:00	SPY	ETF	382.9019	383.365	382.8	383.3098	1611917.0
2021-02-03 14:00:00	SPY	ETF	383.3001	383.61	383.22	383.51	1883407.0
2021-02-03 14:30:00	SPY	ETF	383.5	383.7	383.02	383.02	2670071.0
2021-02-03 15:00:00	SPY	ETF	383.01	383.195	382.39	382.5	2523379.0
2021-02-03 15:30:00	SPY	ETF	382.507	382.91	381.84	381.86	6632393.0
2021-02-03 16:00:00	SPY	ETF	381.87	382.89	381.8	382.76	5005407.0
2021-02-03 16:30:00	SPY	ETF	382.78	382.86	381.85	382.83	288702.0
2021-02-03 17:00:00	SPY	ETF	382.78	383.0	382.78	382.88	65067.0
2021-02-03 17:30:00	SPY	ETF	382.87	383.03	382.76	383.03	123644.0
2021-02-03 18:00:00	SPY	ETF	383.03	383.16	382.88	382.93	139543.0
2021-02-03 18:30:00	SPY	ETF	381.85	382.91	381.85	382.89	62086.0
2021-02-03 19:00:00	SPY	ETF	382.8	383.05	382.7	382.83	27882.0
2021-02-03 19:30:00	SPY	ETF	382.83	382.88	382.25	382.34	192902.0
2021-02-03 04:00:00	QQQ	ETF	330.11	330.33	329.71	329.86	17027.0
2021-02-03 04:30:00	QQQ	ETF	329.84	329.95	329.48	329.54	11871.0
2021-02-03 05:00:00	QQQ	ETF	329.52	329.77	329.48	329.71	6718.0
2021-02-03 05:30:00	QQQ	ETF	329.6	330.23	329.6	330.15	18536.0
2021-02-03 06:00:00	QQQ	ETF	329.84	330.15	329.84	329.9	7300.0
2021-02-03 06:30:00	QQQ	ETF	329.85	330.34	329.85	330.31	24063.0
2021-02-03 07:00:00	QQQ	ETF	330.3	330.31	329.59	329.69	92035.0
2021-02-03 07:30:00	QQQ	ETF	329.6	330.06	329.6	329.78	119945.0
2021-02-03 08:00:00	QQQ	ETF	329.9704	330.9	327.68	330.02	303951.0
2021-02-03 08:30:00	QQQ	ETF	329.98	330.16	329.8	330.0	59050.0
2021-02-03 09:00:00	QQQ	ETF	330.0104	330.08	329.4199	329.82	106968.0
2021-02-03 09:30:00	QQQ	ETF	329.82	330.195	328.115	329.67	3765382.0
2021-02-03 10:00:00	QQQ	ETF	329.72	329.83	326.46	326.5211	2658365.0
2021-02-03 10:30:00	QQQ	ETF	326.52	327.71	326.4	327.22	1570747.0
2021-02-03 11:00:00	QQQ	ETF	327.29	327.8	327.0442	327.33	870668.0
2021-02-03 11:30:00	QQQ	ETF	327.36	328.42	327.07	328.32	791364.0
2021-02-03 12:00:00	QQQ	ETF	328.33	328.58	328.17	328.39	880144.0
2021-02-03 12:30:00	QQQ	ETF	328.4	328.86	327.965	328.6	780868.0

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

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