PREVIEW / etf_5min / 2020-02-14

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-02-14.parquet
  size:    1.5 MB
  rows:    64,227

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-14 04:00:00	SPY	ETF	337.75	337.75	337.73	337.74	965.0
2020-02-14 04:05:00	SPY	ETF	337.65	337.66	337.62	337.62	1484.0
2020-02-14 04:10:00	SPY	ETF	337.61	337.61	337.61	337.61	1000.0
2020-02-14 04:15:00	SPY	ETF	337.63	337.84	337.63	337.83	950.0
2020-02-14 04:20:00	SPY	ETF	337.81	337.81	337.71	337.71	530.0
2020-02-14 04:30:00	SPY	ETF	337.71	337.71	337.64	337.64	984.0
2020-02-14 04:35:00	SPY	ETF	337.65	337.7	337.62	337.7	6210.0
2020-02-14 04:40:00	SPY	ETF	337.74	337.85	337.74	337.85	1289.0
2020-02-14 04:50:00	SPY	ETF	337.78	337.78	337.78	337.78	955.0
2020-02-14 05:05:00	SPY	ETF	337.86	337.86	337.86	337.86	100.0
2020-02-14 05:10:00	SPY	ETF	337.93	338.0	337.93	338.0	3286.0
2020-02-14 05:20:00	SPY	ETF	337.96	337.99	337.96	337.98	2300.0
2020-02-14 05:25:00	SPY	ETF	337.88	337.88	337.88	337.88	310.0
2020-02-14 05:35:00	SPY	ETF	337.93	337.96	337.93	337.96	6000.0
2020-02-14 05:40:00	SPY	ETF	337.93	338.04	337.89	338.04	1471.0
2020-02-14 05:45:00	SPY	ETF	338.02	338.04	338.02	338.03	1700.0
2020-02-14 05:50:00	SPY	ETF	337.96	337.96	337.96	337.96	1490.0
2020-02-14 05:55:00	SPY	ETF	337.92	337.92	337.91	337.91	810.0
2020-02-14 06:00:00	SPY	ETF	337.95	337.95	337.95	337.95	100.0
2020-02-14 06:05:00	SPY	ETF	337.86	337.86	337.86	337.86	300.0
2020-02-14 06:10:00	SPY	ETF	337.8	337.8	337.8	337.8	160.0
2020-02-14 06:15:00	SPY	ETF	337.81	337.81	337.81	337.81	195.0
2020-02-14 06:20:00	SPY	ETF	337.8	337.88	337.8	337.88	320.0
2020-02-14 06:25:00	SPY	ETF	337.97	337.98	337.97	337.98	320.0
2020-02-14 06:35:00	SPY	ETF	337.96	337.96	337.93	337.93	205.0
2020-02-14 06:40:00	SPY	ETF	337.96	337.96	337.96	337.96	400.0
2020-02-14 06:45:00	SPY	ETF	337.9	337.9	337.84	337.85	1510.0
2020-02-14 06:55:00	SPY	ETF	337.83	337.98	337.82	337.98	1760.0
2020-02-14 07:00:00	SPY	ETF	337.91	338.1	337.91	338.1	11988.0
2020-02-14 07:05:00	SPY	ETF	338.1	338.11	338.04	338.04	16145.0
2020-02-14 07:10:00	SPY	ETF	338.03	338.03	338.0	338.0	19571.0
2020-02-14 07:15:00	SPY	ETF	338.03	338.05	338.0	338.02	11628.0
2020-02-14 07:20:00	SPY	ETF	338.0	338.02	337.93	337.93	33935.0
2020-02-14 07:25:00	SPY	ETF	337.99	338.0	337.99	338.0	405.0
2020-02-14 07:30:00	SPY	ETF	338.0	338.0	337.98	338.0	50914.0
2020-02-14 07:35:00	SPY	ETF	338.0	338.1	338.0	338.09	104772.0
2020-02-14 07:40:00	SPY	ETF	338.09	338.14	338.01	338.01	48807.0
2020-02-14 07:45:00	SPY	ETF	338.04	338.05	338.04	338.04	4104.0
2020-02-14 07:50:00	SPY	ETF	338.07	338.16	338.06	338.15	24759.0
2020-02-14 07:55:00	SPY	ETF	338.17	338.24	338.14	338.14	23880.0
2020-02-14 08:00:00	SPY	ETF	338.13	338.2	337.76	338.06	47707.0
2020-02-14 08:05:00	SPY	ETF	338.0	338.06	337.67	338.06	29463.0
2020-02-14 08:10:00	SPY	ETF	338.06	338.08	338.0	338.04	3368.0
2020-02-14 08:15:00	SPY	ETF	338.02	338.06	337.9801	338.02	28052.0
2020-02-14 08:20:00	SPY	ETF	338.03	338.05	337.98	337.98	35620.0
2020-02-14 08:25:00	SPY	ETF	337.9699	338.02	337.94	338.02	5803.0
2020-02-14 08:30:00	SPY	ETF	338.03	338.03	337.79	337.83	14832.0
2020-02-14 08:35:00	SPY	ETF	337.8	337.83	337.53	337.67	54671.0
2020-02-14 08:40:00	SPY	ETF	337.6	337.69	337.56	337.58	27360.0
2020-02-14 08:45:00	SPY	ETF	337.56	337.569	337.27	337.44	128816.0

> showing 50 of 64,227 rows — these rows as CSV

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