PREVIEW / etf_5min / 2021-07-07

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-07.parquet
  size:    1.7 MB
  rows:    82,389

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-07-07 04:00:00	SPY	ETF	433.27	433.58	432.9	433.58	10160.0
2021-07-07 04:05:00	SPY	ETF	433.67	433.69	433.67	433.69	200.0
2021-07-07 04:10:00	SPY	ETF	433.59	433.59	433.44	433.44	200.0
2021-07-07 04:15:00	SPY	ETF	433.57	433.59	433.44	433.47	540.0
2021-07-07 04:20:00	SPY	ETF	433.49	433.49	433.32	433.32	1100.0
2021-07-07 04:25:00	SPY	ETF	433.4	433.42	433.4	433.4	400.0
2021-07-07 04:35:00	SPY	ETF	433.29	433.29	433.29	433.29	300.0
2021-07-07 04:40:00	SPY	ETF	433.29	433.3	433.1	433.1	875.0
2021-07-07 04:45:00	SPY	ETF	433.14	433.14	433.14	433.14	100.0
2021-07-07 04:55:00	SPY	ETF	433.18	433.22	433.18	433.22	2200.0
2021-07-07 05:00:00	SPY	ETF	433.2	433.37	433.2	433.37	1500.0
2021-07-07 05:05:00	SPY	ETF	433.4	433.45	433.4	433.45	400.0
2021-07-07 05:10:00	SPY	ETF	433.58	433.6	433.57	433.6	600.0
2021-07-07 05:20:00	SPY	ETF	433.56	433.66	433.49	433.6	900.0
2021-07-07 05:25:00	SPY	ETF	433.56	433.59	433.56	433.59	1000.0
2021-07-07 05:30:00	SPY	ETF	433.53	433.6	433.53	433.55	2300.0
2021-07-07 05:35:00	SPY	ETF	433.57	433.57	433.57	433.57	200.0
2021-07-07 05:45:00	SPY	ETF	433.62	433.64	433.61	433.64	500.0
2021-07-07 05:50:00	SPY	ETF	433.64	433.64	433.49	433.49	3027.0
2021-07-07 05:55:00	SPY	ETF	433.52	433.52	433.52	433.52	200.0
2021-07-07 06:00:00	SPY	ETF	433.44	433.44	433.44	433.44	2000.0
2021-07-07 06:15:00	SPY	ETF	433.28	433.31	433.28	433.31	400.0
2021-07-07 06:20:00	SPY	ETF	433.34	433.43	433.34	433.43	16100.0
2021-07-07 06:25:00	SPY	ETF	433.37	433.37	433.37	433.37	200.0
2021-07-07 06:30:00	SPY	ETF	433.4	433.4	433.4	433.4	100.0
2021-07-07 06:40:00	SPY	ETF	433.45	433.55	433.45	433.55	1480.0
2021-07-07 06:45:00	SPY	ETF	433.62	433.7	433.62	433.65	3020.0
2021-07-07 06:50:00	SPY	ETF	433.61	433.65	433.59	433.59	2795.0
2021-07-07 06:55:00	SPY	ETF	433.59	433.7	433.59	433.7	900.0
2021-07-07 07:00:00	SPY	ETF	433.64	433.68	433.52	433.57	96745.0
2021-07-07 07:05:00	SPY	ETF	433.58	433.74	433.57	433.72	154910.0
2021-07-07 07:10:00	SPY	ETF	433.63	433.63	433.56	433.59	82679.0
2021-07-07 07:15:00	SPY	ETF	433.59	433.59	433.48	433.48	35137.0
2021-07-07 07:20:00	SPY	ETF	433.47	433.52	433.45	433.52	37579.0
2021-07-07 07:25:00	SPY	ETF	433.49	433.62	433.48	433.5	18850.0
2021-07-07 07:30:00	SPY	ETF	433.48	433.59	433.46	433.56	6342.0
2021-07-07 07:35:00	SPY	ETF	433.6	433.66	433.54	433.56	8804.0
2021-07-07 07:40:00	SPY	ETF	433.56	433.61	433.56	433.56	2101.0
2021-07-07 07:45:00	SPY	ETF	433.53	433.56	433.51	433.53	3400.0
2021-07-07 07:50:00	SPY	ETF	433.54	433.59	433.52	433.59	6217.0
2021-07-07 07:55:00	SPY	ETF	433.61	433.73	433.61	433.66	31863.0
2021-07-07 08:00:00	SPY	ETF	433.6996	433.91	432.71	433.91	77706.0
2021-07-07 08:05:00	SPY	ETF	433.92	433.94	432.66	433.84	24621.0
2021-07-07 08:10:00	SPY	ETF	433.91	433.96	433.79	433.79	35504.0
2021-07-07 08:15:00	SPY	ETF	433.8	433.84	433.44	433.44	58413.0
2021-07-07 08:20:00	SPY	ETF	433.43	433.71	433.37	433.64	20652.0
2021-07-07 08:25:00	SPY	ETF	433.67	433.71	433.56	433.56	32207.0
2021-07-07 08:30:00	SPY	ETF	433.57	433.58	433.28	433.3	57632.0
2021-07-07 08:35:00	SPY	ETF	433.3	433.37	433.3	433.36	24651.0
2021-07-07 08:40:00	SPY	ETF	433.33	433.37	433.31	433.32	11808.0

> showing 50 of 82,389 rows — these rows as CSV

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