PREVIEW / stock_5min / 2013-01-11

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-01-11.parquet
  size:    4.7 MB
  rows:    319,795
  symbols: 3,464

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-01-11 04:20:00	AAPL	Stock	18.7321	18.7321	18.7321	18.7321	2800.0
2013-01-11 04:40:00	AAPL	Stock	18.7143	18.7143	18.7143	18.7143	2800.0
2013-01-11 05:00:00	AAPL	Stock	18.7054	18.7054	18.7054	18.7054	2800.0
2013-01-11 05:10:00	AAPL	Stock	18.7054	18.7054	18.7054	18.7054	84000.0
2013-01-11 05:15:00	AAPL	Stock	18.7054	18.7054	18.7054	18.7054	16800.0
2013-01-11 05:20:00	AAPL	Stock	18.7054	18.7054	18.7054	18.7054	16800.0
2013-01-11 05:35:00	AAPL	Stock	18.7057	18.7057	18.7054	18.7054	31612.0
2013-01-11 06:25:00	AAPL	Stock	18.6964	18.6964	18.6964	18.6964	28000.0
2013-01-11 06:35:00	AAPL	Stock	18.7214	18.7214	18.7214	18.7214	2800.0
2013-01-11 06:55:00	AAPL	Stock	18.6961	18.6961	18.6961	18.6961	2800.0
2013-01-11 07:15:00	AAPL	Stock	18.6964	18.7036	18.6918	18.7036	30520.0
2013-01-11 07:20:00	AAPL	Stock	18.6918	18.6929	18.6789	18.6789	70000.0
2013-01-11 07:25:00	AAPL	Stock	18.6786	18.6786	18.6429	18.6429	50400.0
2013-01-11 07:30:00	AAPL	Stock	18.6561	18.6614	18.6561	18.6614	39200.0
2013-01-11 07:35:00	AAPL	Stock	18.6561	18.6839	18.6561	18.6786	12040.0
2013-01-11 07:40:00	AAPL	Stock	18.6786	18.6786	18.65	18.6607	33600.0
2013-01-11 07:45:00	AAPL	Stock	18.6607	18.6607	18.6168	18.625	56000.0
2013-01-11 07:50:00	AAPL	Stock	18.62	18.6429	18.62	18.6429	5600.0
2013-01-11 07:55:00	AAPL	Stock	18.6268	18.6339	18.6071	18.6071	64624.0
2013-01-11 08:00:00	AAPL	Stock	18.6225	18.6964	18.6071	18.6286	222684.0
2013-01-11 08:05:00	AAPL	Stock	18.6175	18.6607	18.6161	18.6464	133924.0
2013-01-11 08:10:00	AAPL	Stock	18.6379	18.6379	18.5593	18.5714	423052.0
2013-01-11 08:15:00	AAPL	Stock	18.5664	18.5907	18.5661	18.5793	314216.0
2013-01-11 08:20:00	AAPL	Stock	18.5893	18.6154	18.58	18.6071	234696.0
2013-01-11 08:25:00	AAPL	Stock	18.605	18.6218	18.605	18.6143	140196.0
2013-01-11 08:30:00	AAPL	Stock	18.6125	18.6211	18.6018	18.6204	140868.0
2013-01-11 08:35:00	AAPL	Stock	18.6096	18.6125	18.5714	18.5896	360388.0
2013-01-11 08:40:00	AAPL	Stock	18.6068	18.6068	18.5893	18.5996	190148.0
2013-01-11 08:45:00	AAPL	Stock	18.5975	18.5996	18.5929	18.5975	20580.0
2013-01-11 08:50:00	AAPL	Stock	18.5904	18.5982	18.5814	18.5814	151956.0
2013-01-11 08:55:00	AAPL	Stock	18.5864	18.5864	18.5589	18.5846	304500.0
2013-01-11 09:00:00	AAPL	Stock	18.5807	18.5814	18.5725	18.5786	42000.0
2013-01-11 09:05:00	AAPL	Stock	18.5786	18.595	18.5721	18.5754	141568.0
2013-01-11 09:10:00	AAPL	Stock	18.5754	18.5893	18.5732	18.5786	83748.0
2013-01-11 09:15:00	AAPL	Stock	18.5821	18.6107	18.5793	18.6107	365428.0
2013-01-11 09:20:00	AAPL	Stock	18.6068	18.6086	18.58	18.5854	297556.0
2013-01-11 09:25:00	AAPL	Stock	18.5979	18.6143	18.5911	18.6071	225904.0
2013-01-11 09:30:00	AAPL	Stock	18.6071	18.625	18.5364	18.6121	15188068.0
2013-01-11 09:35:00	AAPL	Stock	18.6125	18.6921	18.6082	18.6422	13944168.0
2013-01-11 09:40:00	AAPL	Stock	18.635	18.6596	18.6093	18.6557	7895944.0
2013-01-11 09:45:00	AAPL	Stock	18.6561	18.7614	18.6518	18.7371	19084436.0
2013-01-11 09:50:00	AAPL	Stock	18.7307	18.7365	18.6679	18.7096	8651216.0
2013-01-11 09:55:00	AAPL	Stock	18.7098	18.7143	18.6279	18.6434	7784336.0
2013-01-11 10:00:00	AAPL	Stock	18.6457	18.6643	18.6139	18.6186	6195420.0
2013-01-11 10:05:00	AAPL	Stock	18.6175	18.6443	18.6	18.625	5720652.0
2013-01-11 10:10:00	AAPL	Stock	18.6226	18.6307	18.5964	18.6197	4939592.0
2013-01-11 10:15:00	AAPL	Stock	18.6207	18.6296	18.5607	18.5714	5902204.0
2013-01-11 10:20:00	AAPL	Stock	18.5736	18.5786	18.545	18.5704	7597968.0
2013-01-11 10:25:00	AAPL	Stock	18.5648	18.5921	18.5561	18.5807	3759616.0
2013-01-11 10:30:00	AAPL	Stock	18.5853	18.6186	18.5746	18.596	3624964.0

> showing 50 of 319,795 rows — these rows as CSV

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