PREVIEW / etf_5min / 2014-06-30

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-06-30.parquet
  size:    959 KB
  rows:    42,010

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
2014-06-30 04:05:00	SPY	ETF	195.7	195.73	195.7	195.73	1750.0
2014-06-30 04:35:00	SPY	ETF	195.62	195.62	195.62	195.62	104.0
2014-06-30 04:40:00	SPY	ETF	195.6	195.6	195.6	195.6	183.0
2014-06-30 05:20:00	SPY	ETF	195.63	195.63	195.63	195.63	2500.0
2014-06-30 05:40:00	SPY	ETF	195.64	195.64	195.64	195.64	200.0
2014-06-30 05:45:00	SPY	ETF	195.65	195.65	195.65	195.65	1500.0
2014-06-30 05:50:00	SPY	ETF	195.67	195.67	195.67	195.67	296.0
2014-06-30 05:55:00	SPY	ETF	195.65	195.65	195.65	195.65	100.0
2014-06-30 06:00:00	SPY	ETF	195.72	195.72	195.72	195.72	1000.0
2014-06-30 06:05:00	SPY	ETF	195.72	195.72	195.72	195.72	167.0
2014-06-30 06:10:00	SPY	ETF	195.7	195.7	195.7	195.7	100.0
2014-06-30 06:15:00	SPY	ETF	195.72	195.72	195.72	195.72	150.0
2014-06-30 06:20:00	SPY	ETF	195.62	195.62	195.62	195.62	200.0
2014-06-30 06:25:00	SPY	ETF	195.58	195.88	195.55	195.57	3957.0
2014-06-30 06:30:00	SPY	ETF	195.62	195.62	195.53	195.53	661.0
2014-06-30 06:40:00	SPY	ETF	195.59	195.59	195.59	195.59	151.0
2014-06-30 06:45:00	SPY	ETF	195.57	195.57	195.57	195.57	800.0
2014-06-30 06:50:00	SPY	ETF	195.55	195.55	195.52	195.52	7195.0
2014-06-30 06:55:00	SPY	ETF	195.54	195.54	195.51	195.51	2700.0
2014-06-30 07:00:00	SPY	ETF	195.47	195.47	195.33	195.33	23430.0
2014-06-30 07:05:00	SPY	ETF	195.35	195.43	195.26	195.35	78700.0
2014-06-30 07:10:00	SPY	ETF	195.35	195.37	195.3	195.33	51600.0
2014-06-30 07:15:00	SPY	ETF	195.37	195.39	195.37	195.39	13803.0
2014-06-30 07:20:00	SPY	ETF	195.39	195.43	195.38	195.43	3147.0
2014-06-30 07:25:00	SPY	ETF	195.44	195.49	195.44	195.49	3807.0
2014-06-30 07:30:00	SPY	ETF	195.49	195.6	195.49	195.55	29050.0
2014-06-30 07:35:00	SPY	ETF	195.55	195.55	195.51	195.52	11600.0
2014-06-30 07:40:00	SPY	ETF	195.52	195.52	195.49	195.49	42200.0
2014-06-30 07:45:00	SPY	ETF	195.49	195.49	195.47	195.48	9950.0
2014-06-30 07:50:00	SPY	ETF	195.47	195.5	195.47	195.5	1700.0
2014-06-30 07:55:00	SPY	ETF	195.5	195.51	195.49	195.49	2850.0
2014-06-30 08:00:00	SPY	ETF	195.51	195.59	195.51	195.59	17377.0
2014-06-30 08:05:00	SPY	ETF	195.855	195.855	195.58	195.59	57454.0
2014-06-30 08:10:00	SPY	ETF	195.62	195.62	195.6	195.6	2400.0
2014-06-30 08:15:00	SPY	ETF	195.64	195.67	195.61	195.65	38146.0
2014-06-30 08:20:00	SPY	ETF	195.65	195.69	195.64	195.69	53687.0
2014-06-30 08:25:00	SPY	ETF	195.67	195.74	195.67	195.72	75950.0
2014-06-30 08:30:00	SPY	ETF	195.72	195.72	195.66	195.67	10649.0
2014-06-30 08:35:00	SPY	ETF	195.67	195.68	195.66	195.66	3143.0
2014-06-30 08:40:00	SPY	ETF	195.66	195.67	195.64	195.66	8218.0
2014-06-30 08:45:00	SPY	ETF	195.65	195.66	195.62	195.63	28982.0
2014-06-30 08:50:00	SPY	ETF	195.64	195.7	195.63	195.67	61285.0
2014-06-30 08:55:00	SPY	ETF	195.66	195.66	195.62	195.63	7911.0
2014-06-30 09:00:00	SPY	ETF	195.62	195.65	195.62	195.65	3111.0
2014-06-30 09:05:00	SPY	ETF	195.65	195.65	195.63	195.65	87226.0
2014-06-30 09:10:00	SPY	ETF	195.64	195.68	195.63	195.68	16415.0
2014-06-30 09:15:00	SPY	ETF	195.66	195.68	195.66	195.67	16871.0
2014-06-30 09:20:00	SPY	ETF	195.68	195.68	195.67	195.68	7556.0
2014-06-30 09:25:00	SPY	ETF	195.69	195.76	195.68	195.7	168132.0
2014-06-30 09:30:00	SPY	ETF	195.7	195.8	195.55	195.63	2357948.0

> showing 50 of 42,010 rows — these rows as CSV

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