PREVIEW / stock_30min / 2011-12-27

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-27.parquet
  size:    1.4 MB
  rows:    75,088
  symbols: 3,559

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-12-27 07:00:00	AAPL	Stock	14.4143	14.4214	14.3929	14.4121	84140.0
2011-12-27 07:30:00	AAPL	Stock	14.4107	14.4111	14.3946	14.3946	46956.0
2011-12-27 08:00:00	AAPL	Stock	14.3936	14.4786	14.3936	14.4307	658196.0
2011-12-27 08:30:00	AAPL	Stock	14.4329	14.4393	14.4036	14.4268	585816.0
2011-12-27 09:00:00	AAPL	Stock	14.4232	14.4382	14.4011	14.4011	541436.0
2011-12-27 09:30:00	AAPL	Stock	14.3964	14.6104	14.3936	14.5764	68112352.0
2011-12-27 10:00:00	AAPL	Stock	14.5746	14.5957	14.5429	14.5475	23311624.0
2011-12-27 10:30:00	AAPL	Stock	14.5471	14.5589	14.4846	14.5018	23919532.0
2011-12-27 11:00:00	AAPL	Stock	14.4996	14.5243	14.4929	14.5218	11015508.0
2011-12-27 11:30:00	AAPL	Stock	14.5218	14.5571	14.5186	14.5536	11848144.0
2011-12-27 12:00:00	AAPL	Stock	14.5529	14.5675	14.5446	14.5576	9907044.0
2011-12-27 12:30:00	AAPL	Stock	14.5565	14.5589	14.5293	14.535	8071140.0
2011-12-27 13:00:00	AAPL	Stock	14.5336	14.5443	14.5304	14.5396	6573868.0
2011-12-27 13:30:00	AAPL	Stock	14.5379	14.585	14.5339	14.5807	11328100.0
2011-12-27 14:00:00	AAPL	Stock	14.58	14.5871	14.5657	14.5664	11350136.0
2011-12-27 14:30:00	AAPL	Stock	14.5666	14.5854	14.5251	14.5789	11338208.0
2011-12-27 15:00:00	AAPL	Stock	14.58	14.5925	14.57	14.5855	13385288.0
2011-12-27 15:30:00	AAPL	Stock	14.5854	14.5854	14.5136	14.5204	27825028.0
2011-12-27 16:00:00	AAPL	Stock	14.5193	14.5441	14.4636	14.5132	20120352.0
2011-12-27 16:30:00	AAPL	Stock	14.5132	14.5863	14.5075	14.5179	238896.0
2011-12-27 17:00:00	AAPL	Stock	14.5171	14.5189	14.5146	14.5179	286216.0
2011-12-27 17:30:00	AAPL	Stock	14.5179	14.5339	14.5179	14.5332	78120.0
2011-12-27 18:00:00	AAPL	Stock	14.5268	14.5304	14.5189	14.5261	65156.0
2011-12-27 18:30:00	AAPL	Stock	14.5193	14.5286	14.5179	14.5179	89264.0
2011-12-27 19:00:00	AAPL	Stock	14.5179	14.5204	14.5179	14.5204	5600.0
2011-12-27 19:30:00	AAPL	Stock	14.5196	14.5196	14.5154	14.5154	59668.0
2011-12-27 05:00:00	MSFT	Stock	26.04	26.04	26.04	26.04	425.0
2011-12-27 06:00:00	MSFT	Stock	26.04	26.04	26.04	26.04	575.0
2011-12-27 07:30:00	MSFT	Stock	26.03	26.03	26.0	26.0	500.0
2011-12-27 08:00:00	MSFT	Stock	26.02	26.02	25.98	26.0	2550.0
2011-12-27 08:30:00	MSFT	Stock	26.0	26.0	25.97	25.97	4000.0
2011-12-27 09:00:00	MSFT	Stock	25.99	26.0	25.95	25.98	23566.0
2011-12-27 09:30:00	MSFT	Stock	26.0	26.11	25.93	26.08	3052412.0
2011-12-27 10:00:00	MSFT	Stock	26.08	26.13	26.02	26.065	1767469.0
2011-12-27 10:30:00	MSFT	Stock	26.07	26.09	26.04	26.041	1160649.0
2011-12-27 11:00:00	MSFT	Stock	26.04	26.09	26.04	26.06	914682.0
2011-12-27 11:30:00	MSFT	Stock	26.05	26.07	26.05	26.05	703596.0
2011-12-27 12:00:00	MSFT	Stock	26.06	26.1	26.05	26.094	948467.0
2011-12-27 12:30:00	MSFT	Stock	26.095	26.12	26.06	26.078	1123867.0
2011-12-27 13:00:00	MSFT	Stock	26.07	26.1	26.06	26.07	676271.0
2011-12-27 13:30:00	MSFT	Stock	26.075	26.14	26.06	26.1	1153366.0
2011-12-27 14:00:00	MSFT	Stock	26.1	26.11	26.07	26.08	817872.0
2011-12-27 14:30:00	MSFT	Stock	26.085	26.09	26.06	26.075	882530.0
2011-12-27 15:00:00	MSFT	Stock	26.08	26.09	26.06	26.075	1046773.0
2011-12-27 15:30:00	MSFT	Stock	26.073	26.08	26.02	26.03	3688507.0
2011-12-27 16:00:00	MSFT	Stock	26.04	26.074	25.929	26.059	3045125.0
2011-12-27 16:30:00	MSFT	Stock	26.09	26.09	25.965	26.05	17945.0
2011-12-27 17:00:00	MSFT	Stock	26.04	26.04	26.04	26.04	4100.0
2011-12-27 17:30:00	MSFT	Stock	26.0	26.0	26.0	26.0	300.0
2011-12-27 18:00:00	MSFT	Stock	26.04	26.04	26.04	26.04	13454.0

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

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