PREVIEW / etf_5min / 2018-04-23

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-23.parquet
  size:    1.3 MB
  rows:    56,028

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-23 04:00:00	SPY	ETF	266.82	266.82	266.6	266.6	1588.0
2018-04-23 04:05:00	SPY	ETF	266.58	266.65	266.52	266.52	3500.0
2018-04-23 04:10:00	SPY	ETF	266.48	266.48	266.41	266.41	11400.0
2018-04-23 04:15:00	SPY	ETF	266.35	266.37	266.35	266.37	320.0
2018-04-23 04:25:00	SPY	ETF	266.28	266.39	266.28	266.39	600.0
2018-04-23 04:35:00	SPY	ETF	266.4	266.4	266.35	266.35	1187.0
2018-04-23 04:40:00	SPY	ETF	266.41	266.46	266.36	266.43	1385.0
2018-04-23 04:50:00	SPY	ETF	266.44	266.44	266.44	266.44	100.0
2018-04-23 04:55:00	SPY	ETF	266.43	266.44	266.43	266.44	1600.0
2018-04-23 05:00:00	SPY	ETF	266.48	266.48	266.48	266.48	150.0
2018-04-23 05:05:00	SPY	ETF	266.45	266.45	266.38	266.38	4100.0
2018-04-23 05:10:00	SPY	ETF	266.34	266.38	266.32	266.32	1005.0
2018-04-23 05:25:00	SPY	ETF	266.45	266.48	266.44	266.48	900.0
2018-04-23 05:35:00	SPY	ETF	266.38	266.41	266.29	266.29	2095.0
2018-04-23 05:40:00	SPY	ETF	266.36	266.36	266.33	266.33	3300.0
2018-04-23 05:45:00	SPY	ETF	266.4	266.4	266.4	266.4	471.0
2018-04-23 05:50:00	SPY	ETF	266.41	266.42	266.41	266.42	1500.0
2018-04-23 05:55:00	SPY	ETF	266.42	266.42	266.42	266.42	2100.0
2018-04-23 06:00:00	SPY	ETF	266.38	266.4	266.33	266.35	2200.0
2018-04-23 06:10:00	SPY	ETF	266.35	266.35	266.3	266.3	415.0
2018-04-23 06:15:00	SPY	ETF	266.49	266.49	266.48	266.48	200.0
2018-04-23 06:20:00	SPY	ETF	266.54	266.6	266.53	266.58	27303.0
2018-04-23 06:25:00	SPY	ETF	266.57	266.6	266.57	266.6	300.0
2018-04-23 06:30:00	SPY	ETF	266.65	266.68	266.65	266.68	1100.0
2018-04-23 06:35:00	SPY	ETF	266.65	266.7	266.65	266.7	19480.0
2018-04-23 06:40:00	SPY	ETF	266.69	266.74	266.65	266.65	25200.0
2018-04-23 06:45:00	SPY	ETF	266.81	266.81	266.81	266.81	4280.0
2018-04-23 06:50:00	SPY	ETF	266.78	266.82	266.78	266.82	1210.0
2018-04-23 06:55:00	SPY	ETF	266.72	266.76	266.72	266.74	3177.0
2018-04-23 07:00:00	SPY	ETF	266.78	266.82	266.72	266.82	51585.0
2018-04-23 07:05:00	SPY	ETF	266.82	266.85	266.75	266.8	19576.0
2018-04-23 07:10:00	SPY	ETF	266.79	266.88	266.77	266.77	14852.0
2018-04-23 07:15:00	SPY	ETF	266.8	266.81	266.75	266.75	5050.0
2018-04-23 07:20:00	SPY	ETF	266.76	266.76	266.66	266.66	4515.0
2018-04-23 07:25:00	SPY	ETF	266.66	266.73	266.66	266.73	24168.0
2018-04-23 07:30:00	SPY	ETF	266.72	266.86	266.72	266.81	5627.0
2018-04-23 07:35:00	SPY	ETF	266.81	266.84	266.77	266.84	3200.0
2018-04-23 07:40:00	SPY	ETF	266.84	266.84	266.8	266.8	19100.0
2018-04-23 07:45:00	SPY	ETF	266.82	266.88	266.75	266.88	10100.0
2018-04-23 07:50:00	SPY	ETF	266.88	267.04	266.85	266.98	13373.0
2018-04-23 07:55:00	SPY	ETF	267.0	267.0	266.99	266.99	5192.0
2018-04-23 08:00:00	SPY	ETF	266.78	267.56	266.6	266.84	35626.0
2018-04-23 08:05:00	SPY	ETF	267.15	267.23	267.13	267.17	8863.0
2018-04-23 08:10:00	SPY	ETF	267.16	267.3	267.14	267.25	29849.0
2018-04-23 08:15:00	SPY	ETF	267.25	267.25	267.16	267.17	38755.0
2018-04-23 08:20:00	SPY	ETF	267.18	267.18	267.09	267.09	91974.0
2018-04-23 08:25:00	SPY	ETF	267.11	267.3	267.11	267.26	11529.0
2018-04-23 08:30:00	SPY	ETF	267.28	267.37	267.28	267.34	31964.0
2018-04-23 08:35:00	SPY	ETF	267.36	267.39	267.36	267.36	12115.0
2018-04-23 08:40:00	SPY	ETF	267.34	267.4	267.3	267.3	8365.0

> showing 50 of 56,028 rows — these rows as CSV

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