PREVIEW / etf_5min / 2012-10-22

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-10-22.parquet
  size:    876 KB
  rows:    35,949

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-10-22 04:00:00	SPY	ETF	143.01	143.01	143.01	143.01	420.0
2012-10-22 04:05:00	SPY	ETF	143.18	143.18	143.18	143.18	100.0
2012-10-22 04:20:00	SPY	ETF	143.21	143.23	143.21	143.23	400.0
2012-10-22 04:30:00	SPY	ETF	143.3	143.3	143.3	143.3	250.0
2012-10-22 04:40:00	SPY	ETF	143.23	143.23	143.23	143.23	900.0
2012-10-22 04:45:00	SPY	ETF	143.41	143.41	143.41	143.41	900.0
2012-10-22 04:55:00	SPY	ETF	143.46	143.46	143.44	143.46	1500.0
2012-10-22 05:00:00	SPY	ETF	143.48	143.52	143.48	143.51	4960.0
2012-10-22 05:05:00	SPY	ETF	143.51	143.54	143.51	143.54	1600.0
2012-10-22 05:10:00	SPY	ETF	143.54	143.6	143.54	143.6	965.0
2012-10-22 05:15:00	SPY	ETF	143.61	143.65	143.61	143.65	3500.0
2012-10-22 05:25:00	SPY	ETF	143.6	143.6	143.6	143.6	500.0
2012-10-22 05:45:00	SPY	ETF	143.55	143.55	143.55	143.55	2000.0
2012-10-22 05:50:00	SPY	ETF	143.6	143.6	143.6	143.6	5200.0
2012-10-22 05:55:00	SPY	ETF	143.58	143.6	143.58	143.6	600.0
2012-10-22 06:00:00	SPY	ETF	143.56	143.62	143.53	143.62	26000.0
2012-10-22 06:05:00	SPY	ETF	143.6	143.6	143.56	143.59	2600.0
2012-10-22 06:10:00	SPY	ETF	143.61	143.62	143.58	143.59	4449.0
2012-10-22 06:15:00	SPY	ETF	143.64	143.64	143.58	143.58	5500.0
2012-10-22 06:20:00	SPY	ETF	143.59	143.59	143.59	143.59	200.0
2012-10-22 06:25:00	SPY	ETF	143.59	143.61	143.58	143.61	14500.0
2012-10-22 06:30:00	SPY	ETF	143.6	143.6	143.58	143.58	28000.0
2012-10-22 06:35:00	SPY	ETF	143.61	143.61	143.61	143.61	18000.0
2012-10-22 06:40:00	SPY	ETF	143.56	143.56	143.56	143.56	9500.0
2012-10-22 06:45:00	SPY	ETF	143.56	143.56	143.55	143.56	1942.0
2012-10-22 06:50:00	SPY	ETF	143.59	143.59	143.55	143.55	10500.0
2012-10-22 06:55:00	SPY	ETF	143.56	143.57	143.47	143.48	19500.0
2012-10-22 07:00:00	SPY	ETF	143.53	143.56	143.53	143.54	14110.0
2012-10-22 07:05:00	SPY	ETF	143.55	143.57	143.53	143.55	37816.0
2012-10-22 07:10:00	SPY	ETF	143.55	143.6	143.55	143.58	3995.0
2012-10-22 07:15:00	SPY	ETF	143.57	143.61	143.56	143.59	21697.0
2012-10-22 07:20:00	SPY	ETF	143.59	143.61	143.57	143.57	16550.0
2012-10-22 07:25:00	SPY	ETF	143.6	143.6	143.58	143.59	2100.0
2012-10-22 07:30:00	SPY	ETF	143.6	143.61	143.41	143.41	53157.0
2012-10-22 07:35:00	SPY	ETF	143.41	143.52	143.4	143.46	36765.0
2012-10-22 07:40:00	SPY	ETF	143.49	143.49	143.37	143.38	29435.0
2012-10-22 07:45:00	SPY	ETF	143.37	143.41	143.31	143.38	28610.0
2012-10-22 07:50:00	SPY	ETF	143.37	143.37	143.33	143.33	7300.0
2012-10-22 07:55:00	SPY	ETF	143.34	143.36	143.28	143.34	18292.0
2012-10-22 08:00:00	SPY	ETF	143.34	143.62	143.11	143.39	105915.0
2012-10-22 08:05:00	SPY	ETF	143.38	143.39	143.19	143.23	334908.0
2012-10-22 08:10:00	SPY	ETF	143.25	143.25	143.2	143.2	43168.0
2012-10-22 08:15:00	SPY	ETF	143.23	143.23	143.13	143.14	62880.0
2012-10-22 08:20:00	SPY	ETF	143.13	143.22	143.12	143.22	62915.0
2012-10-22 08:25:00	SPY	ETF	143.22	143.29	143.21	143.28	135960.0
2012-10-22 08:30:00	SPY	ETF	143.28	143.3	143.22	143.22	74020.0
2012-10-22 08:35:00	SPY	ETF	143.22	143.22	143.15	143.18	116199.0
2012-10-22 08:40:00	SPY	ETF	143.2	143.21	143.18	143.21	42500.0
2012-10-22 08:45:00	SPY	ETF	143.2	143.2	143.17	143.18	72438.0
2012-10-22 08:50:00	SPY	ETF	143.18	143.23	143.17	143.22	42651.0

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

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