PREVIEW / stock_30min / 2012-04-02

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-02.parquet
  size:    1.5 MB
  rows:    78,108
  symbols: 3,533

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-04-02 04:00:00	AAPL	Stock	21.5	21.6071	21.5	21.5807	80920.0
2012-04-02 04:30:00	AAPL	Stock	21.5361	21.5393	21.5	21.5393	33320.0
2012-04-02 05:00:00	AAPL	Stock	21.5393	21.5393	21.49	21.4939	56280.0
2012-04-02 05:30:00	AAPL	Stock	21.5057	21.5179	21.5057	21.5071	33600.0
2012-04-02 06:00:00	AAPL	Stock	21.5143	21.5143	21.5143	21.5143	2800.0
2012-04-02 06:30:00	AAPL	Stock	21.5071	21.5075	21.5	21.5	30800.0
2012-04-02 07:00:00	AAPL	Stock	21.5107	21.5143	21.4443	21.4443	315112.0
2012-04-02 07:30:00	AAPL	Stock	21.4464	21.4614	21.3661	21.3786	480200.0
2012-04-02 08:00:00	AAPL	Stock	21.3911	21.4643	21.3125	21.375	2090200.0
2012-04-02 08:30:00	AAPL	Stock	21.38	21.5093	21.3761	21.4907	3688048.0
2012-04-02 09:00:00	AAPL	Stock	21.4907	21.5089	21.4096	21.4993	3434340.0
2012-04-02 09:30:00	AAPL	Stock	21.4939	21.7604	21.4421	21.6796	115769108.0
2012-04-02 10:00:00	AAPL	Stock	21.6793	21.8482	21.6779	21.8079	71810788.0
2012-04-02 10:30:00	AAPL	Stock	21.8082	21.8282	21.7361	21.8064	45881024.0
2012-04-02 11:00:00	AAPL	Stock	21.8064	21.9046	21.8026	21.9018	42717584.0
2012-04-02 11:30:00	AAPL	Stock	21.9014	21.9429	21.8796	21.9196	35500024.0
2012-04-02 12:00:00	AAPL	Stock	21.9196	21.9621	21.9107	21.9343	36154664.0
2012-04-02 12:30:00	AAPL	Stock	21.9357	21.9786	21.92	21.9679	23363620.0
2012-04-02 13:00:00	AAPL	Stock	21.9668	21.9725	21.9396	21.9679	14701960.0
2012-04-02 13:30:00	AAPL	Stock	21.9696	22.0029	21.9679	22.0004	22925056.0
2012-04-02 14:00:00	AAPL	Stock	21.9981	22.0232	21.9844	22.0106	19513396.0
2012-04-02 14:30:00	AAPL	Stock	22.01	22.0175	21.9571	22.0011	27501824.0
2012-04-02 15:00:00	AAPL	Stock	22.0032	22.0514	21.9825	22.0346	30237508.0
2012-04-02 15:30:00	AAPL	Stock	22.0338	22.0989	22.0179	22.0957	80036572.0
2012-04-02 16:00:00	AAPL	Stock	22.0893	22.1032	21.4096	22.1032	5049268.0
2012-04-02 16:30:00	AAPL	Stock	22.1029	22.1036	22.0427	22.0871	1321684.0
2012-04-02 17:00:00	AAPL	Stock	22.0861	22.0914	22.0779	22.0843	264376.0
2012-04-02 17:30:00	AAPL	Stock	22.085	22.0925	22.0843	22.0875	119364.0
2012-04-02 18:00:00	AAPL	Stock	22.0875	22.0986	22.0839	22.0954	435596.0
2012-04-02 18:30:00	AAPL	Stock	22.0896	22.1089	22.0896	22.1025	656880.0
2012-04-02 19:00:00	AAPL	Stock	22.1014	22.125	22.1014	22.125	356104.0
2012-04-02 19:30:00	AAPL	Stock	22.125	22.1382	22.1071	22.1075	409752.0
2012-04-02 04:00:00	MSFT	Stock	32.26	32.26	32.26	32.26	4000.0
2012-04-02 07:00:00	MSFT	Stock	32.15	32.23	32.15	32.23	1400.0
2012-04-02 08:00:00	MSFT	Stock	32.33	32.33	32.16	32.25	12113.0
2012-04-02 08:30:00	MSFT	Stock	32.2	32.25	32.2	32.25	1600.0
2012-04-02 09:00:00	MSFT	Stock	32.24	32.24	32.15	32.17	8700.0
2012-04-02 09:30:00	MSFT	Stock	32.22	32.24	31.95	31.989	4519210.0
2012-04-02 10:00:00	MSFT	Stock	31.98	32.215	31.97	32.18	3408039.0
2012-04-02 10:30:00	MSFT	Stock	32.18	32.21	32.11	32.171	2248170.0
2012-04-02 11:00:00	MSFT	Stock	32.17	32.33	32.145	32.255	2854488.0
2012-04-02 11:30:00	MSFT	Stock	32.25	32.4	32.24	32.385	1062258.0
2012-04-02 12:00:00	MSFT	Stock	32.385	32.44	32.37	32.39	1774450.0
2012-04-02 12:30:00	MSFT	Stock	32.4	32.46	32.37	32.42	1140932.0
2012-04-02 13:00:00	MSFT	Stock	32.41	32.417	32.34	32.395	1591652.0
2012-04-02 13:30:00	MSFT	Stock	32.395	32.45	32.392	32.42	1011185.0
2012-04-02 14:00:00	MSFT	Stock	32.42	32.44	32.38	32.415	1309750.0
2012-04-02 14:30:00	MSFT	Stock	32.413	32.45	32.34	32.38	1927705.0
2012-04-02 15:00:00	MSFT	Stock	32.38	32.39	32.3	32.34	2143683.0
2012-04-02 15:30:00	MSFT	Stock	32.33	32.35	32.26	32.28	6115465.0

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

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