PREVIEW / etf_5min / 2012-07-02

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-07-02.parquet
  size:    863 KB
  rows:    35,912

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-07-02 04:00:00	SPY	ETF	136.01	136.01	136.01	136.01	100.0
2012-07-02 04:10:00	SPY	ETF	136.36	136.36	136.36	136.36	5500.0
2012-07-02 04:35:00	SPY	ETF	136.66	136.66	136.64	136.64	650.0
2012-07-02 04:40:00	SPY	ETF	136.62	136.62	136.6	136.6	350.0
2012-07-02 04:45:00	SPY	ETF	136.66	136.71	136.66	136.71	300.0
2012-07-02 04:50:00	SPY	ETF	136.66	136.66	136.63	136.63	1080.0
2012-07-02 05:00:00	SPY	ETF	136.65	136.65	136.64	136.64	324.0
2012-07-02 05:15:00	SPY	ETF	136.6	136.6	136.6	136.6	600.0
2012-07-02 05:20:00	SPY	ETF	136.66	136.66	136.66	136.66	100.0
2012-07-02 05:25:00	SPY	ETF	136.51	136.53	136.51	136.51	1200.0
2012-07-02 05:30:00	SPY	ETF	136.48	136.48	136.4	136.4	11000.0
2012-07-02 05:35:00	SPY	ETF	136.44	136.47	136.44	136.47	650.0
2012-07-02 05:40:00	SPY	ETF	136.46	136.46	136.38	136.38	1800.0
2012-07-02 05:45:00	SPY	ETF	136.35	136.35	136.34	136.34	650.0
2012-07-02 05:50:00	SPY	ETF	136.38	136.38	136.36	136.36	4149.0
2012-07-02 05:55:00	SPY	ETF	136.33	136.33	136.31	136.33	950.0
2012-07-02 06:00:00	SPY	ETF	136.3	136.31	136.26	136.26	19647.0
2012-07-02 06:05:00	SPY	ETF	136.27	136.36	136.27	136.36	7649.0
2012-07-02 06:10:00	SPY	ETF	136.37	136.37	136.37	136.37	200.0
2012-07-02 06:15:00	SPY	ETF	136.37	136.37	136.3	136.3	1050.0
2012-07-02 06:20:00	SPY	ETF	136.31	136.31	136.26	136.26	2270.0
2012-07-02 06:25:00	SPY	ETF	136.29	136.29	136.27	136.27	200.0
2012-07-02 06:30:00	SPY	ETF	136.3	136.32	136.3	136.32	4900.0
2012-07-02 06:35:00	SPY	ETF	136.32	136.38	136.32	136.38	3270.0
2012-07-02 06:45:00	SPY	ETF	136.37	136.37	136.3	136.3	1800.0
2012-07-02 06:50:00	SPY	ETF	136.4	136.4	136.4	136.4	11088.0
2012-07-02 06:55:00	SPY	ETF	136.26	136.38	136.26	136.38	14412.0
2012-07-02 07:00:00	SPY	ETF	136.36	136.45	136.36	136.45	5801.0
2012-07-02 07:05:00	SPY	ETF	136.42	136.45	136.39	136.4	164649.0
2012-07-02 07:10:00	SPY	ETF	136.36	136.41	136.36	136.41	3500.0
2012-07-02 07:15:00	SPY	ETF	136.44	136.53	136.44	136.51	29618.0
2012-07-02 07:20:00	SPY	ETF	136.5	136.63	136.5	136.58	78730.0
2012-07-02 07:25:00	SPY	ETF	136.6	136.61	136.48	136.48	47834.0
2012-07-02 07:30:00	SPY	ETF	136.55	136.55	136.46	136.48	84226.0
2012-07-02 07:35:00	SPY	ETF	136.51	136.51	136.43	136.46	35800.0
2012-07-02 07:40:00	SPY	ETF	136.44	136.44	136.38	136.38	11100.0
2012-07-02 07:45:00	SPY	ETF	136.37	136.42	136.35	136.42	32750.0
2012-07-02 07:50:00	SPY	ETF	136.42	136.51	136.42	136.5	17250.0
2012-07-02 07:55:00	SPY	ETF	136.49	136.51	136.48	136.48	35870.0
2012-07-02 08:00:00	SPY	ETF	136.48	136.68	136.27	136.46	1674954.0
2012-07-02 08:05:00	SPY	ETF	136.4	136.42	136.35	136.35	10964.0
2012-07-02 08:10:00	SPY	ETF	136.36	136.37	136.35	136.37	31150.0
2012-07-02 08:15:00	SPY	ETF	136.35	136.35	136.23	136.26	110093.0
2012-07-02 08:20:00	SPY	ETF	136.26	136.28	136.13	136.19	86345.0
2012-07-02 08:25:00	SPY	ETF	136.19	136.26	136.1	136.25	81371.0
2012-07-02 08:30:00	SPY	ETF	136.25	136.28	136.2	136.25	78525.0
2012-07-02 08:35:00	SPY	ETF	136.25	136.3	136.2	136.26	101533.0
2012-07-02 08:40:00	SPY	ETF	136.27	136.34	136.26	136.34	45680.0
2012-07-02 08:45:00	SPY	ETF	136.33	136.38	136.3	136.33	88500.0
2012-07-02 08:50:00	SPY	ETF	136.33	136.38	136.32	136.35	463240.0

> showing 50 of 35,912 rows — these rows as CSV

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