PREVIEW / etf_5min / 2012-08-24

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-08-24.parquet
  size:    823 KB
  rows:    34,019

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
2012-08-24 04:00:00	SPY	ETF	140.38	140.6	140.38	140.6	600.0
2012-08-24 04:20:00	SPY	ETF	140.59	140.59	140.59	140.59	200.0
2012-08-24 04:30:00	SPY	ETF	140.5	140.5	140.5	140.5	100.0
2012-08-24 05:10:00	SPY	ETF	140.71	140.71	140.71	140.71	200.0
2012-08-24 05:55:00	SPY	ETF	140.66	140.66	140.66	140.66	950.0
2012-08-24 06:10:00	SPY	ETF	140.64	140.64	140.64	140.64	200.0
2012-08-24 06:25:00	SPY	ETF	140.55	140.55	140.55	140.55	250.0
2012-08-24 06:30:00	SPY	ETF	140.54	140.54	140.54	140.54	100.0
2012-08-24 06:45:00	SPY	ETF	140.53	140.53	140.53	140.53	100.0
2012-08-24 06:50:00	SPY	ETF	140.53	140.53	140.48	140.48	625.0
2012-08-24 06:55:00	SPY	ETF	140.51	140.54	140.51	140.54	600.0
2012-08-24 07:00:00	SPY	ETF	140.5	140.52	140.47	140.48	1795.0
2012-08-24 07:05:00	SPY	ETF	140.5	140.5	140.48	140.48	10800.0
2012-08-24 07:10:00	SPY	ETF	140.54	140.54	140.54	140.54	300.0
2012-08-24 07:15:00	SPY	ETF	140.59	140.59	140.5	140.5	3300.0
2012-08-24 07:20:00	SPY	ETF	140.49	140.49	140.41	140.43	4825.0
2012-08-24 07:25:00	SPY	ETF	140.41	140.42	140.27	140.33	14193.0
2012-08-24 07:30:00	SPY	ETF	140.31	140.35	140.3	140.34	121700.0
2012-08-24 07:35:00	SPY	ETF	140.37	140.38	140.35	140.38	4900.0
2012-08-24 07:40:00	SPY	ETF	140.4	140.4	140.38	140.39	5150.0
2012-08-24 07:45:00	SPY	ETF	140.39	140.42	140.39	140.41	6200.0
2012-08-24 07:50:00	SPY	ETF	140.4	140.41	140.36	140.39	23600.0
2012-08-24 07:55:00	SPY	ETF	140.4	140.4	140.38	140.39	62500.0
2012-08-24 08:00:00	SPY	ETF	140.41	140.43	140.37	140.43	18510.0
2012-08-24 08:05:00	SPY	ETF	140.43	140.44	140.4	140.42	10970.0
2012-08-24 08:10:00	SPY	ETF	140.42	140.42	140.36	140.4	5587.0
2012-08-24 08:15:00	SPY	ETF	140.43	140.49	140.41	140.49	62899.0
2012-08-24 08:20:00	SPY	ETF	140.5	140.52	140.48	140.5	23100.0
2012-08-24 08:25:00	SPY	ETF	140.52	140.6	140.52	140.53	183373.0
2012-08-24 08:30:00	SPY	ETF	140.5	140.57	140.43	140.47	307027.0
2012-08-24 08:35:00	SPY	ETF	140.47	140.5	140.33	140.35	109895.0
2012-08-24 08:40:00	SPY	ETF	140.34	140.36	140.24	140.32	141915.0
2012-08-24 08:45:00	SPY	ETF	140.3	140.36	140.18	140.19	221447.0
2012-08-24 08:50:00	SPY	ETF	140.18	140.25	140.17	140.19	278457.0
2012-08-24 08:55:00	SPY	ETF	140.2	140.26	140.19	140.24	35653.0
2012-08-24 09:00:00	SPY	ETF	140.24	140.29	140.24	140.28	64777.0
2012-08-24 09:05:00	SPY	ETF	140.31	140.35	140.3	140.34	127360.0
2012-08-24 09:10:00	SPY	ETF	140.34	140.4	140.34	140.39	61289.0
2012-08-24 09:15:00	SPY	ETF	140.39	140.49	140.37	140.43	69470.0
2012-08-24 09:20:00	SPY	ETF	140.42	140.495	140.35	140.35	62044.0
2012-08-24 09:25:00	SPY	ETF	140.36	140.36	140.27	140.3	189883.0
2012-08-24 09:30:00	SPY	ETF	140.31	140.46	140.26	140.4	1962903.0
2012-08-24 09:35:00	SPY	ETF	140.4	140.49	140.32	140.325	1492632.0
2012-08-24 09:40:00	SPY	ETF	140.33	140.41	140.3	140.32	1598205.0
2012-08-24 09:45:00	SPY	ETF	140.33	140.45	140.3	140.43	1513637.0
2012-08-24 09:50:00	SPY	ETF	140.43	140.44	140.32	140.38	1005157.0
2012-08-24 09:55:00	SPY	ETF	140.37	140.4	140.22	140.2699	1575362.0
2012-08-24 10:00:00	SPY	ETF	140.261	140.43	140.23	140.37	2264198.0
2012-08-24 10:05:00	SPY	ETF	140.38	140.46	140.34	140.42	1099041.0
2012-08-24 10:10:00	SPY	ETF	140.43	140.57	140.4	140.48	1302914.0

> showing 50 of 34,019 rows — these rows as CSV

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