PREVIEW / etf_5min / 2018-05-25

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-25.parquet
  size:    1.2 MB
  rows:    54,198

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-25 04:05:00	SPY	ETF	273.2	273.3	273.2	273.3	1612.0
2018-05-25 04:10:00	SPY	ETF	273.24	273.24	273.24	273.24	5000.0
2018-05-25 04:15:00	SPY	ETF	273.3	273.3	273.3	273.3	300.0
2018-05-25 04:20:00	SPY	ETF	273.37	273.43	273.36	273.43	5350.0
2018-05-25 04:25:00	SPY	ETF	273.44	273.46	273.44	273.46	3265.0
2018-05-25 04:30:00	SPY	ETF	273.5	273.59	273.5	273.54	5902.0
2018-05-25 04:35:00	SPY	ETF	273.56	273.56	273.56	273.56	300.0
2018-05-25 04:40:00	SPY	ETF	273.44	273.49	273.44	273.46	700.0
2018-05-25 04:45:00	SPY	ETF	273.51	273.56	273.51	273.56	400.0
2018-05-25 04:50:00	SPY	ETF	273.61	273.61	273.61	273.61	300.0
2018-05-25 04:55:00	SPY	ETF	273.61	273.61	273.61	273.61	300.0
2018-05-25 05:00:00	SPY	ETF	273.68	273.69	273.68	273.68	1702.0
2018-05-25 05:05:00	SPY	ETF	273.54	273.54	273.54	273.54	2040.0
2018-05-25 05:15:00	SPY	ETF	273.59	273.59	273.56	273.56	726.0
2018-05-25 05:25:00	SPY	ETF	273.5	273.51	273.5	273.51	200.0
2018-05-25 05:30:00	SPY	ETF	273.54	273.54	273.44	273.46	3020.0
2018-05-25 05:35:00	SPY	ETF	273.44	273.44	273.41	273.41	400.0
2018-05-25 05:45:00	SPY	ETF	273.55	273.55	273.55	273.55	100.0
2018-05-25 05:50:00	SPY	ETF	273.57	273.57	273.57	273.57	300.0
2018-05-25 05:55:00	SPY	ETF	273.57	273.57	273.51	273.51	2350.0
2018-05-25 06:00:00	SPY	ETF	273.46	273.46	273.46	273.46	100.0
2018-05-25 06:05:00	SPY	ETF	273.42	273.46	273.42	273.46	1802.0
2018-05-25 06:10:00	SPY	ETF	273.49	273.51	273.41	273.42	2800.0
2018-05-25 06:15:00	SPY	ETF	273.4	273.41	273.33	273.34	6402.0
2018-05-25 06:20:00	SPY	ETF	273.41	273.41	273.39	273.39	900.0
2018-05-25 06:25:00	SPY	ETF	273.34	273.54	273.31	273.54	8105.0
2018-05-25 06:30:00	SPY	ETF	273.57	273.61	273.57	273.57	929.0
2018-05-25 06:35:00	SPY	ETF	273.59	273.59	273.57	273.59	600.0
2018-05-25 06:40:00	SPY	ETF	273.59	273.61	273.59	273.61	25300.0
2018-05-25 06:45:00	SPY	ETF	273.58	273.58	273.58	273.58	300.0
2018-05-25 06:50:00	SPY	ETF	273.57	273.57	273.45	273.45	1700.0
2018-05-25 06:55:00	SPY	ETF	273.46	273.46	273.45	273.45	1400.0
2018-05-25 07:00:00	SPY	ETF	273.42	273.47	273.4	273.45	4106.0
2018-05-25 07:05:00	SPY	ETF	273.44	273.52	273.35	273.35	6137.0
2018-05-25 07:10:00	SPY	ETF	273.34	273.35	273.15	273.19	18832.0
2018-05-25 07:15:00	SPY	ETF	273.2	273.21	273.04	273.04	22187.0
2018-05-25 07:20:00	SPY	ETF	273.03	273.03	272.9	272.93	19040.0
2018-05-25 07:25:00	SPY	ETF	272.9	272.91	272.84	272.91	28050.0
2018-05-25 07:30:00	SPY	ETF	272.91	272.93	272.82	272.9	15631.0
2018-05-25 07:35:00	SPY	ETF	272.9	272.9	272.8	272.8	9414.0
2018-05-25 07:40:00	SPY	ETF	272.75	272.78	272.67	272.73	27474.0
2018-05-25 07:45:00	SPY	ETF	272.76	272.76	272.63	272.66	30865.0
2018-05-25 07:50:00	SPY	ETF	272.67	272.67	272.51	272.56	15506.0
2018-05-25 07:55:00	SPY	ETF	272.6	272.6	272.49	272.54	8413.0
2018-05-25 08:00:00	SPY	ETF	272.54	273.65	272.44	272.5	42762.0
2018-05-25 08:05:00	SPY	ETF	272.51	272.52	272.4001	272.43	13910.0
2018-05-25 08:10:00	SPY	ETF	272.43	272.56	272.31	272.54	214358.0
2018-05-25 08:15:00	SPY	ETF	272.54	272.55	272.25	272.25	46630.0
2018-05-25 08:20:00	SPY	ETF	272.28	272.34	272.18	272.32	39767.0
2018-05-25 08:25:00	SPY	ETF	272.3	272.39	272.23	272.3	50576.0

> showing 50 of 54,198 rows — these rows as CSV

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