PREVIEW / etf_5min / 2018-10-09

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-09.parquet
  size:    1.4 MB
  rows:    59,692

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-10-09 04:00:00	SPY	ETF	287.59	287.6	287.59	287.6	1180.0
2018-10-09 04:05:00	SPY	ETF	287.58	287.58	287.56	287.56	2800.0
2018-10-09 04:10:00	SPY	ETF	287.52	287.53	287.4	287.4	7800.0
2018-10-09 04:15:00	SPY	ETF	287.42	287.42	287.42	287.42	2500.0
2018-10-09 04:20:00	SPY	ETF	287.45	287.48	287.45	287.48	3200.0
2018-10-09 04:25:00	SPY	ETF	287.4	287.4	287.4	287.4	15100.0
2018-10-09 04:30:00	SPY	ETF	287.35	287.35	287.35	287.35	300.0
2018-10-09 04:35:00	SPY	ETF	287.5	287.5	287.5	287.5	2300.0
2018-10-09 04:40:00	SPY	ETF	287.49	287.49	287.46	287.46	1100.0
2018-10-09 04:45:00	SPY	ETF	287.52	287.55	287.52	287.55	3000.0
2018-10-09 04:50:00	SPY	ETF	287.55	287.55	287.48	287.48	1700.0
2018-10-09 04:55:00	SPY	ETF	287.5	287.5	287.5	287.5	100.0
2018-10-09 05:00:00	SPY	ETF	287.5	287.5	287.44	287.44	800.0
2018-10-09 05:05:00	SPY	ETF	287.42	287.42	287.34	287.34	1230.0
2018-10-09 05:10:00	SPY	ETF	287.36	287.39	287.34	287.34	800.0
2018-10-09 05:15:00	SPY	ETF	287.34	287.34	287.31	287.31	3116.0
2018-10-09 05:20:00	SPY	ETF	287.31	287.36	287.31	287.36	700.0
2018-10-09 05:25:00	SPY	ETF	287.26	287.26	287.2	287.21	2250.0
2018-10-09 05:30:00	SPY	ETF	287.16	287.21	287.16	287.19	740.0
2018-10-09 05:35:00	SPY	ETF	287.09	287.12	287.09	287.12	1150.0
2018-10-09 05:40:00	SPY	ETF	287.16	287.16	286.99	286.99	3100.0
2018-10-09 05:45:00	SPY	ETF	287.01	287.09	287.01	287.09	1750.0
2018-10-09 05:50:00	SPY	ETF	287.04	287.15	287.04	287.14	6600.0
2018-10-09 05:55:00	SPY	ETF	286.94	286.94	286.86	286.86	14900.0
2018-10-09 06:00:00	SPY	ETF	286.84	286.84	286.68	286.68	3410.0
2018-10-09 06:05:00	SPY	ETF	286.82	286.87	286.79	286.87	2000.0
2018-10-09 06:10:00	SPY	ETF	286.84	286.99	286.83	286.92	16255.0
2018-10-09 06:20:00	SPY	ETF	286.93	286.96	286.93	286.93	700.0
2018-10-09 06:25:00	SPY	ETF	286.75	286.89	286.75	286.89	3950.0
2018-10-09 06:30:00	SPY	ETF	286.92	286.97	286.92	286.97	2500.0
2018-10-09 06:35:00	SPY	ETF	286.92	286.97	286.88	286.97	8800.0
2018-10-09 06:40:00	SPY	ETF	286.97	286.97	286.97	286.97	2500.0
2018-10-09 06:45:00	SPY	ETF	286.96	286.99	286.94	286.94	1200.0
2018-10-09 06:50:00	SPY	ETF	286.99	286.99	286.99	286.99	600.0
2018-10-09 06:55:00	SPY	ETF	287.13	287.17	287.09	287.09	4900.0
2018-10-09 07:00:00	SPY	ETF	287.17	287.18	287.1	287.14	8046.0
2018-10-09 07:05:00	SPY	ETF	287.12	287.16	287.12	287.16	11309.0
2018-10-09 07:10:00	SPY	ETF	287.0	287.05	286.92	286.92	55303.0
2018-10-09 07:15:00	SPY	ETF	286.92	286.92	286.62	286.62	17773.0
2018-10-09 07:20:00	SPY	ETF	286.61	286.65	286.49	286.58	43829.0
2018-10-09 07:25:00	SPY	ETF	286.61	286.81	286.55	286.67	32452.0
2018-10-09 07:30:00	SPY	ETF	286.7	286.75	286.5	286.54	16189.0
2018-10-09 07:35:00	SPY	ETF	286.63	286.63	286.53	286.53	18409.0
2018-10-09 07:40:00	SPY	ETF	286.52	286.68	286.45	286.49	74663.0
2018-10-09 07:45:00	SPY	ETF	286.51	286.65	286.51	286.65	22492.0
2018-10-09 07:50:00	SPY	ETF	286.62	286.62	286.4	286.48	53954.0
2018-10-09 07:55:00	SPY	ETF	286.42	286.46	286.34	286.38	34710.0
2018-10-09 08:00:00	SPY	ETF	286.6	287.93	286.38	286.66	92339.0
2018-10-09 08:05:00	SPY	ETF	286.66	286.78	286.65	286.71	50711.0
2018-10-09 08:10:00	SPY	ETF	286.77	286.77	286.66	286.7	8748.0

> showing 50 of 59,692 rows — these rows as CSV

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