PREVIEW / etf_5min / 2017-06-30

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-30.parquet
  size:    1.2 MB
  rows:    52,608

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
2017-06-30 04:00:00	SPY	ETF	241.72	241.72	241.72	241.72	1010.0
2017-06-30 04:30:00	SPY	ETF	241.6	241.6	241.6	241.6	100.0
2017-06-30 04:35:00	SPY	ETF	241.5	241.52	241.5	241.5	700.0
2017-06-30 04:45:00	SPY	ETF	241.64	241.64	241.64	241.64	400.0
2017-06-30 04:50:00	SPY	ETF	241.65	241.68	241.65	241.68	300.0
2017-06-30 04:55:00	SPY	ETF	241.79	241.79	241.79	241.79	100.0
2017-06-30 05:00:00	SPY	ETF	241.79	241.79	241.79	241.79	300.0
2017-06-30 05:10:00	SPY	ETF	241.79	241.8	241.79	241.8	14302.0
2017-06-30 05:15:00	SPY	ETF	241.9	241.9	241.9	241.9	10510.0
2017-06-30 05:20:00	SPY	ETF	241.95	241.95	241.95	241.95	3000.0
2017-06-30 05:25:00	SPY	ETF	241.9	241.95	241.9	241.94	7900.0
2017-06-30 05:30:00	SPY	ETF	241.97	241.98	241.97	241.98	6100.0
2017-06-30 05:35:00	SPY	ETF	241.98	242.04	241.98	242.04	4231.0
2017-06-30 05:40:00	SPY	ETF	242.1	242.1	242.07	242.1	4500.0
2017-06-30 05:45:00	SPY	ETF	242.05	242.05	242.05	242.05	300.0
2017-06-30 05:50:00	SPY	ETF	242.05	242.05	242.05	242.05	3800.0
2017-06-30 05:55:00	SPY	ETF	242.1	242.1	242.1	242.1	4035.0
2017-06-30 06:00:00	SPY	ETF	242.14	242.25	242.14	242.25	4732.0
2017-06-30 06:05:00	SPY	ETF	242.26	242.32	242.26	242.32	8323.0
2017-06-30 06:10:00	SPY	ETF	242.36	242.42	242.31	242.35	21821.0
2017-06-30 06:15:00	SPY	ETF	242.34	242.36	242.27	242.27	2488.0
2017-06-30 06:20:00	SPY	ETF	242.28	242.29	242.27	242.29	5000.0
2017-06-30 06:30:00	SPY	ETF	242.32	242.33	242.3	242.33	800.0
2017-06-30 06:35:00	SPY	ETF	242.3	242.3	242.27	242.27	1900.0
2017-06-30 06:40:00	SPY	ETF	242.33	242.33	242.3	242.3	2200.0
2017-06-30 06:45:00	SPY	ETF	242.31	242.31	242.31	242.31	1200.0
2017-06-30 06:50:00	SPY	ETF	242.31	242.31	242.25	242.3	1250.0
2017-06-30 06:55:00	SPY	ETF	242.28	242.3	242.28	242.3	5278.0
2017-06-30 07:00:00	SPY	ETF	242.28	242.34	242.27	242.32	31645.0
2017-06-30 07:05:00	SPY	ETF	242.31	242.35	242.29	242.35	14491.0
2017-06-30 07:10:00	SPY	ETF	242.35	242.36	242.32	242.35	39991.0
2017-06-30 07:15:00	SPY	ETF	242.36	242.37	242.29	242.35	42296.0
2017-06-30 07:20:00	SPY	ETF	242.35	242.4	242.35	242.35	35673.0
2017-06-30 07:25:00	SPY	ETF	242.31	242.33	242.29	242.3	7187.0
2017-06-30 07:30:00	SPY	ETF	242.28	242.34	242.27	242.34	9973.0
2017-06-30 07:35:00	SPY	ETF	242.33	242.33	242.26	242.26	28880.0
2017-06-30 07:40:00	SPY	ETF	242.27	242.27	242.23	242.23	14699.0
2017-06-30 07:45:00	SPY	ETF	242.24	242.27	242.23	242.25	18400.0
2017-06-30 07:50:00	SPY	ETF	242.25	242.27	242.25	242.27	1100.0
2017-06-30 07:55:00	SPY	ETF	242.27	242.3	242.24	242.3	13300.0
2017-06-30 08:00:00	SPY	ETF	242.34	242.37	242.15	242.15	33016.0
2017-06-30 08:05:00	SPY	ETF	242.18	242.24	242.16	242.24	24438.0
2017-06-30 08:10:00	SPY	ETF	242.22	242.22	242.14	242.14	30944.0
2017-06-30 08:15:00	SPY	ETF	242.14	242.17	242.13	242.15	72002.0
2017-06-30 08:20:00	SPY	ETF	242.13	242.16	242.06	242.09	63313.0
2017-06-30 08:25:00	SPY	ETF	242.07	242.12	242.06	242.12	14093.0
2017-06-30 08:30:00	SPY	ETF	242.11	242.2	242.11	242.18	46696.0
2017-06-30 08:35:00	SPY	ETF	242.18	242.18	242.02	242.05	113418.0
2017-06-30 08:40:00	SPY	ETF	242.05	242.1	242.01	242.04	88294.0
2017-06-30 08:45:00	SPY	ETF	242.04	242.1	242.04	242.08	49623.0

> showing 50 of 52,608 rows — these rows as CSV

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