PREVIEW / stock_5min / 2012-08-01

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-08-01.parquet
  size:    4.7 MB
  rows:    314,663
  symbols: 3,459

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-01 04:00:00	AAPL	Stock	21.8571	21.8929	21.8571	21.8929	11200.0
2012-08-01 04:05:00	AAPL	Stock	21.9107	21.9107	21.9107	21.9107	8400.0
2012-08-01 04:10:00	AAPL	Stock	21.9286	21.9286	21.9286	21.9286	11200.0
2012-08-01 04:15:00	AAPL	Stock	21.9286	21.9286	21.9286	21.9286	14000.0
2012-08-01 04:35:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	2800.0
2012-08-01 04:40:00	AAPL	Stock	21.8839	21.8839	21.8839	21.8839	5600.0
2012-08-01 04:45:00	AAPL	Stock	21.8839	21.8839	21.8839	21.8839	5600.0
2012-08-01 05:15:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	25200.0
2012-08-01 05:40:00	AAPL	Stock	21.875	21.875	21.875	21.875	5600.0
2012-08-01 06:25:00	AAPL	Stock	21.875	21.8929	21.875	21.8929	17416.0
2012-08-01 06:30:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	8400.0
2012-08-01 06:35:00	AAPL	Stock	21.9018	21.9036	21.9018	21.9036	8316.0
2012-08-01 06:40:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	2800.0
2012-08-01 07:00:00	AAPL	Stock	21.8786	21.9071	21.8786	21.9025	178920.0
2012-08-01 07:05:00	AAPL	Stock	21.9039	21.9286	21.9036	21.9143	222656.0
2012-08-01 07:10:00	AAPL	Stock	21.9107	21.9232	21.9107	21.9111	122416.0
2012-08-01 07:15:00	AAPL	Stock	21.9129	21.9518	21.9129	21.95	122948.0
2012-08-01 07:20:00	AAPL	Stock	21.9525	21.9604	21.9307	21.9307	151424.0
2012-08-01 07:25:00	AAPL	Stock	21.9332	21.9454	21.9286	21.9286	162092.0
2012-08-01 07:30:00	AAPL	Stock	21.9289	21.9343	21.9286	21.9343	24360.0
2012-08-01 07:35:00	AAPL	Stock	21.9361	21.9464	21.9361	21.9464	33740.0
2012-08-01 07:40:00	AAPL	Stock	21.9546	21.9554	21.9464	21.95	22400.0
2012-08-01 07:45:00	AAPL	Stock	21.95	21.9507	21.9032	21.9032	60228.0
2012-08-01 07:50:00	AAPL	Stock	21.9286	21.9486	21.9286	21.9486	44548.0
2012-08-01 07:55:00	AAPL	Stock	21.9407	21.9571	21.9407	21.9571	125412.0
2012-08-01 08:00:00	AAPL	Stock	21.9464	21.9554	21.9375	21.9543	474712.0
2012-08-01 08:05:00	AAPL	Stock	21.9468	21.9589	21.9464	21.9464	172452.0
2012-08-01 08:10:00	AAPL	Stock	21.9518	21.9568	21.8129	21.955	295176.0
2012-08-01 08:15:00	AAPL	Stock	21.9557	21.9729	21.9554	21.9682	698656.0
2012-08-01 08:20:00	AAPL	Stock	21.9679	22.0064	21.9643	22.0061	907060.0
2012-08-01 08:25:00	AAPL	Stock	22.0036	22.0129	21.9929	22.0111	624260.0
2012-08-01 08:30:00	AAPL	Stock	22.0111	22.0225	22.0096	22.0164	390152.0
2012-08-01 08:35:00	AAPL	Stock	22.0186	22.0186	22.0018	22.0046	252560.0
2012-08-01 08:40:00	AAPL	Stock	22.0014	22.0286	22.0014	22.0264	214144.0
2012-08-01 08:45:00	AAPL	Stock	22.0304	22.0443	22.0243	22.0411	498960.0
2012-08-01 08:50:00	AAPL	Stock	22.0393	22.0471	22.0304	22.0429	587916.0
2012-08-01 08:55:00	AAPL	Stock	22.0379	22.0475	22.0368	22.04	220612.0
2012-08-01 09:00:00	AAPL	Stock	22.0396	22.0396	22.0286	22.0364	293440.0
2012-08-01 09:05:00	AAPL	Stock	22.0364	22.0607	22.0357	22.0546	337484.0
2012-08-01 09:10:00	AAPL	Stock	22.0607	22.0643	22.0232	22.0286	765828.0
2012-08-01 09:15:00	AAPL	Stock	22.0286	22.0357	22.0179	22.0211	316344.0
2012-08-01 09:20:00	AAPL	Stock	22.0214	22.0268	22.0179	22.0221	246680.0
2012-08-01 09:25:00	AAPL	Stock	22.0218	22.03	21.9832	21.9946	1007944.0
2012-08-01 09:30:00	AAPL	Stock	21.9966	22.0143	21.9334	21.9542	16058308.0
2012-08-01 09:35:00	AAPL	Stock	21.9511	21.9529	21.8886	21.9093	12023312.0
2012-08-01 09:40:00	AAPL	Stock	21.9107	21.9461	21.9057	21.925	7936572.0
2012-08-01 09:45:00	AAPL	Stock	21.9236	21.9286	21.825	21.8518	10783640.0
2012-08-01 09:50:00	AAPL	Stock	21.8498	21.8754	21.8393	21.845	6894356.0
2012-08-01 09:55:00	AAPL	Stock	21.8507	21.8846	21.81	21.8239	8765456.0
2012-08-01 10:00:00	AAPL	Stock	21.8214	21.8614	21.8129	21.8384	6411160.0

> showing 50 of 314,663 rows — these rows as CSV

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