PREVIEW / etf_5min / 2018-10-18

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-18.parquet
  size:    1.4 MB
  rows:    61,889

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-18 04:00:00	SPY	ETF	280.43	280.5	280.37	280.37	5142.0
2018-10-18 04:05:00	SPY	ETF	280.39	280.39	280.28	280.36	4200.0
2018-10-18 04:10:00	SPY	ETF	280.24	280.36	280.24	280.36	4800.0
2018-10-18 04:15:00	SPY	ETF	280.21	280.23	280.21	280.23	4002.0
2018-10-18 04:20:00	SPY	ETF	280.29	280.42	280.26	280.26	1940.0
2018-10-18 04:30:00	SPY	ETF	280.16	280.27	280.16	280.19	4100.0
2018-10-18 04:35:00	SPY	ETF	280.3	280.3	280.3	280.3	1800.0
2018-10-18 04:40:00	SPY	ETF	280.24	280.24	280.23	280.23	1300.0
2018-10-18 04:45:00	SPY	ETF	280.35	280.39	280.3	280.39	1800.0
2018-10-18 04:50:00	SPY	ETF	280.44	280.47	280.44	280.47	700.0
2018-10-18 04:55:00	SPY	ETF	280.35	280.35	280.35	280.35	456.0
2018-10-18 05:00:00	SPY	ETF	280.12	280.12	280.08	280.08	603.0
2018-10-18 05:05:00	SPY	ETF	280.05	280.05	280.05	280.05	100.0
2018-10-18 05:10:00	SPY	ETF	280.09	280.09	280.05	280.05	1652.0
2018-10-18 05:15:00	SPY	ETF	279.97	280.02	279.97	279.98	3906.0
2018-10-18 05:20:00	SPY	ETF	279.93	280.1	279.93	280.1	400.0
2018-10-18 05:25:00	SPY	ETF	280.13	280.13	280.13	280.13	1000.0
2018-10-18 05:30:00	SPY	ETF	280.15	280.15	279.99	279.99	1250.0
2018-10-18 05:35:00	SPY	ETF	279.86	279.86	279.84	279.84	11500.0
2018-10-18 05:40:00	SPY	ETF	279.9	279.9	279.87	279.87	508.0
2018-10-18 05:45:00	SPY	ETF	279.97	280.01	279.97	280.01	500.0
2018-10-18 05:50:00	SPY	ETF	280.1	280.32	280.1	280.32	6500.0
2018-10-18 05:55:00	SPY	ETF	280.39	280.39	280.32	280.33	2200.0
2018-10-18 06:00:00	SPY	ETF	280.31	280.31	280.31	280.31	250.0
2018-10-18 06:05:00	SPY	ETF	280.25	280.35	280.25	280.29	2130.0
2018-10-18 06:10:00	SPY	ETF	280.2	280.2	280.2	280.2	1000.0
2018-10-18 06:15:00	SPY	ETF	280.17	280.17	280.17	280.17	300.0
2018-10-18 06:20:00	SPY	ETF	280.23	280.23	280.23	280.23	100.0
2018-10-18 06:25:00	SPY	ETF	280.2	280.22	280.2	280.22	400.0
2018-10-18 06:30:00	SPY	ETF	280.2	280.2	280.05	280.05	1201.0
2018-10-18 06:35:00	SPY	ETF	280.0	280.0	279.92	279.92	37250.0
2018-10-18 06:40:00	SPY	ETF	279.94	280.07	279.92	280.04	9800.0
2018-10-18 06:45:00	SPY	ETF	279.98	279.98	279.98	279.98	150.0
2018-10-18 06:55:00	SPY	ETF	279.92	279.92	279.7	279.76	11950.0
2018-10-18 07:00:00	SPY	ETF	279.77	279.86	279.77	279.86	3682.0
2018-10-18 07:05:00	SPY	ETF	279.87	279.9	279.85	279.9	22700.0
2018-10-18 07:10:00	SPY	ETF	279.95	280.08	279.9	280.0	34318.0
2018-10-18 07:15:00	SPY	ETF	279.99	279.99	279.94	279.96	5400.0
2018-10-18 07:20:00	SPY	ETF	279.9	279.9	279.9	279.9	2700.0
2018-10-18 07:25:00	SPY	ETF	279.9	279.9	279.77	279.78	21362.0
2018-10-18 07:30:00	SPY	ETF	279.86	279.97	279.82	279.97	9591.0
2018-10-18 07:35:00	SPY	ETF	279.98	279.98	279.85	279.85	13344.0
2018-10-18 07:40:00	SPY	ETF	279.78	279.78	279.49	279.51	19800.0
2018-10-18 07:45:00	SPY	ETF	279.56	279.68	279.56	279.68	10476.0
2018-10-18 07:50:00	SPY	ETF	279.65	279.67	279.55	279.56	23418.0
2018-10-18 07:55:00	SPY	ETF	279.53	279.61	279.53	279.61	17422.0
2018-10-18 08:00:00	SPY	ETF	279.85	280.43	279.39	279.42	39719.0
2018-10-18 08:05:00	SPY	ETF	279.42	279.59	279.41	279.48	37371.0
2018-10-18 08:10:00	SPY	ETF	279.44	279.73	279.44	279.73	42424.0
2018-10-18 08:15:00	SPY	ETF	279.74	279.77	279.69	279.71	23412.0

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

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