PREVIEW / etf_5min / 2018-03-26

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-03-26.parquet
  size:    1.4 MB
  rows:    61,156

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-03-26 04:00:00	SPY	ETF	261.35	261.77	260.25	261.67	28660.0
2018-03-26 04:05:00	SPY	ETF	261.75	261.88	261.75	261.86	6001.0
2018-03-26 04:10:00	SPY	ETF	261.86	261.86	261.76	261.86	3400.0
2018-03-26 04:15:00	SPY	ETF	261.94	262.18	261.94	262.18	1284.0
2018-03-26 04:20:00	SPY	ETF	262.02	262.15	262.02	262.15	1300.0
2018-03-26 04:25:00	SPY	ETF	262.06	262.1	262.0	262.01	3984.0
2018-03-26 04:30:00	SPY	ETF	261.99	262.06	261.91	261.98	11140.0
2018-03-26 04:35:00	SPY	ETF	261.99	262.14	261.99	262.05	9625.0
2018-03-26 04:40:00	SPY	ETF	261.86	261.86	261.83	261.83	829.0
2018-03-26 04:45:00	SPY	ETF	261.8	261.83	261.73	261.73	4400.0
2018-03-26 04:50:00	SPY	ETF	261.8	261.84	261.68	261.74	2500.0
2018-03-26 04:55:00	SPY	ETF	261.74	261.74	261.7	261.7	1400.0
2018-03-26 05:00:00	SPY	ETF	261.63	261.67	261.58	261.58	2118.0
2018-03-26 05:05:00	SPY	ETF	261.61	261.7	261.54	261.54	810.0
2018-03-26 05:15:00	SPY	ETF	261.56	261.56	261.52	261.53	1900.0
2018-03-26 05:20:00	SPY	ETF	261.65	262.0	261.65	261.98	4315.0
2018-03-26 05:25:00	SPY	ETF	261.88	261.94	261.88	261.9	1900.0
2018-03-26 05:30:00	SPY	ETF	261.89	262.04	261.89	261.9	1400.0
2018-03-26 05:35:00	SPY	ETF	261.94	262.03	261.9	262.0	4000.0
2018-03-26 05:40:00	SPY	ETF	262.04	262.3	262.04	262.3	6175.0
2018-03-26 05:45:00	SPY	ETF	262.39	262.45	262.35	262.35	5750.0
2018-03-26 05:50:00	SPY	ETF	262.44	262.6	262.44	262.56	22607.0
2018-03-26 05:55:00	SPY	ETF	262.48	262.6	262.42	262.42	12865.0
2018-03-26 06:00:00	SPY	ETF	262.46	262.47	262.37	262.43	8350.0
2018-03-26 06:05:00	SPY	ETF	262.43	262.43	262.32	262.4	12300.0
2018-03-26 06:10:00	SPY	ETF	262.4	262.5	262.4	262.4	18270.0
2018-03-26 06:15:00	SPY	ETF	262.44	262.44	262.38	262.41	2380.0
2018-03-26 06:20:00	SPY	ETF	262.43	262.48	262.3	262.3	6291.0
2018-03-26 06:25:00	SPY	ETF	262.3	262.3	262.23	262.26	8290.0
2018-03-26 06:30:00	SPY	ETF	262.25	262.25	262.01	262.01	8517.0
2018-03-26 06:35:00	SPY	ETF	261.99	262.09	261.92	262.02	26515.0
2018-03-26 06:40:00	SPY	ETF	261.98	262.01	261.94	261.98	9688.0
2018-03-26 06:45:00	SPY	ETF	261.96	261.96	261.88	261.88	6875.0
2018-03-26 06:50:00	SPY	ETF	261.95	262.18	261.95	262.17	66668.0
2018-03-26 06:55:00	SPY	ETF	262.21	262.33	262.17	262.2	17969.0
2018-03-26 07:00:00	SPY	ETF	262.22	262.26	262.0	262.17	56316.0
2018-03-26 07:05:00	SPY	ETF	262.18	262.4	262.06	262.4	29436.0
2018-03-26 07:10:00	SPY	ETF	262.45	262.56	262.36	262.49	41700.0
2018-03-26 07:15:00	SPY	ETF	262.49	262.75	262.43	262.63	60406.0
2018-03-26 07:20:00	SPY	ETF	262.55	262.58	262.38	262.45	97855.0
2018-03-26 07:25:00	SPY	ETF	262.4	262.41	262.13	262.13	32513.0
2018-03-26 07:30:00	SPY	ETF	262.15	262.2	262.06	262.2	45069.0
2018-03-26 07:35:00	SPY	ETF	262.17	262.17	262.01	262.01	35853.0
2018-03-26 07:40:00	SPY	ETF	262.01	262.01	261.87	261.93	51896.0
2018-03-26 07:45:00	SPY	ETF	261.94	262.13	261.94	262.03	28741.0
2018-03-26 07:50:00	SPY	ETF	261.94	262.1	261.94	262.05	14210.0
2018-03-26 07:55:00	SPY	ETF	262.05	262.19	262.0	262.12	25316.0
2018-03-26 08:00:00	SPY	ETF	262.15	262.62	261.95	262.17	152286.0
2018-03-26 08:05:00	SPY	ETF	262.11	262.5	262.11	262.5	50976.0
2018-03-26 08:10:00	SPY	ETF	262.5	262.7	262.49	262.65	73046.0

> showing 50 of 61,156 rows — these rows as CSV

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