PREVIEW / etf_5min / 2018-02-09

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-09.parquet
  size:    1.7 MB
  rows:    71,690

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
2018-02-09 04:00:00	SPY	ETF	261.08	261.16	260.92	260.99	7209.0
2018-02-09 04:05:00	SPY	ETF	260.99	261.0	260.86	260.99	6083.0
2018-02-09 04:10:00	SPY	ETF	261.0	261.09	260.99	261.02	7210.0
2018-02-09 04:15:00	SPY	ETF	261.02	261.05	260.75	260.75	6870.0
2018-02-09 04:20:00	SPY	ETF	260.78	260.94	260.78	260.86	8620.0
2018-02-09 04:25:00	SPY	ETF	260.56	260.61	260.56	260.61	2150.0
2018-02-09 04:30:00	SPY	ETF	260.53	260.66	260.5	260.66	4207.0
2018-02-09 04:35:00	SPY	ETF	260.67	260.86	260.67	260.86	3776.0
2018-02-09 04:40:00	SPY	ETF	260.79	260.93	260.79	260.93	6257.0
2018-02-09 04:45:00	SPY	ETF	260.95	260.95	260.56	260.68	4953.0
2018-02-09 04:50:00	SPY	ETF	260.8	260.8	260.63	260.63	1425.0
2018-02-09 04:55:00	SPY	ETF	260.89	260.95	260.89	260.89	3083.0
2018-02-09 05:00:00	SPY	ETF	260.78	260.78	260.74	260.74	1556.0
2018-02-09 05:05:00	SPY	ETF	260.89	260.89	260.75	260.75	874.0
2018-02-09 05:10:00	SPY	ETF	260.55	260.55	260.42	260.49	2238.0
2018-02-09 05:15:00	SPY	ETF	260.41	260.63	260.41	260.63	1115.0
2018-02-09 05:20:00	SPY	ETF	260.7	260.9	260.7	260.85	2210.0
2018-02-09 05:25:00	SPY	ETF	260.9	260.99	260.9	260.99	2359.0
2018-02-09 05:30:00	SPY	ETF	260.99	261.08	260.99	261.08	1633.0
2018-02-09 05:35:00	SPY	ETF	261.2	261.23	261.17	261.19	2197.0
2018-02-09 05:40:00	SPY	ETF	261.2	261.2	261.0	261.0	3618.0
2018-02-09 05:45:00	SPY	ETF	260.92	260.92	260.84	260.85	4436.0
2018-02-09 05:50:00	SPY	ETF	260.85	260.85	260.7	260.73	6227.0
2018-02-09 05:55:00	SPY	ETF	260.9	260.9	260.9	260.9	101.0
2018-02-09 06:00:00	SPY	ETF	260.9	261.05	260.9	260.9	3539.0
2018-02-09 06:05:00	SPY	ETF	260.9	261.0	260.88	260.9	4160.0
2018-02-09 06:10:00	SPY	ETF	260.83	260.83	260.69	260.82	6824.0
2018-02-09 06:15:00	SPY	ETF	260.68	260.68	260.54	260.57	8597.0
2018-02-09 06:20:00	SPY	ETF	260.51	260.51	260.04	260.29	9116.0
2018-02-09 06:25:00	SPY	ETF	260.29	260.42	260.16	260.16	6849.0
2018-02-09 06:30:00	SPY	ETF	260.1	260.11	259.76	259.76	36799.0
2018-02-09 06:35:00	SPY	ETF	259.75	259.82	259.28	259.3	48863.0
2018-02-09 06:40:00	SPY	ETF	259.3	259.66	259.3	259.6	109673.0
2018-02-09 06:45:00	SPY	ETF	259.71	259.71	259.22	259.31	32278.0
2018-02-09 06:50:00	SPY	ETF	259.21	259.8	259.17	259.8	28645.0
2018-02-09 06:55:00	SPY	ETF	259.63	260.0	259.6	260.0	20537.0
2018-02-09 07:00:00	SPY	ETF	260.0	260.5	259.78	259.85	50983.0
2018-02-09 07:05:00	SPY	ETF	259.84	259.89	259.55	259.69	13498.0
2018-02-09 07:10:00	SPY	ETF	259.68	259.68	259.28	259.28	45780.0
2018-02-09 07:15:00	SPY	ETF	259.3	259.49	259.3	259.38	38235.0
2018-02-09 07:20:00	SPY	ETF	259.37	259.67	259.28	259.4	73754.0
2018-02-09 07:25:00	SPY	ETF	259.3	259.34	258.64	258.64	56259.0
2018-02-09 07:30:00	SPY	ETF	258.66	259.09	258.3	258.49	114547.0
2018-02-09 07:35:00	SPY	ETF	258.47	258.83	258.32	258.41	11477.0
2018-02-09 07:40:00	SPY	ETF	258.44	258.53	257.93	258.1	94102.0
2018-02-09 07:45:00	SPY	ETF	258.07	258.82	257.92	258.76	73575.0
2018-02-09 07:50:00	SPY	ETF	258.86	258.97	258.7	258.8	39886.0
2018-02-09 07:55:00	SPY	ETF	258.76	258.76	258.11	258.32	60582.0
2018-02-09 08:00:00	SPY	ETF	258.325	261.13	257.95	258.72	100796.0
2018-02-09 08:05:00	SPY	ETF	258.77	258.82	258.56	258.76	33294.0

> showing 50 of 71,690 rows — these rows as CSV

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