PREVIEW / etf_5min / 2018-09-19

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-09-19.parquet
  size:    1.3 MB
  rows:    57,523

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-09-19 04:00:00	SPY	ETF	290.89	290.94	290.89	290.94	654.0
2018-09-19 04:05:00	SPY	ETF	290.91	290.91	290.88	290.89	300.0
2018-09-19 04:10:00	SPY	ETF	291.04	291.04	291.04	291.04	800.0
2018-09-19 04:15:00	SPY	ETF	291.01	291.04	291.0	291.0	500.0
2018-09-19 04:20:00	SPY	ETF	291.04	291.04	291.04	291.04	2000.0
2018-09-19 04:25:00	SPY	ETF	290.9	290.9	290.9	290.9	100.0
2018-09-19 04:30:00	SPY	ETF	290.93	290.93	290.93	290.93	300.0
2018-09-19 04:35:00	SPY	ETF	290.8	290.8	290.8	290.8	200.0
2018-09-19 04:45:00	SPY	ETF	290.78	290.78	290.78	290.78	600.0
2018-09-19 04:55:00	SPY	ETF	290.83	290.83	290.83	290.83	500.0
2018-09-19 05:10:00	SPY	ETF	290.82	290.82	290.76	290.8	5500.0
2018-09-19 05:25:00	SPY	ETF	290.84	290.84	290.79	290.79	200.0
2018-09-19 05:30:00	SPY	ETF	290.84	290.84	290.84	290.84	100.0
2018-09-19 05:40:00	SPY	ETF	290.85	290.85	290.83	290.83	700.0
2018-09-19 06:00:00	SPY	ETF	290.81	290.82	290.81	290.82	1150.0
2018-09-19 06:05:00	SPY	ETF	290.79	290.79	290.78	290.78	1400.0
2018-09-19 06:15:00	SPY	ETF	290.76	290.76	290.76	290.76	200.0
2018-09-19 06:25:00	SPY	ETF	290.8	290.8	290.78	290.78	1100.0
2018-09-19 06:30:00	SPY	ETF	290.87	290.87	290.87	290.87	200.0
2018-09-19 06:35:00	SPY	ETF	290.89	290.89	290.89	290.89	1000.0
2018-09-19 06:45:00	SPY	ETF	290.86	290.86	290.86	290.86	400.0
2018-09-19 06:50:00	SPY	ETF	290.89	290.89	290.89	290.89	4000.0
2018-09-19 07:00:00	SPY	ETF	290.84	290.86	290.84	290.86	3690.0
2018-09-19 07:05:00	SPY	ETF	290.86	290.86	290.84	290.84	1200.0
2018-09-19 07:10:00	SPY	ETF	290.84	290.84	290.7	290.7	6126.0
2018-09-19 07:15:00	SPY	ETF	290.68	290.77	290.68	290.77	4100.0
2018-09-19 07:20:00	SPY	ETF	290.76	290.76	290.76	290.76	8220.0
2018-09-19 07:25:00	SPY	ETF	290.76	290.76	290.72	290.72	5247.0
2018-09-19 07:30:00	SPY	ETF	290.74	290.74	290.7	290.7	1886.0
2018-09-19 07:35:00	SPY	ETF	290.69	290.74	290.68	290.74	1399.0
2018-09-19 07:40:00	SPY	ETF	290.74	290.79	290.74	290.79	300.0
2018-09-19 07:45:00	SPY	ETF	290.75	290.75	290.7	290.7	2013.0
2018-09-19 07:50:00	SPY	ETF	290.72	290.72	290.68	290.69	1973.0
2018-09-19 07:55:00	SPY	ETF	290.66	290.66	290.63	290.64	5403.0
2018-09-19 08:00:00	SPY	ETF	290.71	291.1	290.6	290.62	19703.0
2018-09-19 08:05:00	SPY	ETF	290.6	290.6	290.45	290.46	38035.0
2018-09-19 08:10:00	SPY	ETF	290.47	290.49	290.45	290.46	8807.0
2018-09-19 08:15:00	SPY	ETF	290.45	290.54	290.38	290.54	16851.0
2018-09-19 08:20:00	SPY	ETF	290.52	290.61	290.52	290.61	25970.0
2018-09-19 08:25:00	SPY	ETF	290.56	290.58	290.55	290.56	49071.0
2018-09-19 08:30:00	SPY	ETF	290.59	290.59	290.56	290.56	21473.0
2018-09-19 08:35:00	SPY	ETF	290.54	290.56	290.53	290.56	46625.0
2018-09-19 08:40:00	SPY	ETF	290.55	290.56	290.53	290.53	27376.0
2018-09-19 08:45:00	SPY	ETF	290.51	290.61	290.51	290.6	20900.0
2018-09-19 08:50:00	SPY	ETF	290.61	290.74	290.61	290.68	22163.0
2018-09-19 08:55:00	SPY	ETF	290.65	290.72	290.58	290.69	20943.0
2018-09-19 09:00:00	SPY	ETF	290.69	290.69	290.6501	290.69	14304.0
2018-09-19 09:05:00	SPY	ETF	290.68	290.69	290.63	290.64	21242.0
2018-09-19 09:10:00	SPY	ETF	290.67	290.79	290.67	290.78	14116.0
2018-09-19 09:15:00	SPY	ETF	290.77	290.89	290.77	290.89	42631.0

> showing 50 of 57,523 rows — these rows as CSV

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