PREVIEW / etf_5min / 2013-04-18

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-18.parquet
  size:    1003 KB
  rows:    41,979

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
2013-04-18 04:00:00	SPY	ETF	155.13	155.25	155.13	155.21	6750.0
2013-04-18 04:05:00	SPY	ETF	155.18	155.18	155.18	155.18	2000.0
2013-04-18 04:15:00	SPY	ETF	155.24	155.24	155.21	155.21	918.0
2013-04-18 04:20:00	SPY	ETF	155.16	155.16	155.16	155.16	218.0
2013-04-18 04:30:00	SPY	ETF	155.31	155.31	155.26	155.26	600.0
2013-04-18 04:35:00	SPY	ETF	155.24	155.24	155.24	155.24	300.0
2013-04-18 04:40:00	SPY	ETF	155.26	155.26	155.26	155.26	1000.0
2013-04-18 04:45:00	SPY	ETF	155.29	155.31	155.29	155.29	2600.0
2013-04-18 04:55:00	SPY	ETF	155.41	155.41	155.41	155.41	4000.0
2013-04-18 05:00:00	SPY	ETF	155.35	155.35	155.35	155.35	500.0
2013-04-18 05:10:00	SPY	ETF	155.36	155.36	155.36	155.36	200.0
2013-04-18 05:20:00	SPY	ETF	155.46	155.54	155.46	155.54	1100.0
2013-04-18 05:30:00	SPY	ETF	155.54	155.6	155.54	155.6	1800.0
2013-04-18 05:35:00	SPY	ETF	155.61	155.66	155.61	155.66	6899.0
2013-04-18 05:40:00	SPY	ETF	155.64	155.64	155.63	155.63	4400.0
2013-04-18 05:45:00	SPY	ETF	155.66	155.67	155.64	155.67	4501.0
2013-04-18 05:50:00	SPY	ETF	155.67	155.73	155.67	155.73	8574.0
2013-04-18 05:55:00	SPY	ETF	155.63	155.67	155.61	155.62	28769.0
2013-04-18 06:05:00	SPY	ETF	155.61	155.62	155.61	155.62	600.0
2013-04-18 06:10:00	SPY	ETF	155.62	155.62	155.49	155.49	2100.0
2013-04-18 06:15:00	SPY	ETF	155.51	155.51	155.51	155.51	1000.0
2013-04-18 06:20:00	SPY	ETF	155.54	155.59	155.54	155.59	1900.0
2013-04-18 06:25:00	SPY	ETF	155.54	155.56	155.54	155.55	2000.0
2013-04-18 06:30:00	SPY	ETF	155.5	155.5	155.44	155.49	5900.0
2013-04-18 06:35:00	SPY	ETF	155.49	155.55	155.49	155.55	6000.0
2013-04-18 06:40:00	SPY	ETF	155.54	155.54	155.53	155.53	600.0
2013-04-18 06:45:00	SPY	ETF	155.5	155.5	155.49	155.5	1500.0
2013-04-18 06:50:00	SPY	ETF	155.54	155.66	155.54	155.62	23500.0
2013-04-18 06:55:00	SPY	ETF	155.6	155.61	155.54	155.56	26500.0
2013-04-18 07:00:00	SPY	ETF	155.51	155.55	155.51	155.55	10200.0
2013-04-18 07:05:00	SPY	ETF	155.54	155.69	155.53	155.67	22150.0
2013-04-18 07:10:00	SPY	ETF	155.64	155.7	155.64	155.7	7501.0
2013-04-18 07:15:00	SPY	ETF	155.68	155.77	155.68	155.75	18534.0
2013-04-18 07:20:00	SPY	ETF	155.69	155.72	155.66	155.71	42693.0
2013-04-18 07:25:00	SPY	ETF	155.73	155.75	155.7	155.71	12000.0
2013-04-18 07:30:00	SPY	ETF	155.72	155.79	155.72	155.78	72037.0
2013-04-18 07:35:00	SPY	ETF	155.79	155.8	155.75	155.76	29525.0
2013-04-18 07:40:00	SPY	ETF	155.77	155.77	155.75	155.75	29050.0
2013-04-18 07:45:00	SPY	ETF	155.74	155.74	155.55	155.57	82049.0
2013-04-18 07:50:00	SPY	ETF	155.62	155.62	155.58	155.6	16800.0
2013-04-18 07:55:00	SPY	ETF	155.62	155.68	155.59	155.59	9300.0
2013-04-18 08:00:00	SPY	ETF	155.59	155.75	155.0	155.6	100000.0
2013-04-18 08:05:00	SPY	ETF	155.6	155.69	155.59	155.67	111900.0
2013-04-18 08:10:00	SPY	ETF	155.67	155.69	155.63	155.69	47400.0
2013-04-18 08:15:00	SPY	ETF	155.65	155.66	155.58	155.63	274700.0
2013-04-18 08:20:00	SPY	ETF	155.62	155.62	155.52	155.53	38092.0
2013-04-18 08:25:00	SPY	ETF	155.53	155.57	155.51	155.56	78847.0
2013-04-18 08:30:00	SPY	ETF	155.56	155.7	155.55	155.58	174814.0
2013-04-18 08:35:00	SPY	ETF	155.58	155.59	155.5	155.56	64974.0
2013-04-18 08:40:00	SPY	ETF	155.57	155.62	155.56	155.56	37062.0

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

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