PREVIEW / etf_5min / 2018-04-25

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-25.parquet
  size:    1.3 MB
  rows:    57,595

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-04-25 04:00:00	SPY	ETF	262.84	262.84	262.78	262.83	4126.0
2018-04-25 04:10:00	SPY	ETF	262.64	262.67	262.6	262.6	2510.0
2018-04-25 04:15:00	SPY	ETF	262.57	262.57	262.57	262.57	2015.0
2018-04-25 04:20:00	SPY	ETF	262.5	262.54	262.47	262.47	916.0
2018-04-25 04:25:00	SPY	ETF	262.52	262.52	262.52	262.52	100.0
2018-04-25 04:30:00	SPY	ETF	262.45	262.45	262.29	262.29	550.0
2018-04-25 04:35:00	SPY	ETF	262.2	262.2	261.99	262.12	8507.0
2018-04-25 04:45:00	SPY	ETF	262.06	262.07	261.98	261.99	2205.0
2018-04-25 04:50:00	SPY	ETF	262.07	262.12	261.98	262.12	4530.0
2018-04-25 04:55:00	SPY	ETF	262.17	262.2	262.11	262.11	3100.0
2018-04-25 05:00:00	SPY	ETF	262.22	262.22	262.2	262.2	281.0
2018-04-25 05:05:00	SPY	ETF	262.28	262.28	262.23	262.23	500.0
2018-04-25 05:10:00	SPY	ETF	262.24	262.24	262.21	262.21	1000.0
2018-04-25 05:15:00	SPY	ETF	262.05	262.05	261.88	261.97	1402.0
2018-04-25 05:20:00	SPY	ETF	261.91	261.91	261.81	261.81	2530.0
2018-04-25 05:25:00	SPY	ETF	261.92	262.2	261.92	262.2	3050.0
2018-04-25 05:30:00	SPY	ETF	262.18	262.2	262.18	262.2	550.0
2018-04-25 05:35:00	SPY	ETF	262.23	262.3	262.23	262.25	5205.0
2018-04-25 05:40:00	SPY	ETF	262.25	262.25	262.23	262.23	800.0
2018-04-25 05:45:00	SPY	ETF	262.32	262.32	262.18	262.18	1500.0
2018-04-25 05:50:00	SPY	ETF	262.19	262.19	262.19	262.19	1000.0
2018-04-25 05:55:00	SPY	ETF	262.39	262.44	262.39	262.44	240.0
2018-04-25 06:00:00	SPY	ETF	262.51	262.62	262.51	262.62	750.0
2018-04-25 06:05:00	SPY	ETF	262.59	262.6	262.56	262.6	980.0
2018-04-25 06:10:00	SPY	ETF	262.57	262.58	262.57	262.58	2500.0
2018-04-25 06:15:00	SPY	ETF	262.56	262.56	262.5	262.5	12600.0
2018-04-25 06:20:00	SPY	ETF	262.48	262.61	262.48	262.61	1806.0
2018-04-25 06:25:00	SPY	ETF	262.57	262.58	262.57	262.58	700.0
2018-04-25 06:30:00	SPY	ETF	262.52	262.52	262.48	262.48	20500.0
2018-04-25 06:35:00	SPY	ETF	262.52	262.52	262.4	262.42	26405.0
2018-04-25 06:40:00	SPY	ETF	262.46	262.49	262.42	262.45	11600.0
2018-04-25 06:45:00	SPY	ETF	262.48	262.5	262.42	262.5	2200.0
2018-04-25 06:50:00	SPY	ETF	262.43	262.46	262.25	262.28	16810.0
2018-04-25 06:55:00	SPY	ETF	262.28	262.28	261.82	261.86	23685.0
2018-04-25 07:00:00	SPY	ETF	261.79	261.9	261.75	261.75	73264.0
2018-04-25 07:05:00	SPY	ETF	261.78	261.94	261.78	261.88	18189.0
2018-04-25 07:10:00	SPY	ETF	261.98	262.02	261.93	262.0	10445.0
2018-04-25 07:15:00	SPY	ETF	262.04	262.15	261.92	261.95	16585.0
2018-04-25 07:20:00	SPY	ETF	262.01	262.01	261.82	261.83	2730.0
2018-04-25 07:25:00	SPY	ETF	261.86	261.86	261.55	261.65	32371.0
2018-04-25 07:30:00	SPY	ETF	261.79	262.0	261.74	261.91	56168.0
2018-04-25 07:35:00	SPY	ETF	261.91	262.02	261.71	262.02	70465.0
2018-04-25 07:40:00	SPY	ETF	262.01	262.22	261.97	262.16	57390.0
2018-04-25 07:45:00	SPY	ETF	262.13	262.15	262.02	262.15	13105.0
2018-04-25 07:50:00	SPY	ETF	262.17	262.43	262.17	262.42	37678.0
2018-04-25 07:55:00	SPY	ETF	262.35	262.52	262.32	262.52	26286.0
2018-04-25 08:00:00	SPY	ETF	262.5	263.27	261.63	262.4	40510.0
2018-04-25 08:05:00	SPY	ETF	262.38	262.43	262.32	262.34	9336.0
2018-04-25 08:10:00	SPY	ETF	262.37	262.46	262.32	262.46	11646.0
2018-04-25 08:15:00	SPY	ETF	262.46	262.65	262.43	262.65	32199.0

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

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