PREVIEW / stock_30min / 2012-08-15

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-15.parquet
  size:    1.4 MB
  rows:    72,445
  symbols: 3,468

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-08-15 04:00:00	AAPL	Stock	22.5357	22.5468	22.5357	22.5464	28000.0
2012-08-15 04:30:00	AAPL	Stock	22.5786	22.5786	22.5786	22.5786	2800.0
2012-08-15 05:00:00	AAPL	Stock	22.6071	22.6071	22.6071	22.6071	2800.0
2012-08-15 05:30:00	AAPL	Stock	22.6071	22.6107	22.5893	22.5893	40516.0
2012-08-15 06:00:00	AAPL	Stock	22.5786	22.5786	22.5393	22.5393	16800.0
2012-08-15 06:30:00	AAPL	Stock	22.5464	22.5714	22.5464	22.5714	8988.0
2012-08-15 07:00:00	AAPL	Stock	22.5711	22.5714	22.5196	22.5429	65800.0
2012-08-15 07:30:00	AAPL	Stock	22.5493	22.5614	22.5071	22.5439	403928.0
2012-08-15 08:00:00	AAPL	Stock	22.5475	22.6229	22.5264	22.6014	609924.0
2012-08-15 08:30:00	AAPL	Stock	22.6	22.6229	22.5732	22.6068	806540.0
2012-08-15 09:00:00	AAPL	Stock	22.6093	22.6179	22.5475	22.56	1426684.0
2012-08-15 09:30:00	AAPL	Stock	22.5468	22.6429	22.5203	22.6068	48346256.0
2012-08-15 10:00:00	AAPL	Stock	22.6121	22.6175	22.5451	22.5843	20587364.0
2012-08-15 10:30:00	AAPL	Stock	22.5832	22.5929	22.5196	22.5829	17729712.0
2012-08-15 11:00:00	AAPL	Stock	22.5828	22.6243	22.5643	22.5654	14936628.0
2012-08-15 11:30:00	AAPL	Stock	22.5646	22.585	22.5554	22.5846	7043596.0
2012-08-15 12:00:00	AAPL	Stock	22.5821	22.6021	22.5536	22.5593	8747676.0
2012-08-15 12:30:00	AAPL	Stock	22.5593	22.5711	22.5379	22.5446	5751284.0
2012-08-15 13:00:00	AAPL	Stock	22.545	22.5459	22.4646	22.4716	21444948.0
2012-08-15 13:30:00	AAPL	Stock	22.4711	22.4985	22.4393	22.4435	15383564.0
2012-08-15 14:00:00	AAPL	Stock	22.4426	22.4879	22.4196	22.4786	17974936.0
2012-08-15 14:30:00	AAPL	Stock	22.4754	22.4971	22.4579	22.4946	10435096.0
2012-08-15 15:00:00	AAPL	Stock	22.4946	22.5475	22.4907	22.515	18027436.0
2012-08-15 15:30:00	AAPL	Stock	22.5139	22.5457	22.5032	22.5225	21372512.0
2012-08-15 16:00:00	AAPL	Stock	22.5282	22.5727	22.4917	22.5371	15950032.0
2012-08-15 16:30:00	AAPL	Stock	22.5371	22.5464	22.525	22.5429	214508.0
2012-08-15 17:00:00	AAPL	Stock	22.5375	22.5489	22.5321	22.5489	143584.0
2012-08-15 17:30:00	AAPL	Stock	22.5361	22.5464	22.5339	22.5461	22400.0
2012-08-15 18:00:00	AAPL	Stock	22.5457	22.5521	22.5457	22.5518	65576.0
2012-08-15 18:30:00	AAPL	Stock	22.5518	22.5589	22.5482	22.55	25508.0
2012-08-15 19:00:00	AAPL	Stock	22.5496	22.5521	22.5446	22.5521	76272.0
2012-08-15 19:30:00	AAPL	Stock	22.5482	22.5536	22.5464	22.5536	58632.0
2012-08-15 08:00:00	MSFT	Stock	30.09	30.09	30.0	30.0	5736.0
2012-08-15 08:30:00	MSFT	Stock	30.08	30.08	30.08	30.08	154.0
2012-08-15 09:00:00	MSFT	Stock	30.05	30.06	30.05	30.05	8100.0
2012-08-15 09:30:00	MSFT	Stock	30.11	30.28	30.02	30.24	2516462.0
2012-08-15 10:00:00	MSFT	Stock	30.24	30.27	30.15	30.165	1925172.0
2012-08-15 10:30:00	MSFT	Stock	30.17	30.18	30.12	30.16	1714356.0
2012-08-15 11:00:00	MSFT	Stock	30.163	30.2	30.124	30.133	1690634.0
2012-08-15 11:30:00	MSFT	Stock	30.13	30.18	30.13	30.18	1030346.0
2012-08-15 12:00:00	MSFT	Stock	30.17	30.19	30.15	30.165	881891.0
2012-08-15 12:30:00	MSFT	Stock	30.17	30.17	30.14	30.145	683005.0
2012-08-15 13:00:00	MSFT	Stock	30.15	30.15	30.12	30.139	694879.0
2012-08-15 13:30:00	MSFT	Stock	30.13	30.14	30.08	30.12	1937276.0
2012-08-15 14:00:00	MSFT	Stock	30.115	30.13	30.09	30.1	1469528.0
2012-08-15 14:30:00	MSFT	Stock	30.11	30.13	30.08	30.11	2045844.0
2012-08-15 15:00:00	MSFT	Stock	30.115	30.175	30.11	30.16	2413287.0
2012-08-15 15:30:00	MSFT	Stock	30.16	30.25	30.13	30.19	4122491.0
2012-08-15 16:00:00	MSFT	Stock	30.2	30.27	30.14	30.2	1008068.0
2012-08-15 16:30:00	MSFT	Stock	30.24	30.29	30.24	30.28	7674.0

> showing 50 of 72,445 rows — these rows as CSV

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