PREVIEW / etf_5min / 2018-05-22

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-22.parquet
  size:    1.3 MB
  rows:    56,038

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-05-22 04:00:00	SPY	ETF	273.7	273.72	273.7	273.72	4759.0
2018-05-22 04:05:00	SPY	ETF	273.72	273.79	273.72	273.75	5370.0
2018-05-22 04:10:00	SPY	ETF	273.78	273.78	273.78	273.78	100.0
2018-05-22 04:15:00	SPY	ETF	273.79	273.79	273.79	273.79	1850.0
2018-05-22 04:25:00	SPY	ETF	273.73	273.8	273.73	273.8	400.0
2018-05-22 04:30:00	SPY	ETF	273.77	273.77	273.77	273.77	138.0
2018-05-22 04:50:00	SPY	ETF	273.81	273.82	273.81	273.82	1200.0
2018-05-22 04:55:00	SPY	ETF	273.82	273.82	273.82	273.82	1500.0
2018-05-22 05:05:00	SPY	ETF	273.85	273.85	273.85	273.85	300.0
2018-05-22 05:15:00	SPY	ETF	273.87	273.87	273.86	273.86	650.0
2018-05-22 05:20:00	SPY	ETF	273.86	273.92	273.86	273.92	1300.0
2018-05-22 05:30:00	SPY	ETF	273.81	273.89	273.81	273.89	750.0
2018-05-22 05:35:00	SPY	ETF	273.88	273.94	273.88	273.94	600.0
2018-05-22 05:40:00	SPY	ETF	273.8	273.82	273.8	273.82	215.0
2018-05-22 05:50:00	SPY	ETF	273.86	273.86	273.86	273.86	400.0
2018-05-22 05:55:00	SPY	ETF	273.86	273.88	273.86	273.88	1000.0
2018-05-22 06:00:00	SPY	ETF	273.93	273.96	273.93	273.96	900.0
2018-05-22 06:05:00	SPY	ETF	273.96	273.96	273.96	273.96	1410.0
2018-05-22 06:10:00	SPY	ETF	273.99	273.99	273.96	273.96	1710.0
2018-05-22 06:15:00	SPY	ETF	273.96	273.96	273.96	273.96	295.0
2018-05-22 06:20:00	SPY	ETF	273.93	273.93	273.93	273.93	100.0
2018-05-22 06:25:00	SPY	ETF	273.9	273.9	273.9	273.9	300.0
2018-05-22 06:35:00	SPY	ETF	273.87	273.87	273.83	273.83	1300.0
2018-05-22 06:40:00	SPY	ETF	273.8	273.8	273.73	273.73	6800.0
2018-05-22 06:45:00	SPY	ETF	273.79	273.88	273.79	273.88	7260.0
2018-05-22 06:50:00	SPY	ETF	273.89	273.89	273.89	273.89	300.0
2018-05-22 06:55:00	SPY	ETF	273.85	273.86	273.85	273.86	400.0
2018-05-22 07:00:00	SPY	ETF	273.9	273.9	273.86	273.86	1990.0
2018-05-22 07:05:00	SPY	ETF	273.86	273.86	273.83	273.83	3850.0
2018-05-22 07:10:00	SPY	ETF	273.85	273.95	273.85	273.95	8226.0
2018-05-22 07:15:00	SPY	ETF	273.93	273.94	273.86	273.88	4350.0
2018-05-22 07:20:00	SPY	ETF	273.88	273.88	273.88	273.88	1215.0
2018-05-22 07:25:00	SPY	ETF	273.89	273.9	273.81	273.81	14107.0
2018-05-22 07:30:00	SPY	ETF	273.8	273.85	273.8	273.85	2315.0
2018-05-22 07:35:00	SPY	ETF	273.85	273.86	273.79	273.8	14626.0
2018-05-22 07:40:00	SPY	ETF	273.81	273.86	273.81	273.86	1100.0
2018-05-22 07:45:00	SPY	ETF	273.86	273.87	273.82	273.87	17371.0
2018-05-22 07:50:00	SPY	ETF	273.86	273.87	273.84	273.87	1005.0
2018-05-22 07:55:00	SPY	ETF	273.86	273.9	273.84	273.9	4776.0
2018-05-22 08:00:00	SPY	ETF	273.9	273.9	273.389	273.9	64951.0
2018-05-22 08:05:00	SPY	ETF	273.9	273.94	273.89	273.94	13545.0
2018-05-22 08:10:00	SPY	ETF	273.91	273.95	273.87	273.9	43945.0
2018-05-22 08:15:00	SPY	ETF	273.905	273.905	273.85	273.85	7105.0
2018-05-22 08:20:00	SPY	ETF	273.88	273.89	273.85	273.89	3867.0
2018-05-22 08:25:00	SPY	ETF	273.89	273.96	273.89	273.95	9108.0
2018-05-22 08:30:00	SPY	ETF	273.94	273.94	273.83	273.84	6436.0
2018-05-22 08:35:00	SPY	ETF	273.84	273.85	273.83	273.83	13218.0
2018-05-22 08:40:00	SPY	ETF	273.83	273.85	273.81	273.83	86351.0
2018-05-22 08:45:00	SPY	ETF	273.85	273.85	273.83	273.83	10410.0
2018-05-22 08:50:00	SPY	ETF	273.84	273.85	273.8	273.8	20612.0

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

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