PREVIEW / etf_5min / 2019-11-05

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-11-05.parquet
  size:    1.5 MB
  rows:    64,631

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
2019-11-05 04:00:00	SPY	ETF	307.86	307.94	307.86	307.94	8406.0
2019-11-05 04:10:00	SPY	ETF	307.9	307.91	307.9	307.91	300.0
2019-11-05 04:15:00	SPY	ETF	307.91	307.91	307.9	307.9	264.0
2019-11-05 04:20:00	SPY	ETF	307.97	308.02	307.97	308.02	401.0
2019-11-05 04:25:00	SPY	ETF	308.05	308.05	308.02	308.02	300.0
2019-11-05 04:30:00	SPY	ETF	308.03	308.03	308.03	308.03	705.0
2019-11-05 04:35:00	SPY	ETF	308.03	308.1	308.03	308.1	36510.0
2019-11-05 04:40:00	SPY	ETF	308.05	308.1	308.03	308.03	14990.0
2019-11-05 04:45:00	SPY	ETF	307.97	307.97	307.97	307.97	200.0
2019-11-05 04:55:00	SPY	ETF	307.93	307.93	307.93	307.93	303.0
2019-11-05 05:00:00	SPY	ETF	308.04	308.05	308.04	308.05	3000.0
2019-11-05 05:05:00	SPY	ETF	308.06	308.1	308.06	308.1	500.0
2019-11-05 05:10:00	SPY	ETF	308.15	308.17	308.15	308.17	2100.0
2019-11-05 05:15:00	SPY	ETF	308.15	308.15	308.15	308.15	1000.0
2019-11-05 05:20:00	SPY	ETF	308.13	308.13	308.13	308.13	500.0
2019-11-05 05:25:00	SPY	ETF	308.18	308.18	308.1	308.13	1010.0
2019-11-05 05:30:00	SPY	ETF	308.09	308.13	308.09	308.13	400.0
2019-11-05 05:35:00	SPY	ETF	308.16	308.16	308.16	308.16	100.0
2019-11-05 05:40:00	SPY	ETF	308.11	308.11	308.11	308.11	800.0
2019-11-05 05:45:00	SPY	ETF	308.13	308.2	308.13	308.16	6625.0
2019-11-05 05:50:00	SPY	ETF	308.21	308.21	308.12	308.12	2600.0
2019-11-05 06:00:00	SPY	ETF	308.13	308.13	308.07	308.11	1500.0
2019-11-05 06:05:00	SPY	ETF	308.11	308.11	307.86	308.04	3823.0
2019-11-05 06:10:00	SPY	ETF	308.01	308.01	307.93	307.93	3103.0
2019-11-05 06:15:00	SPY	ETF	307.91	307.98	307.91	307.98	1545.0
2019-11-05 06:25:00	SPY	ETF	307.94	307.94	307.94	307.94	100.0
2019-11-05 06:30:00	SPY	ETF	307.89	307.89	307.81	307.81	5400.0
2019-11-05 06:35:00	SPY	ETF	307.86	307.9	307.83	307.83	5100.0
2019-11-05 06:40:00	SPY	ETF	307.83	307.84	307.83	307.84	200.0
2019-11-05 06:45:00	SPY	ETF	307.86	307.86	307.78	307.78	27900.0
2019-11-05 06:50:00	SPY	ETF	307.78	307.84	307.78	307.83	8000.0
2019-11-05 06:55:00	SPY	ETF	307.79	307.86	307.75	307.86	820.0
2019-11-05 07:00:00	SPY	ETF	307.82	307.92	307.8	307.92	6408.0
2019-11-05 07:05:00	SPY	ETF	307.92	308.01	307.89	308.01	12761.0
2019-11-05 07:10:00	SPY	ETF	308.04	308.04	307.99	308.02	1961.0
2019-11-05 07:15:00	SPY	ETF	308.02	308.03	307.97	307.97	33480.0
2019-11-05 07:20:00	SPY	ETF	308.0	308.0	307.97	307.98	4836.0
2019-11-05 07:25:00	SPY	ETF	307.98	307.98	307.91	307.91	8183.0
2019-11-05 07:30:00	SPY	ETF	307.93	307.93	307.89	307.91	10237.0
2019-11-05 07:35:00	SPY	ETF	307.9	307.9	307.9	307.9	100.0
2019-11-05 07:40:00	SPY	ETF	307.93	307.98	307.93	307.96	4610.0
2019-11-05 07:45:00	SPY	ETF	307.96	308.04	307.96	307.98	16262.0
2019-11-05 07:50:00	SPY	ETF	307.92	307.94	307.92	307.92	2425.0
2019-11-05 07:55:00	SPY	ETF	307.92	307.92	307.92	307.92	900.0
2019-11-05 08:00:00	SPY	ETF	307.9899	308.01	307.79	307.97	10428.0
2019-11-05 08:05:00	SPY	ETF	307.93	307.93	307.85	307.86	30287.0
2019-11-05 08:10:00	SPY	ETF	307.86	307.91	307.86	307.91	7511.0
2019-11-05 08:15:00	SPY	ETF	307.91	307.95	307.91	307.92	4126.0
2019-11-05 08:20:00	SPY	ETF	307.93	307.95	307.91	307.91	2801.0
2019-11-05 08:25:00	SPY	ETF	307.91	307.92	307.81	307.88	19441.0

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

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