PREVIEW / stock_30min / 2012-08-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-13.parquet
  size:    1.4 MB
  rows:    73,374
  symbols: 3,471

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-08-13 04:00:00	AAPL	Stock	22.2036	22.2036	22.1661	22.1664	24276.0
2012-08-13 04:30:00	AAPL	Stock	22.1786	22.1786	22.1786	22.1786	2800.0
2012-08-13 05:00:00	AAPL	Stock	22.2054	22.2054	22.2054	22.2054	5600.0
2012-08-13 05:30:00	AAPL	Stock	22.2054	22.2054	22.2054	22.2054	20860.0
2012-08-13 06:00:00	AAPL	Stock	22.2321	22.2321	22.2321	22.2321	9800.0
2012-08-13 06:30:00	AAPL	Stock	22.2321	22.2464	22.2321	22.2464	14000.0
2012-08-13 07:00:00	AAPL	Stock	22.2464	22.2714	22.24	22.2632	121016.0
2012-08-13 07:30:00	AAPL	Stock	22.2621	22.3571	22.2518	22.3261	491232.0
2012-08-13 08:00:00	AAPL	Stock	22.3268	22.3429	22.2632	22.2786	1150744.0
2012-08-13 08:30:00	AAPL	Stock	22.2807	22.2936	22.2761	22.2889	984396.0
2012-08-13 09:00:00	AAPL	Stock	22.2864	22.3025	22.2625	22.2679	1887172.0
2012-08-13 09:30:00	AAPL	Stock	22.2621	22.445	22.2589	22.3799	70058660.0
2012-08-13 10:00:00	AAPL	Stock	22.3769	22.4189	22.3429	22.4036	29370292.0
2012-08-13 10:30:00	AAPL	Stock	22.4036	22.4232	22.3679	22.3804	19405400.0
2012-08-13 11:00:00	AAPL	Stock	22.3807	22.4064	22.3607	22.3861	14662592.0
2012-08-13 11:30:00	AAPL	Stock	22.3825	22.4143	22.3401	22.4018	8916460.0
2012-08-13 12:00:00	AAPL	Stock	22.4018	22.4139	22.3804	22.3929	8184680.0
2012-08-13 12:30:00	AAPL	Stock	22.3925	22.4329	22.3886	22.426	12793760.0
2012-08-13 13:00:00	AAPL	Stock	22.4268	22.4375	22.4107	22.4286	10224228.0
2012-08-13 13:30:00	AAPL	Stock	22.4293	22.4364	22.4129	22.4246	7429100.0
2012-08-13 14:00:00	AAPL	Stock	22.4254	22.4714	22.4151	22.4536	17020304.0
2012-08-13 14:30:00	AAPL	Stock	22.4536	22.4732	22.4504	22.4661	13810888.0
2012-08-13 15:00:00	AAPL	Stock	22.4636	22.4793	22.4407	22.4464	14400400.0
2012-08-13 15:30:00	AAPL	Stock	22.4465	22.5	22.4371	22.5	35215516.0
2012-08-13 16:00:00	AAPL	Stock	22.5	22.5196	22.381	22.5196	9948652.0
2012-08-13 16:30:00	AAPL	Stock	22.5179	22.5454	22.5179	22.545	540260.0
2012-08-13 17:00:00	AAPL	Stock	22.5429	22.5539	22.5	22.5429	459788.0
2012-08-13 17:30:00	AAPL	Stock	22.5411	22.5529	22.5393	22.5518	111104.0
2012-08-13 18:00:00	AAPL	Stock	22.5493	22.5539	22.5429	22.5536	55972.0
2012-08-13 18:30:00	AAPL	Stock	22.5536	22.5596	22.5536	22.5589	11760.0
2012-08-13 19:00:00	AAPL	Stock	22.5604	22.5714	22.5536	22.5536	111020.0
2012-08-13 19:30:00	AAPL	Stock	22.5536	22.5543	22.5357	22.5357	240408.0
2012-08-13 08:00:00	MSFT	Stock	30.45	30.45	30.45	30.45	800.0
2012-08-13 09:00:00	MSFT	Stock	30.48	30.48	30.33	30.38	18172.0
2012-08-13 09:30:00	MSFT	Stock	30.35	30.46	30.33	30.379	2336442.0
2012-08-13 10:00:00	MSFT	Stock	30.38	30.4	30.25	30.32	2451936.0
2012-08-13 10:30:00	MSFT	Stock	30.315	30.33	30.25	30.27	1940409.0
2012-08-13 11:00:00	MSFT	Stock	30.27	30.28	30.16	30.25	1914280.0
2012-08-13 11:30:00	MSFT	Stock	30.242	30.27	30.215	30.24	925746.0
2012-08-13 12:00:00	MSFT	Stock	30.24	30.25	30.2	30.225	675945.0
2012-08-13 12:30:00	MSFT	Stock	30.23	30.31	30.21	30.3	1249926.0
2012-08-13 13:00:00	MSFT	Stock	30.3	30.32	30.28	30.28	1214787.0
2012-08-13 13:30:00	MSFT	Stock	30.288	30.34	30.26	30.33	981116.0
2012-08-13 14:00:00	MSFT	Stock	30.32	30.39	30.29	30.32	1375108.0
2012-08-13 14:30:00	MSFT	Stock	30.32	30.395	30.32	30.362	1265840.0
2012-08-13 15:00:00	MSFT	Stock	30.37	30.39	30.34	30.345	1126486.0
2012-08-13 15:30:00	MSFT	Stock	30.35	30.4	30.315	30.4	3703327.0
2012-08-13 16:00:00	MSFT	Stock	30.4	30.45	30.253	30.253	1547814.0
2012-08-13 16:30:00	MSFT	Stock	30.342	30.342	30.342	30.342	2900.0
2012-08-13 17:00:00	MSFT	Stock	30.38	30.4	30.38	30.4	8400.0

> showing 50 of 73,374 rows — these rows as CSV

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