PREVIEW / stock_30min / 2012-06-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-12.parquet
  size:    1.4 MB
  rows:    74,069
  symbols: 3,512

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-12 04:30:00	AAPL	Stock	20.4311	20.4582	20.4311	20.4582	5600.0
2012-06-12 05:30:00	AAPL	Stock	20.4586	20.4854	20.4586	20.4854	8400.0
2012-06-12 06:00:00	AAPL	Stock	20.5139	20.5264	20.5139	20.5264	28000.0
2012-06-12 06:30:00	AAPL	Stock	20.4914	20.4914	20.4904	20.4904	5600.0
2012-06-12 07:00:00	AAPL	Stock	20.4582	20.4925	20.4375	20.4761	283808.0
2012-06-12 07:30:00	AAPL	Stock	20.4643	20.5325	20.4611	20.4896	500360.0
2012-06-12 08:00:00	AAPL	Stock	20.5	20.5229	20.4518	20.4846	1148728.0
2012-06-12 08:30:00	AAPL	Stock	20.4839	20.505	20.4643	20.4646	946036.0
2012-06-12 09:00:00	AAPL	Stock	20.4725	20.5536	20.4654	20.5179	2573004.0
2012-06-12 09:30:00	AAPL	Stock	20.5179	20.5311	20.3986	20.4252	65178064.0
2012-06-12 10:00:00	AAPL	Stock	20.4214	20.4375	20.2393	20.3118	64243144.0
2012-06-12 10:30:00	AAPL	Stock	20.3058	20.4213	20.2607	20.3646	31544268.0
2012-06-12 11:00:00	AAPL	Stock	20.3637	20.5936	20.3571	20.575	48128892.0
2012-06-12 11:30:00	AAPL	Stock	20.575	20.5907	20.5043	20.5417	29188152.0
2012-06-12 12:00:00	AAPL	Stock	20.5429	20.5786	20.5175	20.5329	16563876.0
2012-06-12 12:30:00	AAPL	Stock	20.5333	20.5507	20.3846	20.4393	28216020.0
2012-06-12 13:00:00	AAPL	Stock	20.4396	20.5225	20.4236	20.4408	19396692.0
2012-06-12 13:30:00	AAPL	Stock	20.4407	20.5054	20.4164	20.4368	15588804.0
2012-06-12 14:00:00	AAPL	Stock	20.4378	20.4675	20.4207	20.4339	12471032.0
2012-06-12 14:30:00	AAPL	Stock	20.4371	20.5114	20.4343	20.4673	18671772.0
2012-06-12 15:00:00	AAPL	Stock	20.4702	20.5107	20.4321	20.4968	17781456.0
2012-06-12 15:30:00	AAPL	Stock	20.4886	20.5768	20.4643	20.5768	44904132.0
2012-06-12 16:00:00	AAPL	Stock	20.5764	20.5893	20.4569	20.5893	9004296.0
2012-06-12 16:30:00	AAPL	Stock	20.5893	20.5893	20.389	20.5825	320824.0
2012-06-12 17:00:00	AAPL	Stock	20.5804	20.5804	20.5771	20.5789	382088.0
2012-06-12 17:30:00	AAPL	Stock	20.5807	20.5954	20.5807	20.5929	73192.0
2012-06-12 18:00:00	AAPL	Stock	20.5936	20.6029	20.5918	20.5979	129080.0
2012-06-12 18:30:00	AAPL	Stock	20.5971	20.6036	20.5946	20.6036	51240.0
2012-06-12 19:00:00	AAPL	Stock	20.6039	20.6071	20.6021	20.6036	55272.0
2012-06-12 19:30:00	AAPL	Stock	20.6064	20.615	20.6054	20.6107	110740.0
2012-06-12 04:00:00	MSFT	Stock	28.96	28.96	28.96	28.96	100.0
2012-06-12 04:30:00	MSFT	Stock	29.02	29.02	29.02	29.02	1000.0
2012-06-12 07:00:00	MSFT	Stock	29.02	29.02	29.02	29.02	988.0
2012-06-12 07:30:00	MSFT	Stock	28.95	29.02	28.95	29.02	800.0
2012-06-12 08:00:00	MSFT	Stock	29.02	29.07	29.0	29.05	44150.0
2012-06-12 08:30:00	MSFT	Stock	29.06	29.06	29.03	29.03	39400.0
2012-06-12 09:00:00	MSFT	Stock	29.06	29.12	29.04	29.09	7880.0
2012-06-12 09:30:00	MSFT	Stock	29.11	29.14	28.98	29.04	4482475.0
2012-06-12 10:00:00	MSFT	Stock	29.05	29.078	28.84	28.94	3888797.0
2012-06-12 10:30:00	MSFT	Stock	28.94	29.05	28.88	29.04	2195486.0
2012-06-12 11:00:00	MSFT	Stock	29.04	29.2	29.03	29.18	3456528.0
2012-06-12 11:30:00	MSFT	Stock	29.19	29.23	29.15	29.185	1850556.0
2012-06-12 12:00:00	MSFT	Stock	29.18	29.25	29.15	29.17	1479586.0
2012-06-12 12:30:00	MSFT	Stock	29.16	29.19	29.11	29.128	1432232.0
2012-06-12 13:00:00	MSFT	Stock	29.13	29.23	29.12	29.162	1662613.0
2012-06-12 13:30:00	MSFT	Stock	29.162	29.18	29.105	29.13	1831568.0
2012-06-12 14:00:00	MSFT	Stock	29.12	29.16	29.1	29.14	1431375.0
2012-06-12 14:30:00	MSFT	Stock	29.13	29.23	29.13	29.185	1654635.0
2012-06-12 15:00:00	MSFT	Stock	29.185	29.22	29.14	29.2	1632464.0
2012-06-12 15:30:00	MSFT	Stock	29.21	29.3	29.18	29.3	4957148.0

> showing 50 of 74,069 rows — these rows as CSV

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