PREVIEW / etf_5min / 2019-12-02

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-02.parquet
  size:    1.5 MB
  rows:    64,987

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-12-02 04:00:00	SPY	ETF	315.57	315.8	315.57	315.78	4635.0
2019-12-02 04:05:00	SPY	ETF	315.68	315.73	315.68	315.7	1005.0
2019-12-02 04:10:00	SPY	ETF	315.74	315.74	315.74	315.74	2500.0
2019-12-02 04:15:00	SPY	ETF	315.7	315.7	315.7	315.7	100.0
2019-12-02 04:20:00	SPY	ETF	315.69	315.7	315.66	315.66	2900.0
2019-12-02 04:30:00	SPY	ETF	315.6	315.67	315.6	315.67	900.0
2019-12-02 04:40:00	SPY	ETF	315.55	315.55	315.55	315.55	950.0
2019-12-02 04:45:00	SPY	ETF	315.57	315.57	315.57	315.57	400.0
2019-12-02 04:50:00	SPY	ETF	315.53	315.57	315.5	315.53	1300.0
2019-12-02 05:10:00	SPY	ETF	315.6	315.69	315.6	315.69	600.0
2019-12-02 05:15:00	SPY	ETF	315.67	315.69	315.67	315.69	750.0
2019-12-02 05:20:00	SPY	ETF	315.75	315.75	315.7	315.7	600.0
2019-12-02 05:25:00	SPY	ETF	315.73	315.73	315.73	315.73	900.0
2019-12-02 05:30:00	SPY	ETF	315.7	315.74	315.7	315.74	970.0
2019-12-02 05:35:00	SPY	ETF	315.74	315.74	315.74	315.74	100.0
2019-12-02 05:45:00	SPY	ETF	315.65	315.65	315.58	315.58	2030.0
2019-12-02 05:50:00	SPY	ETF	315.61	315.64	315.61	315.64	450.0
2019-12-02 05:55:00	SPY	ETF	315.64	315.64	315.6	315.6	2518.0
2019-12-02 06:00:00	SPY	ETF	315.55	315.55	315.38	315.47	4263.0
2019-12-02 06:05:00	SPY	ETF	315.39	315.39	315.33	315.37	2200.0
2019-12-02 06:10:00	SPY	ETF	315.33	315.33	315.23	315.23	1200.0
2019-12-02 06:15:00	SPY	ETF	315.2	315.2	315.05	315.15	2834.0
2019-12-02 06:20:00	SPY	ETF	315.17	315.2	315.15	315.2	500.0
2019-12-02 06:25:00	SPY	ETF	315.2	315.2	315.2	315.2	2311.0
2019-12-02 06:30:00	SPY	ETF	315.2	315.2	314.92	314.92	4566.0
2019-12-02 06:35:00	SPY	ETF	314.91	314.91	314.79	314.81	2460.0
2019-12-02 06:40:00	SPY	ETF	314.88	314.92	314.88	314.91	2455.0
2019-12-02 06:45:00	SPY	ETF	315.03	315.03	315.03	315.03	305.0
2019-12-02 06:50:00	SPY	ETF	314.96	314.96	314.91	314.91	5725.0
2019-12-02 06:55:00	SPY	ETF	314.9	315.01	314.88	315.01	2423.0
2019-12-02 07:00:00	SPY	ETF	314.99	314.99	314.91	314.93	10055.0
2019-12-02 07:05:00	SPY	ETF	314.94	315.03	314.91	315.03	74631.0
2019-12-02 07:10:00	SPY	ETF	315.0	315.02	314.95	314.95	36161.0
2019-12-02 07:15:00	SPY	ETF	314.98	314.98	314.95	314.95	2112.0
2019-12-02 07:20:00	SPY	ETF	314.99	314.99	314.82	314.93	11358.0
2019-12-02 07:25:00	SPY	ETF	314.93	314.93	314.9	314.93	1662.0
2019-12-02 07:30:00	SPY	ETF	314.96	315.0	314.96	315.0	4580.0
2019-12-02 07:35:00	SPY	ETF	314.98	315.01	314.95	314.96	49509.0
2019-12-02 07:40:00	SPY	ETF	314.88	314.97	314.88	314.97	1462.0
2019-12-02 07:45:00	SPY	ETF	314.92	314.92	314.92	314.92	200.0
2019-12-02 07:50:00	SPY	ETF	314.99	314.99	314.97	314.97	2047.0
2019-12-02 07:55:00	SPY	ETF	314.98	315.07	314.97	315.01	24556.0
2019-12-02 08:00:00	SPY	ETF	314.97	315.42	314.92	314.98	11117.0
2019-12-02 08:05:00	SPY	ETF	314.97	314.97	314.93	314.93	5700.0
2019-12-02 08:10:00	SPY	ETF	314.9401	314.96	314.89	314.89	18083.0
2019-12-02 08:15:00	SPY	ETF	314.9	314.9	314.6	314.81	43291.0
2019-12-02 08:20:00	SPY	ETF	314.78	314.78	314.1872	314.74	18133.0
2019-12-02 08:25:00	SPY	ETF	314.71	314.77	314.69	314.77	25200.0
2019-12-02 08:30:00	SPY	ETF	314.77	314.77	314.51	314.58	33348.0
2019-12-02 08:35:00	SPY	ETF	314.54	314.62	314.52	314.62	8943.0

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

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