PREVIEW / etf_5min / 2013-09-23

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-09-23.parquet
  size:    974 KB
  rows:    40,783

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-09-23 04:10:00	SPY	ETF	171.04	171.05	171.04	171.05	500.0
2013-09-23 04:25:00	SPY	ETF	171.13	171.17	171.13	171.17	400.0
2013-09-23 04:35:00	SPY	ETF	171.1	171.1	171.1	171.1	700.0
2013-09-23 04:55:00	SPY	ETF	171.02	171.02	171.02	171.02	100.0
2013-09-23 05:00:00	SPY	ETF	170.99	170.99	170.95	170.97	1697.0
2013-09-23 05:05:00	SPY	ETF	170.99	170.99	170.95	170.95	9279.0
2013-09-23 05:10:00	SPY	ETF	170.95	170.97	170.95	170.97	10100.0
2013-09-23 05:15:00	SPY	ETF	170.99	171.0	170.99	171.0	500.0
2013-09-23 05:20:00	SPY	ETF	170.96	170.96	170.9	170.9	4100.0
2013-09-23 05:25:00	SPY	ETF	170.87	170.9	170.87	170.9	600.0
2013-09-23 05:35:00	SPY	ETF	170.87	170.87	170.87	170.87	300.0
2013-09-23 05:45:00	SPY	ETF	170.9	170.9	170.9	170.9	300.0
2013-09-23 05:50:00	SPY	ETF	170.93	170.94	170.93	170.94	5000.0
2013-09-23 05:55:00	SPY	ETF	170.9	170.9	170.9	170.9	500.0
2013-09-23 06:00:00	SPY	ETF	170.92	170.92	170.92	170.92	500.0
2013-09-23 06:05:00	SPY	ETF	170.92	170.92	170.92	170.92	1000.0
2013-09-23 06:10:00	SPY	ETF	170.93	170.95	170.93	170.95	1050.0
2013-09-23 06:15:00	SPY	ETF	170.96	170.96	170.96	170.96	200.0
2013-09-23 06:30:00	SPY	ETF	170.95	170.95	170.95	170.95	1850.0
2013-09-23 06:35:00	SPY	ETF	170.93	170.93	170.92	170.92	20000.0
2013-09-23 06:40:00	SPY	ETF	170.94	170.94	170.94	170.94	15000.0
2013-09-23 06:50:00	SPY	ETF	170.92	170.92	170.9	170.9	400.0
2013-09-23 06:55:00	SPY	ETF	170.9	170.9	170.9	170.9	600.0
2013-09-23 07:00:00	SPY	ETF	170.87	170.87	170.87	170.87	300.0
2013-09-23 07:05:00	SPY	ETF	170.85	170.86	170.85	170.86	700.0
2013-09-23 07:10:00	SPY	ETF	170.85	170.85	170.84	170.84	500.0
2013-09-23 07:15:00	SPY	ETF	170.82	170.83	170.77	170.83	2360.0
2013-09-23 07:20:00	SPY	ETF	170.83	170.83	170.74	170.74	20100.0
2013-09-23 07:25:00	SPY	ETF	170.72	170.72	170.55	170.59	28220.0
2013-09-23 07:30:00	SPY	ETF	170.6	170.63	170.54	170.54	35100.0
2013-09-23 07:35:00	SPY	ETF	170.55	170.6	170.54	170.6	12310.0
2013-09-23 07:40:00	SPY	ETF	170.61	170.61	170.6	170.61	52520.0
2013-09-23 07:45:00	SPY	ETF	170.6	170.6	170.53	170.55	60150.0
2013-09-23 07:50:00	SPY	ETF	170.56	170.57	170.48	170.49	14950.0
2013-09-23 07:55:00	SPY	ETF	170.48	170.51	170.28	170.32	74300.0
2013-09-23 08:00:00	SPY	ETF	170.29	171.05	170.25	170.32	102321.0
2013-09-23 08:05:00	SPY	ETF	170.28	170.88	170.28	170.36	77670.0
2013-09-23 08:10:00	SPY	ETF	170.33	170.39	170.3	170.3	45890.0
2013-09-23 08:15:00	SPY	ETF	170.33	170.36	170.33	170.36	53466.0
2013-09-23 08:20:00	SPY	ETF	170.39	170.39	170.36	170.39	65805.0
2013-09-23 08:25:00	SPY	ETF	170.39	170.39	170.365	170.39	60275.0
2013-09-23 08:30:00	SPY	ETF	170.4	170.48	170.37	170.42	303850.0
2013-09-23 08:35:00	SPY	ETF	170.4	170.42	170.36	170.37	97063.0
2013-09-23 08:40:00	SPY	ETF	170.38	170.39	170.335	170.37	90584.0
2013-09-23 08:45:00	SPY	ETF	170.37	170.37	170.22	170.33	146639.0
2013-09-23 08:50:00	SPY	ETF	170.32	170.42	170.32	170.42	60773.0
2013-09-23 08:55:00	SPY	ETF	170.43	170.43	170.4	170.41	25392.0
2013-09-23 09:00:00	SPY	ETF	170.42	170.46	170.31	170.31	150669.0
2013-09-23 09:05:00	SPY	ETF	170.31	170.34	170.27	170.3	98525.0
2013-09-23 09:10:00	SPY	ETF	170.31	170.31	170.17	170.23	200554.0

> showing 50 of 40,783 rows — these rows as CSV

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