PREVIEW / stock_30min / 2012-06-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-27.parquet
  size:    1.4 MB
  rows:    75,165
  symbols: 3,502

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-06-27 05:00:00	AAPL	Stock	20.4357	20.4357	20.4296	20.4296	22400.0
2012-06-27 06:00:00	AAPL	Stock	20.445	20.4732	20.445	20.4732	25032.0
2012-06-27 06:30:00	AAPL	Stock	20.4732	20.4821	20.4732	20.4821	9968.0
2012-06-27 07:00:00	AAPL	Stock	20.4643	20.4821	20.4489	20.4818	82824.0
2012-06-27 07:30:00	AAPL	Stock	20.4954	20.5107	20.4825	20.5	211008.0
2012-06-27 08:00:00	AAPL	Stock	20.5	20.5464	20.4821	20.5236	1043084.0
2012-06-27 08:30:00	AAPL	Stock	20.5211	20.5332	20.5039	20.5168	637840.0
2012-06-27 09:00:00	AAPL	Stock	20.5168	20.5536	20.5029	20.5364	1142904.0
2012-06-27 09:30:00	AAPL	Stock	20.5357	20.5868	20.4761	20.5214	44786168.0
2012-06-27 10:00:00	AAPL	Stock	20.52	20.5979	20.5179	20.5593	22586480.0
2012-06-27 10:30:00	AAPL	Stock	20.5589	20.575	20.5257	20.5743	13333656.0
2012-06-27 11:00:00	AAPL	Stock	20.5729	20.5779	20.5254	20.5304	11483304.0
2012-06-27 11:30:00	AAPL	Stock	20.5311	20.5711	20.53	20.555	6874364.0
2012-06-27 12:00:00	AAPL	Stock	20.555	20.5711	20.5396	20.5557	6151124.0
2012-06-27 12:30:00	AAPL	Stock	20.555	20.5561	20.5204	20.5393	7419944.0
2012-06-27 13:00:00	AAPL	Stock	20.5364	20.5457	20.4911	20.5025	9922164.0
2012-06-27 13:30:00	AAPL	Stock	20.4986	20.5001	20.4257	20.4504	15380708.0
2012-06-27 14:00:00	AAPL	Stock	20.4494	20.4879	20.4325	20.4614	10558548.0
2012-06-27 14:30:00	AAPL	Stock	20.4668	20.5046	20.4561	20.4736	9300676.0
2012-06-27 15:00:00	AAPL	Stock	20.4736	20.5311	20.4647	20.5179	12412400.0
2012-06-27 15:30:00	AAPL	Stock	20.5179	20.5371	20.4911	20.5161	20470996.0
2012-06-27 16:00:00	AAPL	Stock	20.5179	20.5246	20.5071	20.5107	4868388.0
2012-06-27 16:30:00	AAPL	Stock	20.5179	20.5179	20.5089	20.5129	364728.0
2012-06-27 17:00:00	AAPL	Stock	20.5125	20.5125	20.5018	20.5054	63616.0
2012-06-27 17:30:00	AAPL	Stock	20.5096	20.5107	20.5071	20.5071	39200.0
2012-06-27 18:00:00	AAPL	Stock	20.5082	20.5082	20.5082	20.5082	2800.0
2012-06-27 18:30:00	AAPL	Stock	20.5107	20.5107	20.5036	20.5036	16800.0
2012-06-27 19:00:00	AAPL	Stock	20.5104	20.5125	20.5036	20.5036	29624.0
2012-06-27 19:30:00	AAPL	Stock	20.5039	20.5143	20.5039	20.5079	16660.0
2012-06-27 08:00:00	MSFT	Stock	30.0	30.13	30.0	30.13	1782.0
2012-06-27 08:30:00	MSFT	Stock	30.12	30.12	30.07	30.09	2900.0
2012-06-27 09:00:00	MSFT	Stock	30.07	30.2	30.07	30.2	37996.0
2012-06-27 09:30:00	MSFT	Stock	30.19	30.5	30.07	30.1	3972648.0
2012-06-27 10:00:00	MSFT	Stock	30.11	30.44	30.07	30.36	3839658.0
2012-06-27 10:30:00	MSFT	Stock	30.355	30.37	30.19	30.25	2227299.0
2012-06-27 11:00:00	MSFT	Stock	30.25	30.31	30.115	30.14	2100595.0
2012-06-27 11:30:00	MSFT	Stock	30.15	30.26	30.14	30.19	1543769.0
2012-06-27 12:00:00	MSFT	Stock	30.195	30.32	30.19	30.29	1649311.0
2012-06-27 12:30:00	MSFT	Stock	30.3	30.31	30.22	30.23	1303461.0
2012-06-27 13:00:00	MSFT	Stock	30.23	30.256	30.16	30.17	1655868.0
2012-06-27 13:30:00	MSFT	Stock	30.165	30.185	30.1	30.145	1501433.0
2012-06-27 14:00:00	MSFT	Stock	30.15	30.17	30.07	30.09	1552660.0
2012-06-27 14:30:00	MSFT	Stock	30.1	30.18	30.03	30.17	3192951.0
2012-06-27 15:00:00	MSFT	Stock	30.17	30.23	30.14	30.21	3282482.0
2012-06-27 15:30:00	MSFT	Stock	30.21	30.26	30.12	30.17	4422163.0
2012-06-27 16:00:00	MSFT	Stock	30.17	30.262	30.15	30.16	1202682.0
2012-06-27 16:30:00	MSFT	Stock	30.17	30.17	30.03	30.03	89201.0
2012-06-27 17:00:00	MSFT	Stock	30.12	30.12	30.1	30.1	1700.0
2012-06-27 17:30:00	MSFT	Stock	30.17	30.17	30.17	30.17	19272.0
2012-06-27 18:00:00	MSFT	Stock	30.16	30.16	30.15	30.15	1500.0

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

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