PREVIEW / etf_5min / 2012-04-13

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-13.parquet
  size:    831 KB
  rows:    35,533

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-04-13 04:00:00	SPY	ETF	138.68	138.68	138.56	138.56	2300.0
2012-04-13 04:05:00	SPY	ETF	138.54	138.54	138.54	138.54	100.0
2012-04-13 04:20:00	SPY	ETF	138.5	138.54	138.5	138.54	420.0
2012-04-13 04:25:00	SPY	ETF	138.43	138.43	138.43	138.43	100.0
2012-04-13 04:30:00	SPY	ETF	138.39	138.39	138.36	138.36	500.0
2012-04-13 04:35:00	SPY	ETF	138.43	138.43	138.43	138.43	500.0
2012-04-13 04:40:00	SPY	ETF	138.51	138.51	138.45	138.45	800.0
2012-04-13 04:50:00	SPY	ETF	138.42	138.42	138.42	138.42	200.0
2012-04-13 04:55:00	SPY	ETF	138.4	138.4	138.4	138.4	200.0
2012-04-13 05:00:00	SPY	ETF	138.43	138.43	138.4	138.4	200.0
2012-04-13 05:05:00	SPY	ETF	138.32	138.32	138.27	138.28	600.0
2012-04-13 05:10:00	SPY	ETF	138.28	138.28	138.22	138.28	1243.0
2012-04-13 05:15:00	SPY	ETF	138.38	138.38	138.38	138.38	200.0
2012-04-13 05:20:00	SPY	ETF	138.35	138.35	138.3	138.3	31000.0
2012-04-13 05:25:00	SPY	ETF	138.34	138.37	138.32	138.37	15200.0
2012-04-13 05:30:00	SPY	ETF	138.43	138.43	138.43	138.43	100.0
2012-04-13 05:35:00	SPY	ETF	138.5	138.51	138.5	138.51	1140.0
2012-04-13 05:40:00	SPY	ETF	138.48	138.48	138.48	138.48	2000.0
2012-04-13 05:45:00	SPY	ETF	138.4	138.4	138.4	138.4	200.0
2012-04-13 05:50:00	SPY	ETF	138.48	138.5	138.46	138.46	1100.0
2012-04-13 05:55:00	SPY	ETF	138.46	138.46	138.46	138.46	1000.0
2012-04-13 06:00:00	SPY	ETF	138.41	138.41	138.41	138.41	100.0
2012-04-13 06:10:00	SPY	ETF	138.49	138.51	138.49	138.51	2000.0
2012-04-13 06:15:00	SPY	ETF	138.52	138.54	138.52	138.54	2240.0
2012-04-13 06:20:00	SPY	ETF	138.6	138.65	138.6	138.63	1940.0
2012-04-13 06:25:00	SPY	ETF	138.6	138.6	138.55	138.55	17900.0
2012-04-13 06:30:00	SPY	ETF	138.6	138.6	138.6	138.6	100.0
2012-04-13 06:35:00	SPY	ETF	138.65	138.66	138.65	138.66	8200.0
2012-04-13 06:40:00	SPY	ETF	138.64	138.66	138.62	138.66	14000.0
2012-04-13 06:45:00	SPY	ETF	138.7	138.7	138.7	138.7	2500.0
2012-04-13 06:50:00	SPY	ETF	138.66	138.7	138.66	138.69	15200.0
2012-04-13 06:55:00	SPY	ETF	138.7	138.92	138.7	138.9	190850.0
2012-04-13 07:00:00	SPY	ETF	138.9	138.91	138.8	138.8	104787.0
2012-04-13 07:05:00	SPY	ETF	138.79	138.81	138.75	138.78	43610.0
2012-04-13 07:10:00	SPY	ETF	138.81	138.81	138.7	138.75	95700.0
2012-04-13 07:15:00	SPY	ETF	138.72	138.79	138.7	138.74	34457.0
2012-04-13 07:20:00	SPY	ETF	138.76	139.01	138.76	138.95	74300.0
2012-04-13 07:25:00	SPY	ETF	138.96	139.0	138.9	138.9	115850.0
2012-04-13 07:30:00	SPY	ETF	138.88	138.9	138.75	138.8	57800.0
2012-04-13 07:35:00	SPY	ETF	138.78	138.86	138.76	138.78	79977.0
2012-04-13 07:40:00	SPY	ETF	138.79	138.79	138.64	138.64	37100.0
2012-04-13 07:45:00	SPY	ETF	138.62	138.64	138.53	138.57	25185.0
2012-04-13 07:50:00	SPY	ETF	138.57	138.59	138.48	138.5	20750.0
2012-04-13 07:55:00	SPY	ETF	138.5	138.52	138.43	138.43	25800.0
2012-04-13 08:00:00	SPY	ETF	138.43	138.77	138.36	138.75	311224.0
2012-04-13 08:05:00	SPY	ETF	138.94	138.94	138.34	138.34	139135.0
2012-04-13 08:10:00	SPY	ETF	138.33	138.47	138.31	138.43	83884.0
2012-04-13 08:15:00	SPY	ETF	138.41	138.57	138.4	138.53	50334.0
2012-04-13 08:20:00	SPY	ETF	138.53	138.54	138.41	138.41	27292.0
2012-04-13 08:25:00	SPY	ETF	138.41	138.45	138.31	138.36	150216.0

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

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