PREVIEW / etf_5min / 2020-01-30

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-01-30.parquet
  size:    1.6 MB
  rows:    69,980

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-01-30 04:00:00	SPY	ETF	324.5	324.5	324.3	324.42	10709.0
2020-01-30 04:05:00	SPY	ETF	324.42	324.8	324.42	324.8	10604.0
2020-01-30 04:10:00	SPY	ETF	324.7	324.73	324.67	324.69	5660.0
2020-01-30 04:15:00	SPY	ETF	324.73	324.89	324.73	324.88	1160.0
2020-01-30 04:20:00	SPY	ETF	325.0	325.32	325.0	325.24	11177.0
2020-01-30 04:25:00	SPY	ETF	325.05	325.06	325.0	325.06	1989.0
2020-01-30 04:30:00	SPY	ETF	324.97	324.99	324.85	324.85	3235.0
2020-01-30 04:35:00	SPY	ETF	324.83	325.0	324.83	325.0	1941.0
2020-01-30 04:40:00	SPY	ETF	324.75	324.78	324.7	324.78	2821.0
2020-01-30 04:45:00	SPY	ETF	324.72	324.72	324.65	324.65	2060.0
2020-01-30 04:50:00	SPY	ETF	324.67	324.92	324.66	324.92	1660.0
2020-01-30 04:55:00	SPY	ETF	324.85	324.85	324.78	324.78	1222.0
2020-01-30 05:00:00	SPY	ETF	324.69	324.71	324.57	324.71	1705.0
2020-01-30 05:05:00	SPY	ETF	324.67	324.67	324.67	324.67	438.0
2020-01-30 05:10:00	SPY	ETF	324.7	324.72	324.7	324.72	425.0
2020-01-30 05:15:00	SPY	ETF	324.76	324.76	324.76	324.76	100.0
2020-01-30 05:20:00	SPY	ETF	324.59	324.59	324.5	324.5	1345.0
2020-01-30 05:25:00	SPY	ETF	324.57	324.66	324.57	324.61	2130.0
2020-01-30 05:30:00	SPY	ETF	324.5	324.59	324.43	324.52	3028.0
2020-01-30 05:35:00	SPY	ETF	324.49	324.52	324.47	324.49	1916.0
2020-01-30 05:40:00	SPY	ETF	324.52	324.61	324.52	324.6	1685.0
2020-01-30 05:45:00	SPY	ETF	324.58	324.75	324.58	324.75	2260.0
2020-01-30 05:50:00	SPY	ETF	324.74	324.74	324.74	324.74	302.0
2020-01-30 05:55:00	SPY	ETF	324.67	324.67	324.55	324.55	353.0
2020-01-30 06:05:00	SPY	ETF	324.49	324.49	324.42	324.42	310.0
2020-01-30 06:10:00	SPY	ETF	324.31	324.31	324.26	324.26	300.0
2020-01-30 06:15:00	SPY	ETF	324.06	324.08	323.96	324.06	10767.0
2020-01-30 06:20:00	SPY	ETF	324.08	324.09	323.8	323.84	12796.0
2020-01-30 06:25:00	SPY	ETF	323.82	324.12	323.82	324.12	4226.0
2020-01-30 06:30:00	SPY	ETF	324.12	324.18	324.08	324.09	4925.0
2020-01-30 06:35:00	SPY	ETF	324.13	324.25	324.13	324.25	1785.0
2020-01-30 06:40:00	SPY	ETF	324.19	324.29	324.19	324.26	2610.0
2020-01-30 06:45:00	SPY	ETF	324.3	324.43	324.3	324.43	69651.0
2020-01-30 06:50:00	SPY	ETF	324.42	324.49	324.24	324.24	33803.0
2020-01-30 06:55:00	SPY	ETF	324.23	324.38	324.21	324.38	5856.0
2020-01-30 07:00:00	SPY	ETF	324.43	324.45	324.2	324.4	77654.0
2020-01-30 07:05:00	SPY	ETF	324.37	324.41	324.22	324.38	19184.0
2020-01-30 07:10:00	SPY	ETF	324.37	324.48	324.35	324.46	27888.0
2020-01-30 07:15:00	SPY	ETF	324.47	324.54	324.42	324.45	35619.0
2020-01-30 07:20:00	SPY	ETF	324.52	324.55	324.17	324.21	71174.0
2020-01-30 07:25:00	SPY	ETF	324.21	324.28	324.17	324.21	11751.0
2020-01-30 07:30:00	SPY	ETF	324.15	324.15	324.04	324.04	46072.0
2020-01-30 07:35:00	SPY	ETF	324.04	324.25	324.0	324.22	37514.0
2020-01-30 07:40:00	SPY	ETF	324.22	324.36	324.18	324.36	99398.0
2020-01-30 07:45:00	SPY	ETF	324.34	324.34	324.13	324.16	6066.0
2020-01-30 07:50:00	SPY	ETF	324.17	324.17	324.07	324.15	29595.0
2020-01-30 07:55:00	SPY	ETF	324.14	324.14	323.96	324.05	73035.0
2020-01-30 08:00:00	SPY	ETF	324.45	325.1	323.48	324.08	53016.0
2020-01-30 08:05:00	SPY	ETF	324.1	326.62	323.97	323.97	17554.0
2020-01-30 08:10:00	SPY	ETF	323.95	325.05	323.84	324.28	173841.0

> showing 50 of 69,980 rows — these rows as CSV

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