PREVIEW / etf_5min / 2021-03-31

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-03-31.parquet
  size:    1.8 MB
  rows:    84,060

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-31 04:00:00	SPY	ETF	394.22	394.34	394.22	394.34	600.0
2021-03-31 04:05:00	SPY	ETF	394.25	394.25	394.22	394.22	200.0
2021-03-31 04:15:00	SPY	ETF	394.2	394.2	394.19	394.19	1300.0
2021-03-31 04:20:00	SPY	ETF	394.22	394.27	394.22	394.22	2600.0
2021-03-31 04:25:00	SPY	ETF	394.04	394.04	394.04	394.04	100.0
2021-03-31 04:30:00	SPY	ETF	393.99	393.99	393.99	393.99	100.0
2021-03-31 04:35:00	SPY	ETF	393.93	393.97	393.93	393.96	1400.0
2021-03-31 04:45:00	SPY	ETF	394.07	394.07	394.07	394.07	200.0
2021-03-31 04:50:00	SPY	ETF	394.02	394.3	394.02	394.3	3400.0
2021-03-31 04:55:00	SPY	ETF	394.4	394.4	394.4	394.4	100.0
2021-03-31 05:05:00	SPY	ETF	394.27	394.27	394.27	394.27	300.0
2021-03-31 05:15:00	SPY	ETF	394.3	394.3	394.3	394.3	100.0
2021-03-31 05:25:00	SPY	ETF	394.24	394.24	394.23	394.23	2000.0
2021-03-31 05:30:00	SPY	ETF	394.2	394.24	394.18	394.24	1710.0
2021-03-31 05:35:00	SPY	ETF	394.19	394.3	394.19	394.3	700.0
2021-03-31 05:45:00	SPY	ETF	394.3	394.42	394.3	394.42	2900.0
2021-03-31 05:50:00	SPY	ETF	394.5	394.5	394.44	394.44	900.0
2021-03-31 05:55:00	SPY	ETF	394.44	394.44	394.35	394.35	500.0
2021-03-31 06:00:00	SPY	ETF	394.4	394.49	394.4	394.49	1678.0
2021-03-31 06:05:00	SPY	ETF	394.38	394.43	394.35	394.43	4000.0
2021-03-31 06:10:00	SPY	ETF	394.45	394.45	394.45	394.45	100.0
2021-03-31 06:15:00	SPY	ETF	394.47	394.47	394.36	394.36	10700.0
2021-03-31 06:20:00	SPY	ETF	394.53	394.53	394.53	394.53	300.0
2021-03-31 06:25:00	SPY	ETF	394.57	394.61	394.48	394.48	8400.0
2021-03-31 06:30:00	SPY	ETF	394.46	394.5	394.46	394.5	1198.0
2021-03-31 06:35:00	SPY	ETF	394.64	394.64	394.64	394.64	100.0
2021-03-31 06:40:00	SPY	ETF	394.69	394.8	394.69	394.8	750.0
2021-03-31 06:45:00	SPY	ETF	394.75	394.79	394.71	394.74	3600.0
2021-03-31 06:50:00	SPY	ETF	394.78	394.83	394.75	394.79	5600.0
2021-03-31 06:55:00	SPY	ETF	394.81	394.81	394.75	394.75	800.0
2021-03-31 07:00:00	SPY	ETF	394.73	394.75	394.49	394.74	7442.0
2021-03-31 07:05:00	SPY	ETF	394.76	394.83	394.76	394.81	12354.0
2021-03-31 07:10:00	SPY	ETF	394.77	394.78	394.7	394.71	2983.0
2021-03-31 07:15:00	SPY	ETF	394.7	394.8	394.7	394.76	2563.0
2021-03-31 07:20:00	SPY	ETF	394.79	394.83	394.76	394.8	16264.0
2021-03-31 07:25:00	SPY	ETF	394.8	394.83	394.71	394.71	1036.0
2021-03-31 07:30:00	SPY	ETF	394.71	394.71	394.7	394.71	1815.0
2021-03-31 07:35:00	SPY	ETF	394.68	394.91	394.68	394.86	21202.0
2021-03-31 07:40:00	SPY	ETF	394.87	394.88	394.8	394.81	4345.0
2021-03-31 07:45:00	SPY	ETF	394.8	395.0	394.8	395.0	2900.0
2021-03-31 07:50:00	SPY	ETF	395.0	395.05	394.899	394.899	13213.0
2021-03-31 07:55:00	SPY	ETF	394.95	395.0	394.95	394.95	5071.0
2021-03-31 08:00:00	SPY	ETF	394.5096	395.02	393.96	394.92	11995.0
2021-03-31 08:05:00	SPY	ETF	394.9301	395.01	394.9301	395.0	6028.0
2021-03-31 08:10:00	SPY	ETF	394.99	395.03	394.97	394.98	10647.0
2021-03-31 08:15:00	SPY	ETF	395.0	395.18	394.96	395.06	32953.0
2021-03-31 08:20:00	SPY	ETF	395.04	395.04	394.81	394.9	8186.0
2021-03-31 08:25:00	SPY	ETF	394.93	395.01	394.9	395.01	12472.0
2021-03-31 08:30:00	SPY	ETF	395.05	395.16	395.05	395.14	15614.0
2021-03-31 08:35:00	SPY	ETF	395.12	395.2	395.12	395.2	7935.0

> showing 50 of 84,060 rows — these rows as CSV

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