PREVIEW / stock_30min / 2012-07-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-23.parquet
  size:    1.4 MB
  rows:    75,236
  symbols: 3,476

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-07-23 04:00:00	AAPL	Stock	21.6071	21.6071	21.395	21.3964	45360.0
2012-07-23 04:30:00	AAPL	Stock	21.3964	21.3964	21.3429	21.3429	47908.0
2012-07-23 05:30:00	AAPL	Stock	21.3661	21.3818	21.3625	21.3625	11200.0
2012-07-23 06:00:00	AAPL	Stock	21.375	21.3821	21.375	21.375	16800.0
2012-07-23 06:30:00	AAPL	Stock	21.375	21.3929	21.375	21.3929	38948.0
2012-07-23 07:00:00	AAPL	Stock	21.3929	21.4286	21.3214	21.3546	255528.0
2012-07-23 07:30:00	AAPL	Stock	21.3311	21.3521	21.3089	21.3214	218960.0
2012-07-23 08:00:00	AAPL	Stock	21.3214	21.395	21.1543	21.2607	2931600.0
2012-07-23 08:30:00	AAPL	Stock	21.2507	21.2821	21.2143	21.2518	1496152.0
2012-07-23 09:00:00	AAPL	Stock	21.25	21.2679	21.2071	21.25	1936844.0
2012-07-23 09:30:00	AAPL	Stock	21.2286	21.2604	20.9896	21.1221	97532064.0
2012-07-23 10:00:00	AAPL	Stock	21.1161	21.23	21.0593	21.2079	66366608.0
2012-07-23 10:30:00	AAPL	Stock	21.205	21.415	21.1821	21.325	56476364.0
2012-07-23 11:00:00	AAPL	Stock	21.3214	21.3896	21.2812	21.3261	25255328.0
2012-07-23 11:30:00	AAPL	Stock	21.3271	21.3853	21.2971	21.3511	21146552.0
2012-07-23 12:00:00	AAPL	Stock	21.3536	21.3846	21.3214	21.3571	13375852.0
2012-07-23 12:30:00	AAPL	Stock	21.3579	21.4943	21.3161	21.4614	24698352.0
2012-07-23 13:00:00	AAPL	Stock	21.4611	21.5	21.4464	21.4737	17224172.0
2012-07-23 13:30:00	AAPL	Stock	21.4704	21.5332	21.4479	21.5179	18421956.0
2012-07-23 14:00:00	AAPL	Stock	21.52	21.6221	21.5071	21.5332	36783740.0
2012-07-23 14:30:00	AAPL	Stock	21.5352	21.5989	21.5036	21.5564	22017576.0
2012-07-23 15:00:00	AAPL	Stock	21.5539	21.6393	21.5	21.6293	26894364.0
2012-07-23 15:30:00	AAPL	Stock	21.6257	21.6321	21.5389	21.5657	38020668.0
2012-07-23 16:00:00	AAPL	Stock	21.5589	21.5654	21.3363	21.5264	5679324.0
2012-07-23 16:30:00	AAPL	Stock	21.5654	21.6296	21.0152	21.5214	1079820.0
2012-07-23 17:00:00	AAPL	Stock	21.5296	21.5654	21.5221	21.5389	236404.0
2012-07-23 17:30:00	AAPL	Stock	21.5296	21.5329	21.2966	21.5161	262332.0
2012-07-23 18:00:00	AAPL	Stock	21.5096	21.5218	21.5071	21.5218	214984.0
2012-07-23 18:30:00	AAPL	Stock	21.5179	21.5179	21.5	21.5	250656.0
2012-07-23 19:00:00	AAPL	Stock	21.4996	21.5046	21.4911	21.5046	246372.0
2012-07-23 19:30:00	AAPL	Stock	21.5061	21.5096	21.4857	21.4964	212212.0
2012-07-23 06:00:00	MSFT	Stock	29.52	29.54	29.41	29.41	1200.0
2012-07-23 06:30:00	MSFT	Stock	29.41	29.41	29.41	29.41	165.0
2012-07-23 07:00:00	MSFT	Stock	29.54	29.74	29.53	29.74	2700.0
2012-07-23 07:30:00	MSFT	Stock	29.57	29.75	29.56	29.75	2133.0
2012-07-23 08:00:00	MSFT	Stock	29.74	30.0	29.61	29.65	35558.0
2012-07-23 08:30:00	MSFT	Stock	29.65	30.07	29.54	29.61	31457.0
2012-07-23 09:00:00	MSFT	Stock	29.56	29.64	29.5	29.57	50200.0
2012-07-23 09:30:00	MSFT	Stock	29.53	29.58	29.03	29.17	6845913.0
2012-07-23 10:00:00	MSFT	Stock	29.17	29.21	29.05	29.106	5172292.0
2012-07-23 10:30:00	MSFT	Stock	29.1	29.18	29.05	29.115	5321160.0
2012-07-23 11:00:00	MSFT	Stock	29.115	29.14	29.08	29.116	3925150.0
2012-07-23 11:30:00	MSFT	Stock	29.12	29.13	29.01	29.1	3481272.0
2012-07-23 12:00:00	MSFT	Stock	29.1	29.16	29.08	29.15	4065506.0
2012-07-23 12:30:00	MSFT	Stock	29.15	29.25	29.11	29.17	3352372.0
2012-07-23 13:00:00	MSFT	Stock	29.17	29.25	29.14	29.25	1933685.0
2012-07-23 13:30:00	MSFT	Stock	29.25	29.3	29.2	29.24	2382577.0
2012-07-23 14:00:00	MSFT	Stock	29.235	29.31	29.23	29.245	2407018.0
2012-07-23 14:30:00	MSFT	Stock	29.244	29.27	29.2	29.23	2425593.0
2012-07-23 15:00:00	MSFT	Stock	29.23	29.33	29.18	29.3	3414275.0

> showing 50 of 75,236 rows — these rows as CSV

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