PREVIEW / etf_5min / 2018-02-23

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-23.parquet
  size:    1.3 MB
  rows:    56,578

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-23 04:00:00	SPY	ETF	271.73	271.73	271.67	271.69	1100.0
2018-02-23 04:05:00	SPY	ETF	271.74	271.74	271.74	271.74	400.0
2018-02-23 04:15:00	SPY	ETF	271.68	271.68	271.62	271.67	2207.0
2018-02-23 04:20:00	SPY	ETF	271.62	271.67	271.62	271.67	720.0
2018-02-23 04:25:00	SPY	ETF	271.69	271.69	271.68	271.68	1300.0
2018-02-23 04:30:00	SPY	ETF	271.83	271.83	271.82	271.82	901.0
2018-02-23 04:35:00	SPY	ETF	271.85	271.85	271.85	271.85	131.0
2018-02-23 04:45:00	SPY	ETF	271.83	272.0	271.83	272.0	3250.0
2018-02-23 04:50:00	SPY	ETF	271.97	272.07	271.97	272.07	1635.0
2018-02-23 04:55:00	SPY	ETF	272.08	272.08	271.96	271.96	1198.0
2018-02-23 05:00:00	SPY	ETF	271.95	271.95	271.95	271.95	2400.0
2018-02-23 05:05:00	SPY	ETF	271.8	271.8	271.8	271.8	300.0
2018-02-23 05:10:00	SPY	ETF	271.87	271.87	271.87	271.87	1000.0
2018-02-23 05:20:00	SPY	ETF	271.68	271.68	271.63	271.63	2590.0
2018-02-23 05:25:00	SPY	ETF	271.62	271.62	271.51	271.51	500.0
2018-02-23 05:30:00	SPY	ETF	271.53	271.53	271.33	271.38	1838.0
2018-02-23 05:35:00	SPY	ETF	271.38	271.38	271.38	271.38	200.0
2018-02-23 05:40:00	SPY	ETF	271.38	271.38	271.3	271.3	5949.0
2018-02-23 05:45:00	SPY	ETF	271.37	271.38	271.37	271.38	200.0
2018-02-23 05:50:00	SPY	ETF	271.48	271.48	271.46	271.46	410.0
2018-02-23 05:55:00	SPY	ETF	271.51	271.51	271.49	271.49	420.0
2018-02-23 06:00:00	SPY	ETF	271.51	271.56	271.51	271.56	400.0
2018-02-23 06:05:00	SPY	ETF	271.61	271.61	271.57	271.58	500.0
2018-02-23 06:10:00	SPY	ETF	271.68	271.68	271.68	271.68	300.0
2018-02-23 06:20:00	SPY	ETF	271.57	271.74	271.57	271.74	2700.0
2018-02-23 06:25:00	SPY	ETF	271.72	271.82	271.72	271.82	9000.0
2018-02-23 06:30:00	SPY	ETF	271.76	271.77	271.73	271.73	5120.0
2018-02-23 06:35:00	SPY	ETF	271.75	271.75	271.75	271.75	2000.0
2018-02-23 06:40:00	SPY	ETF	271.85	271.91	271.82	271.91	2610.0
2018-02-23 06:45:00	SPY	ETF	271.88	271.98	271.88	271.98	4900.0
2018-02-23 06:50:00	SPY	ETF	271.93	271.93	271.92	271.92	1000.0
2018-02-23 06:55:00	SPY	ETF	271.86	272.06	271.86	272.04	10325.0
2018-02-23 07:00:00	SPY	ETF	272.04	272.25	272.04	272.17	26632.0
2018-02-23 07:05:00	SPY	ETF	272.17	272.17	272.03	272.03	3935.0
2018-02-23 07:10:00	SPY	ETF	272.04	272.3	272.04	272.3	8239.0
2018-02-23 07:15:00	SPY	ETF	272.29	272.29	272.2	272.2	12648.0
2018-02-23 07:20:00	SPY	ETF	272.24	272.34	272.24	272.34	4092.0
2018-02-23 07:25:00	SPY	ETF	272.29	272.3	272.25	272.25	10626.0
2018-02-23 07:30:00	SPY	ETF	272.23	272.25	272.22	272.25	36558.0
2018-02-23 07:35:00	SPY	ETF	272.24	272.34	272.24	272.34	28487.0
2018-02-23 07:40:00	SPY	ETF	272.24	272.29	272.23	272.26	17370.0
2018-02-23 07:45:00	SPY	ETF	272.22	272.23	272.16	272.2	22698.0
2018-02-23 07:50:00	SPY	ETF	272.2	272.2	272.03	272.05	11251.0
2018-02-23 07:55:00	SPY	ETF	272.06	272.07	271.95	271.95	41191.0
2018-02-23 08:00:00	SPY	ETF	271.99	272.44	271.89	272.08	29898.0
2018-02-23 08:05:00	SPY	ETF	272.14	272.25	272.12	272.12	24365.0
2018-02-23 08:10:00	SPY	ETF	272.1	272.34	272.1	272.25	19545.0
2018-02-23 08:15:00	SPY	ETF	272.21	272.3	272.21	272.3	16627.0
2018-02-23 08:20:00	SPY	ETF	272.32	272.33	272.15	272.15	33026.0
2018-02-23 08:25:00	SPY	ETF	272.15	272.18	272.0	272.02	27606.0

> showing 50 of 56,578 rows — these rows as CSV

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