PREVIEW / stock_30min / 2012-07-25

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-25.parquet
  size:    1.4 MB
  rows:    73,022
  symbols: 3,477

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-07-25 04:00:00	AAPL	Stock	20.3214	20.4107	20.2796	20.4089	384300.0
2012-07-25 04:30:00	AAPL	Stock	20.4179	20.4429	20.4179	20.4429	119000.0
2012-07-25 05:00:00	AAPL	Stock	20.4607	20.4643	20.4589	20.4607	59752.0
2012-07-25 05:30:00	AAPL	Stock	20.4571	20.4786	20.4304	20.4307	109200.0
2012-07-25 06:00:00	AAPL	Stock	20.4357	20.4643	20.4286	20.4286	134512.0
2012-07-25 06:30:00	AAPL	Stock	20.4318	20.4643	20.4196	20.4357	340508.0
2012-07-25 07:00:00	AAPL	Stock	20.4289	20.4954	20.3429	20.4861	1304072.0
2012-07-25 07:30:00	AAPL	Stock	20.4861	20.5714	20.4643	20.4821	4604516.0
2012-07-25 08:00:00	AAPL	Stock	20.5404	20.5464	20.4329	20.4464	5948292.0
2012-07-25 08:30:00	AAPL	Stock	20.4464	20.5179	20.4464	20.5011	6513808.0
2012-07-25 09:00:00	AAPL	Stock	20.5021	20.5393	20.4289	20.5307	10077256.0
2012-07-25 09:30:00	AAPL	Stock	20.5293	20.7429	20.3754	20.5	278661348.0
2012-07-25 10:00:00	AAPL	Stock	20.5018	20.5429	20.4118	20.4218	88831148.0
2012-07-25 10:30:00	AAPL	Stock	20.4225	20.4443	20.3596	20.372	64883196.0
2012-07-25 11:00:00	AAPL	Stock	20.3711	20.495	20.3571	20.4286	51664396.0
2012-07-25 11:30:00	AAPL	Stock	20.4289	20.5	20.4229	20.4721	35479332.0
2012-07-25 12:00:00	AAPL	Stock	20.4686	20.5118	20.4407	20.4752	28432936.0
2012-07-25 12:30:00	AAPL	Stock	20.4725	20.5714	20.4643	20.538	26171068.0
2012-07-25 13:00:00	AAPL	Stock	20.5382	20.6529	20.5264	20.6361	37470020.0
2012-07-25 13:30:00	AAPL	Stock	20.6354	20.7139	20.6071	20.6868	44009224.0
2012-07-25 14:00:00	AAPL	Stock	20.6896	20.6943	20.6139	20.6707	34379940.0
2012-07-25 14:30:00	AAPL	Stock	20.6725	20.7143	20.6196	20.6254	27503420.0
2012-07-25 15:00:00	AAPL	Stock	20.6214	20.6646	20.5471	20.5854	33255796.0
2012-07-25 15:30:00	AAPL	Stock	20.5837	20.5854	20.5129	20.5346	65360176.0
2012-07-25 16:00:00	AAPL	Stock	20.5346	20.5575	20.5232	20.5571	7111636.0
2012-07-25 16:30:00	AAPL	Stock	20.5571	20.595	20.5314	20.5464	355740.0
2012-07-25 17:00:00	AAPL	Stock	20.5375	20.5457	20.5311	20.5357	98616.0
2012-07-25 17:30:00	AAPL	Stock	20.5357	20.5389	20.5321	20.5321	34636.0
2012-07-25 18:00:00	AAPL	Stock	20.5357	20.5389	20.5268	20.5357	70084.0
2012-07-25 18:30:00	AAPL	Stock	20.5396	20.5629	20.5357	20.5621	102984.0
2012-07-25 19:00:00	AAPL	Stock	20.5639	20.5643	20.5464	20.5639	53172.0
2012-07-25 19:30:00	AAPL	Stock	20.5543	20.5636	20.5407	20.5464	144452.0
2012-07-25 07:00:00	MSFT	Stock	29.13	29.13	29.13	29.13	142.0
2012-07-25 07:30:00	MSFT	Stock	29.16	29.16	29.16	29.16	100.0
2012-07-25 08:00:00	MSFT	Stock	29.07	29.17	29.07	29.17	10548.0
2012-07-25 08:30:00	MSFT	Stock	29.19	29.26	29.15	29.26	9222.0
2012-07-25 09:00:00	MSFT	Stock	29.26	29.29	29.24	29.24	14871.0
2012-07-25 09:30:00	MSFT	Stock	29.25	29.33	29.07	29.28	5844502.0
2012-07-25 10:00:00	MSFT	Stock	29.28	29.3	29.13	29.185	3479092.0
2012-07-25 10:30:00	MSFT	Stock	29.18	29.19	28.98	29.02	3537600.0
2012-07-25 11:00:00	MSFT	Stock	29.02	29.22	29.01	29.06	2436245.0
2012-07-25 11:30:00	MSFT	Stock	29.05	29.13	29.03	29.085	2368724.0
2012-07-25 12:00:00	MSFT	Stock	29.085	29.12	29.03	29.04	2401389.0
2012-07-25 12:30:00	MSFT	Stock	29.05	29.06	29.01	29.015	1687001.0
2012-07-25 13:00:00	MSFT	Stock	29.02	29.12	29.01	29.1	1690320.0
2012-07-25 13:30:00	MSFT	Stock	29.095	29.12	29.02	29.08	2653206.0
2012-07-25 14:00:00	MSFT	Stock	29.09	29.09	29.02	29.06	1979838.0
2012-07-25 14:30:00	MSFT	Stock	29.06	29.07	29.0	29.04	3438173.0
2012-07-25 15:00:00	MSFT	Stock	29.03	29.04	28.86	28.94	3473026.0
2012-07-25 15:30:00	MSFT	Stock	28.94	28.94	28.78	28.84	7828010.0

> showing 50 of 73,022 rows — these rows as CSV

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