PREVIEW / stock_5min / 2011-08-19

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-08-19.parquet
  size:    5.0 MB
  rows:    335,886
  symbols: 3,534

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-08-19 04:00:00	AAPL	Stock	13.1018	13.1018	12.9071	12.9071	8932.0
2011-08-19 04:15:00	AAPL	Stock	12.8396	12.8396	12.8396	12.8396	11200.0
2011-08-19 04:30:00	AAPL	Stock	12.8929	12.8929	12.8929	12.8929	14000.0
2011-08-19 04:40:00	AAPL	Stock	12.8932	12.8932	12.8932	12.8932	11200.0
2011-08-19 04:50:00	AAPL	Stock	12.9246	12.9286	12.9246	12.9286	11200.0
2011-08-19 04:55:00	AAPL	Stock	12.9286	12.9286	12.9286	12.9286	2800.0
2011-08-19 05:20:00	AAPL	Stock	12.9357	12.9357	12.9357	12.9357	2800.0
2011-08-19 05:25:00	AAPL	Stock	12.9357	12.9643	12.9357	12.9643	8400.0
2011-08-19 05:35:00	AAPL	Stock	12.9357	12.9357	12.9357	12.9357	5600.0
2011-08-19 05:45:00	AAPL	Stock	12.9357	12.9357	12.9189	12.9189	41440.0
2011-08-19 05:55:00	AAPL	Stock	12.9414	12.9414	12.9414	12.9414	4200.0
2011-08-19 06:10:00	AAPL	Stock	12.9546	12.9546	12.9546	12.9546	2800.0
2011-08-19 06:25:00	AAPL	Stock	12.9286	12.9286	12.9286	12.9286	8400.0
2011-08-19 06:35:00	AAPL	Stock	12.9146	12.9286	12.9146	12.9286	14000.0
2011-08-19 06:40:00	AAPL	Stock	12.9279	12.9279	12.9279	12.9279	2800.0
2011-08-19 06:45:00	AAPL	Stock	12.9107	12.9107	12.9107	12.9107	5600.0
2011-08-19 06:55:00	AAPL	Stock	12.8929	12.9246	12.8929	12.9032	22512.0
2011-08-19 07:00:00	AAPL	Stock	12.9286	12.9607	12.9286	12.9379	115416.0
2011-08-19 07:05:00	AAPL	Stock	12.9321	12.9446	12.9286	12.9386	105700.0
2011-08-19 07:10:00	AAPL	Stock	12.9464	12.9593	12.9393	12.9468	61880.0
2011-08-19 07:15:00	AAPL	Stock	12.9464	12.9607	12.9464	12.9546	72576.0
2011-08-19 07:20:00	AAPL	Stock	12.9546	12.9546	12.9414	12.95	61320.0
2011-08-19 07:25:00	AAPL	Stock	12.95	12.9546	12.9468	12.95	51016.0
2011-08-19 07:30:00	AAPL	Stock	12.9564	12.9654	12.9564	12.9643	123088.0
2011-08-19 07:35:00	AAPL	Stock	12.9714	12.9882	12.9714	12.9768	42000.0
2011-08-19 07:40:00	AAPL	Stock	12.9768	13.0179	12.9768	13.0179	77000.0
2011-08-19 07:45:00	AAPL	Stock	13.0068	13.0068	13.0068	13.0068	2800.0
2011-08-19 07:50:00	AAPL	Stock	13.0	13.0232	13.0	13.0032	86352.0
2011-08-19 07:55:00	AAPL	Stock	13.0107	13.0329	13.0107	13.0268	137620.0
2011-08-19 08:00:00	AAPL	Stock	13.0039	13.0536	12.9643	13.0536	643468.0
2011-08-19 08:05:00	AAPL	Stock	13.05	13.0604	13.0179	13.0357	697676.0
2011-08-19 08:10:00	AAPL	Stock	13.0321	13.05	13.0271	13.0357	216804.0
2011-08-19 08:15:00	AAPL	Stock	13.0393	13.0425	13.0225	13.0225	438228.0
2011-08-19 08:20:00	AAPL	Stock	13.0204	13.0286	13.0071	13.0168	458388.0
2011-08-19 08:25:00	AAPL	Stock	13.0171	13.0229	13.0082	13.0143	132916.0
2011-08-19 08:30:00	AAPL	Stock	13.0182	13.0218	13.0	13.0	161812.0
2011-08-19 08:35:00	AAPL	Stock	13.0	13.0082	12.9893	12.9914	218288.0
2011-08-19 08:40:00	AAPL	Stock	12.9914	12.9914	12.955	12.9632	389844.0
2011-08-19 08:45:00	AAPL	Stock	12.9564	12.9664	12.9343	12.9529	919520.0
2011-08-19 08:50:00	AAPL	Stock	12.9529	12.9643	12.9446	12.9607	249200.0
2011-08-19 08:55:00	AAPL	Stock	12.9571	12.9654	12.9464	12.9489	352576.0
2011-08-19 09:00:00	AAPL	Stock	12.9504	12.9511	12.9432	12.9486	167160.0
2011-08-19 09:05:00	AAPL	Stock	12.9468	12.9514	12.9325	12.9393	457464.0
2011-08-19 09:10:00	AAPL	Stock	12.9386	12.9639	12.9325	12.9539	402360.0
2011-08-19 09:15:00	AAPL	Stock	12.9518	12.9546	12.9464	12.9464	86940.0
2011-08-19 09:20:00	AAPL	Stock	12.9429	12.9511	12.9214	12.9464	578984.0
2011-08-19 09:25:00	AAPL	Stock	12.9504	12.9525	12.9054	12.9204	1755096.0
2011-08-19 09:30:00	AAPL	Stock	12.9346	12.9896	12.9111	12.9595	54221636.0
2011-08-19 09:35:00	AAPL	Stock	12.9536	13.0175	12.9485	13.0007	22386084.0
2011-08-19 09:40:00	AAPL	Stock	13.0004	13.0939	12.9925	13.0114	20859580.0

> showing 50 of 335,886 rows — these rows as CSV

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