PREVIEW / stock_30min / 2011-06-24

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-24.parquet
  size:    1.5 MB
  rows:    79,076
  symbols: 3,549

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
2011-06-24 04:30:00	AAPL	Stock	11.8636	11.8636	11.8636	11.8636	2800.0
2011-06-24 05:00:00	AAPL	Stock	11.9111	11.9111	11.9107	11.9107	36400.0
2011-06-24 05:30:00	AAPL	Stock	11.9071	11.9071	11.9071	11.9071	14000.0
2011-06-24 06:00:00	AAPL	Stock	11.9018	11.9018	11.8632	11.8632	27440.0
2011-06-24 06:30:00	AAPL	Stock	11.8632	11.8643	11.8632	11.8643	8400.0
2011-06-24 07:00:00	AAPL	Stock	11.8611	11.8611	11.8393	11.8393	153300.0
2011-06-24 07:30:00	AAPL	Stock	11.8393	11.85	11.8229	11.8229	145012.0
2011-06-24 08:00:00	AAPL	Stock	11.8393	11.8464	11.7829	11.8246	1185128.0
2011-06-24 08:30:00	AAPL	Stock	11.825	11.845	11.8071	11.8311	1402212.0
2011-06-24 09:00:00	AAPL	Stock	11.8271	11.8493	11.8143	11.8375	1235808.0
2011-06-24 09:30:00	AAPL	Stock	11.8364	11.8982	11.8061	11.8404	78852928.0
2011-06-24 10:00:00	AAPL	Stock	11.8393	11.8496	11.7411	11.7589	47619796.0
2011-06-24 10:30:00	AAPL	Stock	11.7579	11.7814	11.7093	11.7454	38681384.0
2011-06-24 11:00:00	AAPL	Stock	11.7457	11.7593	11.7139	11.7579	24199504.0
2011-06-24 11:30:00	AAPL	Stock	11.7596	11.7832	11.7379	11.7436	20796580.0
2011-06-24 12:00:00	AAPL	Stock	11.7436	11.765	11.7182	11.7268	14468272.0
2011-06-24 12:30:00	AAPL	Stock	11.7264	11.7478	11.6886	11.6968	21263872.0
2011-06-24 13:00:00	AAPL	Stock	11.6968	11.7	11.6518	11.6707	23275140.0
2011-06-24 13:30:00	AAPL	Stock	11.6718	11.7339	11.6696	11.7018	23937956.0
2011-06-24 14:00:00	AAPL	Stock	11.7036	11.7043	11.6621	11.6914	17314780.0
2011-06-24 14:30:00	AAPL	Stock	11.6929	11.7018	11.6575	11.6714	17948980.0
2011-06-24 15:00:00	AAPL	Stock	11.6736	11.6796	11.6104	11.6186	31127852.0
2011-06-24 15:30:00	AAPL	Stock	11.6179	11.66	11.6143	11.6554	46924024.0
2011-06-24 16:00:00	AAPL	Stock	11.6554	11.7333	11.6371	11.6404	13815760.0
2011-06-24 16:30:00	AAPL	Stock	11.6411	11.6612	11.6268	11.6343	4816700.0
2011-06-24 17:00:00	AAPL	Stock	11.6411	11.6604	11.6386	11.6604	496888.0
2011-06-24 17:30:00	AAPL	Stock	11.7469	11.7469	11.7469	11.7469	81200.0
2011-06-24 18:00:00	AAPL	Stock	11.6429	11.6554	11.6321	11.6329	176932.0
2011-06-24 18:30:00	AAPL	Stock	11.6339	11.6357	11.6314	11.6357	12460.0
2011-06-24 19:00:00	AAPL	Stock	11.6375	11.6375	11.6311	11.6339	31500.0
2011-06-24 19:30:00	AAPL	Stock	11.6368	11.6414	11.6321	11.6414	73024.0
2011-06-24 05:30:00	MSFT	Stock	24.8	24.8	24.8	24.8	150.0
2011-06-24 06:00:00	MSFT	Stock	24.63	24.63	24.63	24.63	100.0
2011-06-24 07:00:00	MSFT	Stock	24.62	24.62	24.62	24.62	300.0
2011-06-24 08:00:00	MSFT	Stock	24.58	24.63	24.3	24.63	20557.0
2011-06-24 08:30:00	MSFT	Stock	24.62	24.71	24.57	24.71	9122.0
2011-06-24 09:00:00	MSFT	Stock	24.7	24.7	24.51	24.51	31776.0
2011-06-24 09:30:00	MSFT	Stock	24.51	24.54	24.305	24.335	6356479.0
2011-06-24 10:00:00	MSFT	Stock	24.34	24.38	24.21	24.285	5748976.0
2011-06-24 10:30:00	MSFT	Stock	24.29	24.35	24.26	24.3	3477290.0
2011-06-24 11:00:00	MSFT	Stock	24.305	24.34	24.27	24.34	3902960.0
2011-06-24 11:30:00	MSFT	Stock	24.335	24.35	24.26	24.3	2575738.0
2011-06-24 12:00:00	MSFT	Stock	24.3	24.31	24.26	24.269	1807290.0
2011-06-24 12:30:00	MSFT	Stock	24.26	24.29	24.19	24.23	5015298.0
2011-06-24 13:00:00	MSFT	Stock	24.23	24.275	24.21	24.27	2765062.0
2011-06-24 13:30:00	MSFT	Stock	24.27	24.32	24.255	24.28	2221418.0
2011-06-24 14:00:00	MSFT	Stock	24.28	24.29	24.23	24.25	2483172.0
2011-06-24 14:30:00	MSFT	Stock	24.25	24.29	24.24	24.25	2727745.0
2011-06-24 15:00:00	MSFT	Stock	24.25	24.29	24.215	24.23	4046100.0
2011-06-24 15:30:00	MSFT	Stock	24.23	24.33	24.23	24.29	8776551.0

> showing 50 of 79,076 rows — these rows as CSV

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