PREVIEW / stock_30min / 2011-01-06

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-06.parquet
  size:    1.4 MB
  rows:    74,717
  symbols: 3,520

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-01-06 05:00:00	AAPL	Stock	11.9968	11.9968	11.9661	11.9857	19600.0
2011-01-06 05:30:00	AAPL	Stock	11.9786	11.9989	11.9786	11.9989	11200.0
2011-01-06 06:00:00	AAPL	Stock	12.0025	12.0025	12.0025	12.0025	3640.0
2011-01-06 06:30:00	AAPL	Stock	12.0279	12.0321	11.9532	12.0036	70280.0
2011-01-06 07:00:00	AAPL	Stock	12.0089	12.0107	11.9971	11.9971	88200.0
2011-01-06 07:30:00	AAPL	Stock	12.0043	12.0071	11.985	11.9871	137340.0
2011-01-06 08:00:00	AAPL	Stock	11.9821	12.0168	11.9821	11.9964	955948.0
2011-01-06 08:30:00	AAPL	Stock	12.0	12.0054	11.9286	11.9836	1032612.0
2011-01-06 09:00:00	AAPL	Stock	11.9796	11.9854	11.9525	11.9632	1765736.0
2011-01-06 09:30:00	AAPL	Stock	11.9632	11.9725	11.9129	11.9464	42214228.0
2011-01-06 10:00:00	AAPL	Stock	11.9464	11.9707	11.9457	11.9639	24284484.0
2011-01-06 10:30:00	AAPL	Stock	11.9639	11.9732	11.9375	11.9489	19473552.0
2011-01-06 11:00:00	AAPL	Stock	11.9486	11.9636	11.925	11.961	25386116.0
2011-01-06 11:30:00	AAPL	Stock	11.9593	11.9614	11.9373	11.9418	14108416.0
2011-01-06 12:00:00	AAPL	Stock	11.9418	11.9479	11.9375	11.9407	8503264.0
2011-01-06 12:30:00	AAPL	Stock	11.9404	11.9454	11.9261	11.9304	13159664.0
2011-01-06 13:00:00	AAPL	Stock	11.9293	11.935	11.9179	11.9318	11280472.0
2011-01-06 13:30:00	AAPL	Stock	11.9318	11.9457	11.925	11.9439	13636588.0
2011-01-06 14:00:00	AAPL	Stock	11.9439	11.9489	11.9286	11.9314	10776164.0
2011-01-06 14:30:00	AAPL	Stock	11.9314	11.9325	11.8893	11.9075	20766956.0
2011-01-06 15:00:00	AAPL	Stock	11.9075	11.9357	11.8893	11.9036	25295172.0
2011-01-06 15:30:00	AAPL	Stock	11.9036	11.9304	11.8975	11.9161	25269888.0
2011-01-06 16:00:00	AAPL	Stock	11.9189	11.9354	11.9143	11.9232	32510576.0
2011-01-06 16:30:00	AAPL	Stock	11.9214	11.9286	11.9044	11.9154	242032.0
2011-01-06 17:00:00	AAPL	Stock	11.9154	11.9214	11.9154	11.9214	19544.0
2011-01-06 17:30:00	AAPL	Stock	11.9196	11.9214	11.9168	11.9214	11200.0
2011-01-06 18:00:00	AAPL	Stock	11.9171	11.9293	11.9143	11.915	41496.0
2011-01-06 18:30:00	AAPL	Stock	11.915	11.915	11.9121	11.9125	236768.0
2011-01-06 19:00:00	AAPL	Stock	11.9129	11.9196	11.9125	11.9143	46284.0
2011-01-06 19:30:00	AAPL	Stock	11.9143	11.9189	11.9061	11.9125	255696.0
2011-01-06 04:00:00	MSFT	Stock	28.12	28.12	28.12	28.12	100.0
2011-01-06 04:30:00	MSFT	Stock	28.12	28.12	28.12	28.12	200.0
2011-01-06 07:00:00	MSFT	Stock	28.12	28.12	28.09	28.09	600.0
2011-01-06 07:30:00	MSFT	Stock	28.09	28.12	28.04	28.05	2100.0
2011-01-06 08:00:00	MSFT	Stock	28.03	28.13	27.45	28.09	259376.0
2011-01-06 08:30:00	MSFT	Stock	28.08	28.08	28.0	28.08	138089.0
2011-01-06 09:00:00	MSFT	Stock	28.08	28.11	28.03	28.04	198636.0
2011-01-06 09:30:00	MSFT	Stock	28.04	28.1	27.86	27.99	6635688.0
2011-01-06 10:00:00	MSFT	Stock	27.99	28.03	27.93	27.98	4583723.0
2011-01-06 10:30:00	MSFT	Stock	27.98	28.03	27.92	28.03	5343387.0
2011-01-06 11:00:00	MSFT	Stock	28.02	28.195	27.98	28.171	9554621.0
2011-01-06 11:30:00	MSFT	Stock	28.175	28.34	28.17	28.33	5284193.0
2011-01-06 12:00:00	MSFT	Stock	28.325	28.34	28.23	28.252	4377195.0
2011-01-06 12:30:00	MSFT	Stock	28.255	28.5	28.25	28.475	7567363.0
2011-01-06 13:00:00	MSFT	Stock	28.47	28.48	28.43	28.47	2780437.0
2011-01-06 13:30:00	MSFT	Stock	28.47	28.525	28.45	28.5	4945582.0
2011-01-06 14:00:00	MSFT	Stock	28.49	28.57	28.49	28.55	4852450.0
2011-01-06 14:30:00	MSFT	Stock	28.55	28.67	28.54	28.66	7354261.0
2011-01-06 15:00:00	MSFT	Stock	28.66	28.77	28.63	28.715	6613668.0
2011-01-06 15:30:00	MSFT	Stock	28.71	28.85	28.71	28.81	11944975.0

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

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