PREVIEW / etf_5min / 2013-10-22

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-10-22.parquet
  size:    1.0 MB
  rows:    44,507

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
2013-10-22 04:00:00	SPY	ETF	174.27	174.27	174.27	174.27	138.0
2013-10-22 04:05:00	SPY	ETF	174.28	174.28	174.28	174.28	300.0
2013-10-22 04:15:00	SPY	ETF	174.29	174.31	174.26	174.26	500.0
2013-10-22 04:20:00	SPY	ETF	174.28	174.28	174.28	174.28	100.0
2013-10-22 04:30:00	SPY	ETF	174.26	174.28	174.26	174.28	200.0
2013-10-22 04:35:00	SPY	ETF	174.26	174.26	174.22	174.22	300.0
2013-10-22 04:40:00	SPY	ETF	174.2	174.2	174.2	174.2	500.0
2013-10-22 04:45:00	SPY	ETF	174.22	174.24	174.22	174.24	542.0
2013-10-22 04:55:00	SPY	ETF	174.26	174.28	174.26	174.27	720.0
2013-10-22 05:00:00	SPY	ETF	174.26	174.26	174.26	174.26	100.0
2013-10-22 05:10:00	SPY	ETF	174.24	174.24	174.24	174.24	400.0
2013-10-22 05:35:00	SPY	ETF	174.25	174.25	174.25	174.25	10163.0
2013-10-22 05:45:00	SPY	ETF	174.22	174.22	174.21	174.21	500.0
2013-10-22 06:05:00	SPY	ETF	174.24	174.24	174.22	174.22	10587.0
2013-10-22 06:10:00	SPY	ETF	174.2	174.22	174.2	174.22	5500.0
2013-10-22 06:15:00	SPY	ETF	174.24	174.26	174.24	174.26	500.0
2013-10-22 06:20:00	SPY	ETF	174.23	174.23	174.23	174.23	600.0
2013-10-22 06:25:00	SPY	ETF	174.23	174.23	174.23	174.23	400.0
2013-10-22 06:35:00	SPY	ETF	174.22	174.22	174.2	174.2	900.0
2013-10-22 06:40:00	SPY	ETF	174.22	174.22	174.22	174.22	100.0
2013-10-22 06:45:00	SPY	ETF	174.19	174.19	174.18	174.18	3600.0
2013-10-22 06:50:00	SPY	ETF	174.21	174.22	174.2	174.21	2200.0
2013-10-22 06:55:00	SPY	ETF	174.21	174.24	174.21	174.24	1400.0
2013-10-22 07:00:00	SPY	ETF	174.23	174.27	174.21	174.21	15000.0
2013-10-22 07:05:00	SPY	ETF	174.21	174.28	174.21	174.27	2700.0
2013-10-22 07:10:00	SPY	ETF	174.28	174.28	174.26	174.26	9300.0
2013-10-22 07:15:00	SPY	ETF	174.29	174.3	174.27	174.28	17300.0
2013-10-22 07:20:00	SPY	ETF	174.27	174.27	174.27	174.27	1000.0
2013-10-22 07:25:00	SPY	ETF	174.29	174.34	174.28	174.34	19257.0
2013-10-22 07:30:00	SPY	ETF	174.34	174.37	174.34	174.37	13500.0
2013-10-22 07:35:00	SPY	ETF	174.37	174.4	174.36	174.39	7718.0
2013-10-22 07:40:00	SPY	ETF	174.39	174.39	174.36	174.38	13100.0
2013-10-22 07:45:00	SPY	ETF	174.38	174.38	174.31	174.33	3200.0
2013-10-22 07:50:00	SPY	ETF	174.34	174.36	174.31	174.34	7400.0
2013-10-22 07:55:00	SPY	ETF	174.35	174.35	174.28	174.3	5900.0
2013-10-22 08:00:00	SPY	ETF	174.31	174.44	174.3	174.44	19220.0
2013-10-22 08:05:00	SPY	ETF	174.44	174.44	174.4	174.43	7290.0
2013-10-22 08:10:00	SPY	ETF	174.43	174.56	174.41	174.51	68115.0
2013-10-22 08:15:00	SPY	ETF	174.51	174.68	174.48	174.6	37117.0
2013-10-22 08:20:00	SPY	ETF	174.6	174.6	174.5	174.57	54104.0
2013-10-22 08:25:00	SPY	ETF	174.59	174.61	174.5	174.57	62960.0
2013-10-22 08:30:00	SPY	ETF	174.56	175.0	174.32	174.74	1176924.0
2013-10-22 08:35:00	SPY	ETF	174.74	174.96	174.72	174.92	416868.0
2013-10-22 08:40:00	SPY	ETF	174.91	174.91	174.76	174.83	120418.0
2013-10-22 08:45:00	SPY	ETF	174.84	174.91	174.8	174.9	128788.0
2013-10-22 08:50:00	SPY	ETF	174.91	174.92	174.74	174.76	98296.0
2013-10-22 08:55:00	SPY	ETF	174.77	174.8	174.72	174.78	119247.0
2013-10-22 09:00:00	SPY	ETF	174.78	174.94	174.78	174.88	107134.0
2013-10-22 09:05:00	SPY	ETF	174.87	174.96	174.84	174.96	100660.0
2013-10-22 09:10:00	SPY	ETF	174.94	174.96	174.85	174.87	44679.0

> showing 50 of 44,507 rows — these rows as CSV

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