PREVIEW / etf_30min / 2020-02-04

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-04.parquet
  size:    562 KB
  rows:    19,948

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
2020-02-04 04:00:00	SPY	ETF	327.28	327.5	327.2	327.36	30666.0
2020-02-04 04:30:00	SPY	ETF	327.39	327.92	327.39	327.79	11805.0
2020-02-04 05:00:00	SPY	ETF	327.83	327.87	327.55	327.62	13321.0
2020-02-04 05:30:00	SPY	ETF	327.62	327.62	327.38	327.4	11559.0
2020-02-04 06:00:00	SPY	ETF	327.34	327.76	327.29	327.46	22295.0
2020-02-04 06:30:00	SPY	ETF	327.49	327.7	327.41	327.55	72031.0
2020-02-04 07:00:00	SPY	ETF	327.53	327.85	327.37	327.8	345938.0
2020-02-04 07:30:00	SPY	ETF	327.8	328.25	327.76	328.2	332240.0
2020-02-04 08:00:00	SPY	ETF	327.44	328.24	325.9	328.15	248819.0
2020-02-04 08:30:00	SPY	ETF	328.16	328.4	328.14	328.33	375477.0
2020-02-04 09:00:00	SPY	ETF	328.32	328.34	327.84	328.07	297551.0
2020-02-04 09:30:00	SPY	ETF	328.07	328.95	327.72	328.73	8913653.0
2020-02-04 10:00:00	SPY	ETF	328.75	329.12	328.28	329.12	4516463.0
2020-02-04 10:30:00	SPY	ETF	329.12	329.355	328.87	328.97	4275826.0
2020-02-04 11:00:00	SPY	ETF	328.96	329.55	328.86	329.39	2640540.0
2020-02-04 11:30:00	SPY	ETF	329.39	329.9	329.35	329.585	3039666.0
2020-02-04 12:00:00	SPY	ETF	329.59	329.88	329.48	329.81	2777797.0
2020-02-04 12:30:00	SPY	ETF	329.82	329.865	329.55	329.74	3855777.0
2020-02-04 13:00:00	SPY	ETF	329.745	329.8186	329.1	329.31	2764634.0
2020-02-04 13:30:00	SPY	ETF	329.2903	329.65	329.2809	329.6401	1643710.0
2020-02-04 14:00:00	SPY	ETF	329.65	329.89	329.54	329.59	2681927.0
2020-02-04 14:30:00	SPY	ETF	329.6	330.01	329.51	329.72	3223342.0
2020-02-04 15:00:00	SPY	ETF	329.715	329.84	329.42	329.7829	2916487.0
2020-02-04 15:30:00	SPY	ETF	329.78	329.87	328.88	329.08	9263011.0
2020-02-04 16:00:00	SPY	ETF	329.09	329.47	328.92	329.42	4030347.0
2020-02-04 16:30:00	SPY	ETF	329.43	329.74	329.0542	329.5	533954.0
2020-02-04 17:00:00	SPY	ETF	329.56	329.7	329.06	329.58	234254.0
2020-02-04 17:30:00	SPY	ETF	329.58	329.59	329.35	329.45	1011932.0
2020-02-04 18:00:00	SPY	ETF	329.48	329.53	329.18	329.4	179562.0
2020-02-04 18:30:00	SPY	ETF	329.4	329.42	328.86	328.93	84189.0
2020-02-04 19:00:00	SPY	ETF	328.91	329.27	328.73	328.75	68728.0
2020-02-04 19:30:00	SPY	ETF	328.75	328.89	328.6	328.66	81114.0
2020-02-04 04:00:00	QQQ	ETF	224.26	224.51	224.26	224.42	29252.0
2020-02-04 04:30:00	QQQ	ETF	224.44	224.81	224.44	224.76	23144.0
2020-02-04 05:00:00	QQQ	ETF	224.8	224.84	224.61	224.63	31923.0
2020-02-04 05:30:00	QQQ	ETF	224.63	224.63	224.5	224.51	3173.0
2020-02-04 06:00:00	QQQ	ETF	224.5	224.8	224.4	224.58	19314.0
2020-02-04 06:30:00	QQQ	ETF	224.66	224.77	224.56	224.68	28245.0
2020-02-04 07:00:00	QQQ	ETF	224.66	224.9	224.5	224.86	241368.0
2020-02-04 07:30:00	QQQ	ETF	224.86	225.35	224.86	225.33	210118.0
2020-02-04 08:00:00	QQQ	ETF	224.52	225.4	223.36	225.36	223409.0
2020-02-04 08:30:00	QQQ	ETF	225.37	225.5	225.29	225.45	133249.0
2020-02-04 09:00:00	QQQ	ETF	225.46	225.5	225.02	225.37	252134.0
2020-02-04 09:30:00	QQQ	ETF	225.39	225.85	224.6523	225.6	4543514.0
2020-02-04 10:00:00	QQQ	ETF	225.6	225.955	225.27	225.92	2192811.0
2020-02-04 10:30:00	QQQ	ETF	225.9344	226.33	225.825	226.05	1788694.0
2020-02-04 11:00:00	QQQ	ETF	226.06	226.66	226.04	226.53	1426415.0
2020-02-04 11:30:00	QQQ	ETF	226.55	227.12	226.52	227.01	1602061.0
2020-02-04 12:00:00	QQQ	ETF	227.017	227.21	226.905	227.055	1213721.0
2020-02-04 12:30:00	QQQ	ETF	227.06	227.15	226.93	227.125	1130744.0

> showing 50 of 19,948 rows — these rows as CSV

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