PREVIEW / stock_30min / 2014-08-29

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-29.parquet
  size:    1.5 MB
  rows:    80,881
  symbols: 3,585

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-08-29 04:00:00	AAPL	Stock	25.655	25.655	25.6525	25.655	5600.0
2014-08-29 04:30:00	AAPL	Stock	25.6825	25.6825	25.675	25.675	10836.0
2014-08-29 05:00:00	AAPL	Stock	25.6825	25.6875	25.67	25.675	20980.0
2014-08-29 05:30:00	AAPL	Stock	25.675	25.675	25.6725	25.6725	17600.0
2014-08-29 06:00:00	AAPL	Stock	25.65	25.6875	25.65	25.685	33460.0
2014-08-29 06:30:00	AAPL	Stock	25.69	25.72	25.6875	25.705	22600.0
2014-08-29 07:00:00	AAPL	Stock	25.705	25.725	25.68	25.6975	58320.0
2014-08-29 07:30:00	AAPL	Stock	25.695	25.6975	25.675	25.6825	62680.0
2014-08-29 08:00:00	AAPL	Stock	25.6825	25.73	25.65	25.65	394460.0
2014-08-29 08:30:00	AAPL	Stock	25.65	25.66	25.6275	25.6475	198684.0
2014-08-29 09:00:00	AAPL	Stock	25.645	25.7325	25.6425	25.715	728324.0
2014-08-29 09:30:00	AAPL	Stock	25.715	25.725	25.5875	25.63	25696144.0
2014-08-29 10:00:00	AAPL	Stock	25.63	25.6475	25.55	25.6025	14458972.0
2014-08-29 10:30:00	AAPL	Stock	25.6025	25.6275	25.5825	25.6178	9162504.0
2014-08-29 11:00:00	AAPL	Stock	25.62	25.6675	25.6182	25.6425	11068320.0
2014-08-29 11:30:00	AAPL	Stock	25.6425	25.6575	25.61	25.6198	8330944.0
2014-08-29 12:00:00	AAPL	Stock	25.62	25.6325	25.575	25.6	8074740.0
2014-08-29 12:30:00	AAPL	Stock	25.5975	25.625	25.595	25.6112	5131684.0
2014-08-29 13:00:00	AAPL	Stock	25.6112	25.63	25.585	25.6025	4623036.0
2014-08-29 13:30:00	AAPL	Stock	25.6002	25.6125	25.59	25.6075	4999636.0
2014-08-29 14:00:00	AAPL	Stock	25.6075	25.6525	25.605	25.6388	7618248.0
2014-08-29 14:30:00	AAPL	Stock	25.6388	25.6525	25.6325	25.6475	5501712.0
2014-08-29 15:00:00	AAPL	Stock	25.6475	25.65	25.62	25.625	7232940.0
2014-08-29 15:30:00	AAPL	Stock	25.625	25.6425	25.585	25.625	20583056.0
2014-08-29 16:00:00	AAPL	Stock	25.625	25.6475	25.6	25.645	32292972.0
2014-08-29 16:30:00	AAPL	Stock	25.645	25.6475	25.625	25.6375	165120.0
2014-08-29 17:00:00	AAPL	Stock	25.6375	25.64	25.63	25.63	23472.0
2014-08-29 17:30:00	AAPL	Stock	25.63	25.6375	25.63	25.6375	23880.0
2014-08-29 18:00:00	AAPL	Stock	25.6275	25.6275	25.6225	25.625	104440.0
2014-08-29 18:30:00	AAPL	Stock	25.6225	25.635	25.6225	25.63	83832.0
2014-08-29 19:00:00	AAPL	Stock	25.63	25.6375	25.625	25.625	26500.0
2014-08-29 19:30:00	AAPL	Stock	25.635	25.6375	25.6275	25.6375	60768.0
2014-08-29 08:00:00	MSFT	Stock	45.03	45.03	45.03	45.03	100.0
2014-08-29 09:00:00	MSFT	Stock	44.88	45.04	44.88	45.03	27536.0
2014-08-29 09:30:00	MSFT	Stock	45.03	45.17	44.9	45.05	2755077.0
2014-08-29 10:00:00	MSFT	Stock	45.05	45.05	44.855	44.935	1324095.0
2014-08-29 10:30:00	MSFT	Stock	44.935	45.035	44.87	45.035	703528.0
2014-08-29 11:00:00	MSFT	Stock	45.04	45.11	45.03	45.05	864413.0
2014-08-29 11:30:00	MSFT	Stock	45.05	45.2	45.04	45.17	656533.0
2014-08-29 12:00:00	MSFT	Stock	45.17	45.19	45.06	45.14	711317.0
2014-08-29 12:30:00	MSFT	Stock	45.15	45.25	45.13	45.25	843313.0
2014-08-29 13:00:00	MSFT	Stock	45.25	45.3	45.19	45.26	636034.0
2014-08-29 13:30:00	MSFT	Stock	45.265	45.28	45.24	45.25	804426.0
2014-08-29 14:00:00	MSFT	Stock	45.25	45.29	45.22	45.29	1000825.0
2014-08-29 14:30:00	MSFT	Stock	45.285	45.29	45.21	45.225	797848.0
2014-08-29 15:00:00	MSFT	Stock	45.225	45.23	45.14	45.145	732516.0
2014-08-29 15:30:00	MSFT	Stock	45.144	45.44	45.13	45.42	4091098.0
2014-08-29 16:00:00	MSFT	Stock	45.43	45.45	45.007	45.281	4386218.0
2014-08-29 16:30:00	MSFT	Stock	45.44	45.44	45.37	45.37	7992.0
2014-08-29 18:00:00	MSFT	Stock	45.34	45.43	45.34	45.43	29586.0

> showing 50 of 80,881 rows — these rows as CSV

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