PREVIEW / etf_5min / 2012-11-07

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-11-07.parquet
  size:    996 KB
  rows:    41,429

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-11-07 04:00:00	SPY	ETF	143.36	143.44	143.36	143.44	25500.0
2012-11-07 04:05:00	SPY	ETF	143.39	143.39	143.39	143.39	1024.0
2012-11-07 04:10:00	SPY	ETF	143.44	143.44	143.44	143.44	500.0
2012-11-07 04:15:00	SPY	ETF	143.33	143.33	143.31	143.31	1100.0
2012-11-07 04:20:00	SPY	ETF	143.34	143.34	143.28	143.28	1100.0
2012-11-07 04:25:00	SPY	ETF	143.36	143.36	143.28	143.28	2000.0
2012-11-07 04:40:00	SPY	ETF	143.28	143.28	143.28	143.28	100.0
2012-11-07 04:45:00	SPY	ETF	143.28	143.28	143.28	143.28	100.0
2012-11-07 04:55:00	SPY	ETF	143.45	143.48	143.45	143.48	18500.0
2012-11-07 05:00:00	SPY	ETF	143.45	143.45	143.45	143.45	2654.0
2012-11-07 05:05:00	SPY	ETF	143.56	143.56	143.56	143.56	1000.0
2012-11-07 05:10:00	SPY	ETF	143.55	143.55	143.55	143.55	4000.0
2012-11-07 05:15:00	SPY	ETF	143.57	143.61	143.57	143.61	700.0
2012-11-07 05:20:00	SPY	ETF	143.57	143.58	143.57	143.58	300.0
2012-11-07 05:25:00	SPY	ETF	143.5	143.5	143.5	143.5	700.0
2012-11-07 05:30:00	SPY	ETF	143.55	143.63	143.55	143.6	1700.0
2012-11-07 05:40:00	SPY	ETF	143.55	143.55	143.55	143.55	1000.0
2012-11-07 05:45:00	SPY	ETF	143.53	143.53	143.45	143.45	2700.0
2012-11-07 05:50:00	SPY	ETF	143.45	143.45	143.45	143.45	100.0
2012-11-07 05:55:00	SPY	ETF	143.43	143.45	143.43	143.45	1500.0
2012-11-07 06:00:00	SPY	ETF	143.35	143.4	143.33	143.4	3400.0
2012-11-07 06:05:00	SPY	ETF	143.3	143.31	143.29	143.3	2500.0
2012-11-07 06:10:00	SPY	ETF	143.27	143.35	143.27	143.35	7500.0
2012-11-07 06:15:00	SPY	ETF	143.28	143.28	143.2	143.22	15482.0
2012-11-07 06:20:00	SPY	ETF	143.22	143.22	143.1	143.1	33426.0
2012-11-07 06:25:00	SPY	ETF	143.07	143.07	143.07	143.07	100.0
2012-11-07 06:30:00	SPY	ETF	143.16	143.16	143.13	143.15	41000.0
2012-11-07 06:35:00	SPY	ETF	143.15	143.15	143.15	143.15	1000.0
2012-11-07 06:40:00	SPY	ETF	143.2	143.2	143.18	143.18	11032.0
2012-11-07 06:45:00	SPY	ETF	143.2	143.2	143.1	143.1	28450.0
2012-11-07 06:50:00	SPY	ETF	143.1	143.1	143.04	143.07	53499.0
2012-11-07 06:55:00	SPY	ETF	143.05	143.08	143.05	143.08	4025.0
2012-11-07 07:00:00	SPY	ETF	143.04	143.04	142.95	142.96	100299.0
2012-11-07 07:05:00	SPY	ETF	142.96	142.96	142.81	142.84	73879.0
2012-11-07 07:10:00	SPY	ETF	142.85	142.85	142.58	142.58	96068.0
2012-11-07 07:15:00	SPY	ETF	142.54	142.62	142.45	142.59	112469.0
2012-11-07 07:20:00	SPY	ETF	142.56	142.56	142.27	142.31	219062.0
2012-11-07 07:25:00	SPY	ETF	142.31	142.31	142.05	142.26	454801.0
2012-11-07 07:30:00	SPY	ETF	142.23	142.35	142.23	142.33	251678.0
2012-11-07 07:35:00	SPY	ETF	142.33	142.42	142.14	142.16	188228.0
2012-11-07 07:40:00	SPY	ETF	142.15	142.31	142.1	142.31	131857.0
2012-11-07 07:45:00	SPY	ETF	142.31	142.31	142.17	142.25	192649.0
2012-11-07 07:50:00	SPY	ETF	142.26	142.28	142.22	142.27	178717.0
2012-11-07 07:55:00	SPY	ETF	142.28	142.31	142.15	142.21	177500.0
2012-11-07 08:00:00	SPY	ETF	142.2	142.21	142.0	142.0	170932.0
2012-11-07 08:05:00	SPY	ETF	142.01	142.03	141.8	141.93	271373.0
2012-11-07 08:10:00	SPY	ETF	141.93	141.99	141.89	141.94	184830.0
2012-11-07 08:15:00	SPY	ETF	141.94	141.94	141.84	141.92	72866.0
2012-11-07 08:20:00	SPY	ETF	141.91	142.01	141.83	142.0	162774.0
2012-11-07 08:25:00	SPY	ETF	142.01	142.14	141.94	142.0	223320.0

> showing 50 of 41,429 rows — these rows as CSV

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