PREVIEW / stock_30min / 2013-05-08

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-08.parquet
  size:    1.5 MB
  rows:    78,533
  symbols: 3,490

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
2013-05-08 04:00:00	AAPL	Stock	16.4286	16.4286	16.4286	16.4286	2800.0
2013-05-08 05:00:00	AAPL	Stock	16.4304	16.4304	16.4304	16.4304	7728.0
2013-05-08 05:30:00	AAPL	Stock	16.4268	16.4268	16.4161	16.4161	7504.0
2013-05-08 06:00:00	AAPL	Stock	16.42	16.4429	16.42	16.4429	11200.0
2013-05-08 06:30:00	AAPL	Stock	16.4646	16.4889	16.4432	16.4432	22176.0
2013-05-08 07:00:00	AAPL	Stock	16.4182	16.4821	16.4161	16.4696	227920.0
2013-05-08 07:30:00	AAPL	Stock	16.4804	16.5132	16.4468	16.4629	520184.0
2013-05-08 08:00:00	AAPL	Stock	16.4607	16.5064	16.3571	16.4286	1111068.0
2013-05-08 08:30:00	AAPL	Stock	16.4286	16.4464	16.4118	16.4121	1046976.0
2013-05-08 09:00:00	AAPL	Stock	16.4164	16.4289	16.3929	16.3932	1370096.0
2013-05-08 09:30:00	AAPL	Stock	16.3943	16.5421	16.2789	16.535	76602232.0
2013-05-08 10:00:00	AAPL	Stock	16.5375	16.5832	16.4907	16.5818	51709672.0
2013-05-08 10:30:00	AAPL	Stock	16.5832	16.5964	16.5396	16.5507	34972672.0
2013-05-08 11:00:00	AAPL	Stock	16.5529	16.5925	16.5446	16.5725	30406656.0
2013-05-08 11:30:00	AAPL	Stock	16.5729	16.5996	16.5446	16.5877	18097744.0
2013-05-08 12:00:00	AAPL	Stock	16.5871	16.6021	16.5714	16.5975	16943976.0
2013-05-08 12:30:00	AAPL	Stock	16.5939	16.6036	16.5643	16.5996	16501072.0
2013-05-08 13:00:00	AAPL	Stock	16.5986	16.6204	16.5893	16.6014	20418076.0
2013-05-08 13:30:00	AAPL	Stock	16.6018	16.6089	16.5568	16.5768	17609844.0
2013-05-08 14:00:00	AAPL	Stock	16.5768	16.5936	16.5643	16.5732	11311412.0
2013-05-08 14:30:00	AAPL	Stock	16.5725	16.5736	16.4606	16.5246	33269600.0
2013-05-08 15:00:00	AAPL	Stock	16.525	16.5761	16.5179	16.5748	25020968.0
2013-05-08 15:30:00	AAPL	Stock	16.5757	16.5893	16.5507	16.5611	36897560.0
2013-05-08 16:00:00	AAPL	Stock	16.5582	16.5857	16.5272	16.5786	10082744.0
2013-05-08 16:30:00	AAPL	Stock	16.5786	16.5945	16.5475	16.5475	1531348.0
2013-05-08 17:00:00	AAPL	Stock	16.5479	16.5757	16.5411	16.5682	452368.0
2013-05-08 17:30:00	AAPL	Stock	16.5668	16.5786	16.5668	16.5721	109732.0
2013-05-08 18:00:00	AAPL	Stock	16.5786	16.5804	16.575	16.5804	160804.0
2013-05-08 18:30:00	AAPL	Stock	16.5786	16.5786	16.5714	16.5714	84056.0
2013-05-08 19:00:00	AAPL	Stock	16.5789	16.5893	16.5771	16.5789	111132.0
2013-05-08 19:30:00	AAPL	Stock	16.5854	16.5893	16.5821	16.5825	197036.0
2013-05-08 04:00:00	MSFT	Stock	33.18	33.18	33.18	33.18	100.0
2013-05-08 06:30:00	MSFT	Stock	33.25	33.28	33.25	33.28	700.0
2013-05-08 07:00:00	MSFT	Stock	33.26	33.26	33.26	33.26	1240.0
2013-05-08 07:30:00	MSFT	Stock	33.28	33.28	33.26	33.26	1000.0
2013-05-08 08:00:00	MSFT	Stock	33.26	33.5	33.25	33.25	10258.0
2013-05-08 08:30:00	MSFT	Stock	33.2	33.21	33.11	33.11	13254.0
2013-05-08 09:00:00	MSFT	Stock	33.14	33.17	33.05	33.08	203469.0
2013-05-08 09:30:00	MSFT	Stock	33.06	33.09	32.65	32.695	13037489.0
2013-05-08 10:00:00	MSFT	Stock	32.7	32.985	32.68	32.97	7558498.0
2013-05-08 10:30:00	MSFT	Stock	32.98	33.05	32.908	32.99	3340314.0
2013-05-08 11:00:00	MSFT	Stock	33.0	33.04	32.96	32.99	2672951.0
2013-05-08 11:30:00	MSFT	Stock	33.0	33.14	32.99	33.11	1901011.0
2013-05-08 12:00:00	MSFT	Stock	33.111	33.16	33.09	33.11	1679411.0
2013-05-08 12:30:00	MSFT	Stock	33.12	33.13	33.06	33.1	1734976.0
2013-05-08 13:00:00	MSFT	Stock	33.109	33.16	33.07	33.115	1417635.0
2013-05-08 13:30:00	MSFT	Stock	33.12	33.19	33.1	33.16	1689251.0
2013-05-08 14:00:00	MSFT	Stock	33.16	33.24	33.15	33.24	1264527.0
2013-05-08 14:30:00	MSFT	Stock	33.234	33.24	33.09	33.14	1734648.0
2013-05-08 15:00:00	MSFT	Stock	33.15	33.156	33.07	33.085	2566622.0

> showing 50 of 78,533 rows — these rows as CSV

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