PREVIEW / etf_5min / 2018-02-16

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-16.parquet
  size:    1.4 MB
  rows:    62,167

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-16 04:00:00	SPY	ETF	274.03	274.23	274.03	274.23	628.0
2018-02-16 04:05:00	SPY	ETF	274.2	274.2	274.17	274.18	910.0
2018-02-16 04:10:00	SPY	ETF	274.24	274.25	274.24	274.25	5221.0
2018-02-16 04:15:00	SPY	ETF	274.2	274.2	274.2	274.2	5000.0
2018-02-16 04:25:00	SPY	ETF	274.37	274.4	274.37	274.4	400.0
2018-02-16 04:30:00	SPY	ETF	274.37	274.49	274.37	274.49	14742.0
2018-02-16 04:35:00	SPY	ETF	274.53	274.53	274.5	274.5	1506.0
2018-02-16 04:40:00	SPY	ETF	274.5	274.51	274.38	274.49	6697.0
2018-02-16 04:45:00	SPY	ETF	274.49	274.49	274.49	274.49	200.0
2018-02-16 04:55:00	SPY	ETF	274.4	274.4	274.25	274.3	9200.0
2018-02-16 05:00:00	SPY	ETF	274.3	274.37	274.3	274.37	1871.0
2018-02-16 05:05:00	SPY	ETF	274.42	274.52	274.42	274.52	690.0
2018-02-16 05:10:00	SPY	ETF	274.44	274.44	274.4	274.42	1700.0
2018-02-16 05:15:00	SPY	ETF	274.37	274.47	274.37	274.47	4400.0
2018-02-16 05:20:00	SPY	ETF	274.44	274.44	274.32	274.38	9659.0
2018-02-16 05:25:00	SPY	ETF	274.35	274.39	274.32	274.32	900.0
2018-02-16 05:30:00	SPY	ETF	274.25	274.25	274.25	274.25	150.0
2018-02-16 05:35:00	SPY	ETF	274.17	274.17	274.1	274.1	3600.0
2018-02-16 05:40:00	SPY	ETF	274.11	274.11	273.81	273.81	10724.0
2018-02-16 05:45:00	SPY	ETF	273.91	273.97	273.75	273.89	3370.0
2018-02-16 05:50:00	SPY	ETF	273.87	273.99	273.8	273.99	1850.0
2018-02-16 05:55:00	SPY	ETF	273.94	273.94	273.94	273.94	100.0
2018-02-16 06:00:00	SPY	ETF	273.9	273.96	273.9	273.96	1100.0
2018-02-16 06:05:00	SPY	ETF	273.8	273.85	273.79	273.85	1100.0
2018-02-16 06:10:00	SPY	ETF	273.87	273.87	273.84	273.84	711.0
2018-02-16 06:20:00	SPY	ETF	273.98	273.98	273.98	273.98	500.0
2018-02-16 06:25:00	SPY	ETF	274.02	274.06	273.92	273.92	2449.0
2018-02-16 06:30:00	SPY	ETF	273.82	273.82	273.81	273.81	200.0
2018-02-16 06:35:00	SPY	ETF	273.82	273.87	273.54	273.65	4735.0
2018-02-16 06:40:00	SPY	ETF	273.6	273.69	273.58	273.69	3400.0
2018-02-16 06:45:00	SPY	ETF	273.66	273.74	273.66	273.74	850.0
2018-02-16 06:50:00	SPY	ETF	273.74	273.79	273.74	273.77	1590.0
2018-02-16 06:55:00	SPY	ETF	273.79	273.89	273.79	273.8	5700.0
2018-02-16 07:00:00	SPY	ETF	273.74	273.74	273.61	273.64	10189.0
2018-02-16 07:05:00	SPY	ETF	273.64	273.97	273.64	273.91	16170.0
2018-02-16 07:10:00	SPY	ETF	273.93	273.96	273.93	273.95	1725.0
2018-02-16 07:15:00	SPY	ETF	273.93	273.95	273.9	273.94	51517.0
2018-02-16 07:20:00	SPY	ETF	273.95	273.95	273.88	273.88	2810.0
2018-02-16 07:25:00	SPY	ETF	273.87	273.87	273.82	273.82	21645.0
2018-02-16 07:30:00	SPY	ETF	273.79	273.93	273.79	273.88	34759.0
2018-02-16 07:35:00	SPY	ETF	273.88	273.96	273.88	273.93	19638.0
2018-02-16 07:40:00	SPY	ETF	273.89	274.05	273.89	274.0	9280.0
2018-02-16 07:45:00	SPY	ETF	274.0	274.02	273.92	273.92	10423.0
2018-02-16 07:50:00	SPY	ETF	273.92	273.95	273.88	273.95	34329.0
2018-02-16 07:55:00	SPY	ETF	273.94	273.98	273.92	273.92	14793.0
2018-02-16 08:00:00	SPY	ETF	273.91	273.95	273.35	273.75	102067.0
2018-02-16 08:05:00	SPY	ETF	273.71	273.71	273.62	273.62	14989.0
2018-02-16 08:10:00	SPY	ETF	273.63	273.69	273.54	273.55	36940.0
2018-02-16 08:15:00	SPY	ETF	273.59	273.64	273.58	273.62	10956.0
2018-02-16 08:20:00	SPY	ETF	273.66	273.66	273.49	273.55	12375.0

> showing 50 of 62,167 rows — these rows as CSV

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