PREVIEW / etf_5min / 2018-04-13

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-13.parquet
  size:    1.3 MB
  rows:    55,466

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-13 04:00:00	SPY	ETF	266.12	266.12	266.01	266.01	2060.0
2018-04-13 04:05:00	SPY	ETF	266.1	266.11	266.09	266.11	1900.0
2018-04-13 04:10:00	SPY	ETF	266.09	266.1	265.96	266.05	4857.0
2018-04-13 04:15:00	SPY	ETF	266.05	266.05	266.05	266.05	490.0
2018-04-13 04:20:00	SPY	ETF	266.02	266.05	266.02	266.05	2800.0
2018-04-13 04:25:00	SPY	ETF	266.03	266.06	266.03	266.05	1400.0
2018-04-13 04:30:00	SPY	ETF	266.08	266.08	266.03	266.04	800.0
2018-04-13 04:35:00	SPY	ETF	266.1	266.1	266.04	266.04	400.0
2018-04-13 04:40:00	SPY	ETF	266.05	266.05	266.02	266.02	500.0
2018-04-13 04:45:00	SPY	ETF	265.99	265.99	265.99	265.99	100.0
2018-04-13 04:50:00	SPY	ETF	266.01	266.04	265.99	266.04	950.0
2018-04-13 04:55:00	SPY	ETF	266.06	266.2	266.06	266.2	1125.0
2018-04-13 05:00:00	SPY	ETF	266.2	266.2	266.16	266.16	1000.0
2018-04-13 05:05:00	SPY	ETF	266.18	266.22	266.16	266.16	1804.0
2018-04-13 05:10:00	SPY	ETF	266.18	266.22	266.18	266.22	1400.0
2018-04-13 05:20:00	SPY	ETF	266.19	266.19	266.19	266.19	300.0
2018-04-13 05:25:00	SPY	ETF	266.16	266.16	266.16	266.16	200.0
2018-04-13 05:30:00	SPY	ETF	266.16	266.16	266.16	266.16	100.0
2018-04-13 05:40:00	SPY	ETF	266.14	266.2	266.14	266.2	700.0
2018-04-13 05:45:00	SPY	ETF	266.22	266.3	266.22	266.28	4100.0
2018-04-13 05:50:00	SPY	ETF	266.23	266.3	266.2	266.28	4000.0
2018-04-13 05:55:00	SPY	ETF	266.32	266.5	266.32	266.5	9550.0
2018-04-13 06:00:00	SPY	ETF	266.51	266.58	266.51	266.53	3545.0
2018-04-13 06:05:00	SPY	ETF	266.52	266.58	266.49	266.58	4480.0
2018-04-13 06:10:00	SPY	ETF	266.55	266.55	266.41	266.41	10125.0
2018-04-13 06:15:00	SPY	ETF	266.42	266.43	266.35	266.35	48060.0
2018-04-13 06:20:00	SPY	ETF	266.39	266.39	266.35	266.37	7730.0
2018-04-13 06:25:00	SPY	ETF	266.38	266.42	266.38	266.42	33730.0
2018-04-13 06:30:00	SPY	ETF	266.3	266.31	266.29	266.3	4550.0
2018-04-13 06:35:00	SPY	ETF	266.32	266.37	266.25	266.37	4650.0
2018-04-13 06:40:00	SPY	ETF	266.37	266.39	266.37	266.39	3850.0
2018-04-13 06:45:00	SPY	ETF	266.41	266.5	266.41	266.45	10210.0
2018-04-13 06:50:00	SPY	ETF	266.48	266.73	266.48	266.7	33753.0
2018-04-13 06:55:00	SPY	ETF	266.72	266.76	266.6	266.68	75205.0
2018-04-13 07:00:00	SPY	ETF	266.66	266.83	266.61	266.83	24139.0
2018-04-13 07:05:00	SPY	ETF	266.81	266.81	266.59	266.59	8088.0
2018-04-13 07:10:00	SPY	ETF	266.48	266.6	266.48	266.55	18448.0
2018-04-13 07:15:00	SPY	ETF	266.55	266.58	266.5	266.52	5026.0
2018-04-13 07:20:00	SPY	ETF	266.52	266.58	266.5	266.5	14862.0
2018-04-13 07:25:00	SPY	ETF	266.5	266.5	266.43	266.47	6248.0
2018-04-13 07:30:00	SPY	ETF	266.5	266.58	266.5	266.54	22251.0
2018-04-13 07:35:00	SPY	ETF	266.54	266.54	266.42	266.43	27372.0
2018-04-13 07:40:00	SPY	ETF	266.43	266.51	266.43	266.51	6651.0
2018-04-13 07:45:00	SPY	ETF	266.52	266.6	266.52	266.59	6864.0
2018-04-13 07:50:00	SPY	ETF	266.61	266.8	266.61	266.75	20232.0
2018-04-13 07:55:00	SPY	ETF	266.71	266.75	266.67	266.72	25978.0
2018-04-13 08:00:00	SPY	ETF	266.72	266.95	265.22	266.85	84931.0
2018-04-13 08:05:00	SPY	ETF	266.85	266.86	266.81	266.85	14366.0
2018-04-13 08:10:00	SPY	ETF	266.85	266.91	266.85	266.87	38253.0
2018-04-13 08:15:00	SPY	ETF	266.87	267.14	266.87	267.1	50800.0

> showing 50 of 55,466 rows — these rows as CSV

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