PREVIEW / stock_5min / 2013-07-24

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-24.parquet
  size:    5.2 MB
  rows:    341,773
  symbols: 3,502

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
2013-07-24 04:00:00	AAPL	Stock	15.5	15.5018	15.5	15.5	141624.0
2013-07-24 04:05:00	AAPL	Stock	15.5171	15.5179	15.5	15.5179	36400.0
2013-07-24 04:20:00	AAPL	Stock	15.5321	15.5357	15.5321	15.5357	37800.0
2013-07-24 04:35:00	AAPL	Stock	15.5429	15.5429	15.5429	15.5429	2800.0
2013-07-24 04:50:00	AAPL	Stock	15.5632	15.5632	15.5632	15.5632	2800.0
2013-07-24 05:15:00	AAPL	Stock	15.5107	15.5107	15.5	15.5	24388.0
2013-07-24 05:25:00	AAPL	Stock	15.5086	15.5086	15.5086	15.5086	2800.0
2013-07-24 05:40:00	AAPL	Stock	15.5357	15.5357	15.5357	15.5357	2800.0
2013-07-24 05:45:00	AAPL	Stock	15.5464	15.5464	15.5464	15.5464	8960.0
2013-07-24 05:50:00	AAPL	Stock	15.5482	15.5482	15.5482	15.5482	5600.0
2013-07-24 05:55:00	AAPL	Stock	15.5586	15.5625	15.5586	15.5621	54040.0
2013-07-24 06:00:00	AAPL	Stock	15.5536	15.5536	15.5536	15.5536	2884.0
2013-07-24 06:15:00	AAPL	Stock	15.5536	15.56	15.5536	15.56	17640.0
2013-07-24 06:25:00	AAPL	Stock	15.5536	15.5536	15.5536	15.5536	5600.0
2013-07-24 06:30:00	AAPL	Stock	15.5446	15.5446	15.5446	15.5446	2800.0
2013-07-24 06:40:00	AAPL	Stock	15.5475	15.5475	15.5	15.5364	26600.0
2013-07-24 06:50:00	AAPL	Stock	15.5364	15.5364	15.5343	15.5343	9800.0
2013-07-24 06:55:00	AAPL	Stock	15.5329	15.5836	15.5329	15.5836	31416.0
2013-07-24 07:00:00	AAPL	Stock	15.575	15.6046	15.5714	15.6046	33936.0
2013-07-24 07:05:00	AAPL	Stock	15.5861	15.5929	15.5857	15.5929	11200.0
2013-07-24 07:10:00	AAPL	Stock	15.5857	15.5893	15.5736	15.5796	12460.0
2013-07-24 07:15:00	AAPL	Stock	15.5879	15.5964	15.5864	15.5932	22400.0
2013-07-24 07:20:00	AAPL	Stock	15.595	15.595	15.5843	15.5893	23800.0
2013-07-24 07:25:00	AAPL	Stock	15.6032	15.6464	15.6	15.6286	541408.0
2013-07-24 07:30:00	AAPL	Stock	15.6425	15.6425	15.6254	15.6321	141064.0
2013-07-24 07:35:00	AAPL	Stock	15.6321	15.6371	15.6071	15.6079	42476.0
2013-07-24 07:40:00	AAPL	Stock	15.6132	15.6675	15.6132	15.6607	183596.0
2013-07-24 07:45:00	AAPL	Stock	15.6554	15.6696	15.6536	15.6586	158172.0
2013-07-24 07:50:00	AAPL	Stock	15.6468	15.6875	15.6446	15.6768	505792.0
2013-07-24 07:55:00	AAPL	Stock	15.6782	15.7232	15.6779	15.6964	727720.0
2013-07-24 08:00:00	AAPL	Stock	15.6786	15.6964	15.5714	15.6482	1156680.0
2013-07-24 08:05:00	AAPL	Stock	15.6482	15.6875	15.6482	15.6854	421344.0
2013-07-24 08:10:00	AAPL	Stock	15.6857	15.7089	15.6804	15.6904	422660.0
2013-07-24 08:15:00	AAPL	Stock	15.6893	15.6911	15.6679	15.6679	439376.0
2013-07-24 08:20:00	AAPL	Stock	15.6682	15.6786	15.6629	15.6643	159460.0
2013-07-24 08:25:00	AAPL	Stock	15.6639	15.6639	15.6482	15.6536	446768.0
2013-07-24 08:30:00	AAPL	Stock	15.6514	15.6664	15.6482	15.6607	354424.0
2013-07-24 08:35:00	AAPL	Stock	15.6554	15.6786	15.6536	15.6786	275408.0
2013-07-24 08:40:00	AAPL	Stock	15.6771	15.6786	15.6632	15.6768	267624.0
2013-07-24 08:45:00	AAPL	Stock	15.6775	15.6893	15.6732	15.6893	780724.0
2013-07-24 08:50:00	AAPL	Stock	15.69	15.7039	15.685	15.6939	650356.0
2013-07-24 08:55:00	AAPL	Stock	15.695	15.6964	15.6796	15.6846	719824.0
2013-07-24 09:00:00	AAPL	Stock	15.6843	15.6904	15.6754	15.6786	414484.0
2013-07-24 09:05:00	AAPL	Stock	15.6829	15.6832	15.6786	15.6793	177548.0
2013-07-24 09:10:00	AAPL	Stock	15.6789	15.6821	15.66	15.6689	584808.0
2013-07-24 09:15:00	AAPL	Stock	15.6686	15.6686	15.65	15.6521	584556.0
2013-07-24 09:20:00	AAPL	Stock	15.655	15.6875	15.655	15.6875	387660.0
2013-07-24 09:25:00	AAPL	Stock	15.6911	15.7143	15.6343	15.6786	1768620.0
2013-07-24 09:30:00	AAPL	Stock	15.6761	15.7321	15.5982	15.6007	48310584.0
2013-07-24 09:35:00	AAPL	Stock	15.6011	15.6693	15.5982	15.6304	19181232.0

> showing 50 of 341,773 rows — these rows as CSV

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