PREVIEW / stock_5min / 2012-05-01

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-01.parquet
  size:    4.9 MB
  rows:    333,036
  symbols: 3,561

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-05-01 04:05:00	AAPL	Stock	20.8564	20.8571	20.8564	20.8571	12600.0
2012-05-01 04:15:00	AAPL	Stock	20.8286	20.8286	20.8286	20.8286	5600.0
2012-05-01 04:50:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	10612.0
2012-05-01 05:15:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	14000.0
2012-05-01 06:00:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	3388.0
2012-05-01 06:25:00	AAPL	Stock	20.7929	20.7929	20.7929	20.7929	8960.0
2012-05-01 06:45:00	AAPL	Stock	20.7946	20.7946	20.7946	20.7946	6580.0
2012-05-01 06:50:00	AAPL	Stock	20.8	20.8	20.7946	20.7946	12852.0
2012-05-01 07:00:00	AAPL	Stock	20.8482	20.8482	20.8482	20.8482	4200.0
2012-05-01 07:15:00	AAPL	Stock	20.8536	20.875	20.8536	20.875	38108.0
2012-05-01 07:20:00	AAPL	Stock	20.8736	20.8929	20.8736	20.8929	54684.0
2012-05-01 07:25:00	AAPL	Stock	20.9107	20.9368	20.9107	20.9368	18760.0
2012-05-01 07:30:00	AAPL	Stock	20.9429	20.9604	20.9286	20.9286	101388.0
2012-05-01 07:35:00	AAPL	Stock	20.9268	20.9393	20.915	20.9325	65688.0
2012-05-01 07:40:00	AAPL	Stock	20.9404	20.9946	20.9404	20.9732	129388.0
2012-05-01 07:45:00	AAPL	Stock	20.9836	21.02	20.9836	21.0004	123704.0
2012-05-01 07:50:00	AAPL	Stock	20.9886	20.9936	20.975	20.9911	42000.0
2012-05-01 07:55:00	AAPL	Stock	20.9825	20.9832	20.9543	20.9782	104160.0
2012-05-01 08:00:00	AAPL	Stock	20.9761	20.9893	20.9346	20.9714	312676.0
2012-05-01 08:05:00	AAPL	Stock	20.9679	20.9914	20.9507	20.9889	331156.0
2012-05-01 08:10:00	AAPL	Stock	20.9882	20.9979	20.8214	20.8214	171388.0
2012-05-01 08:15:00	AAPL	Stock	20.9768	20.9889	20.9625	20.9639	398468.0
2012-05-01 08:20:00	AAPL	Stock	20.9546	20.9582	20.9475	20.9475	55300.0
2012-05-01 08:25:00	AAPL	Stock	20.9479	20.9636	20.9454	20.9636	146328.0
2012-05-01 08:30:00	AAPL	Stock	20.9504	20.9504	20.9039	20.9286	250152.0
2012-05-01 08:35:00	AAPL	Stock	20.9286	20.9464	20.9286	20.9393	214816.0
2012-05-01 08:40:00	AAPL	Stock	20.9318	20.9464	20.9307	20.9421	129500.0
2012-05-01 08:45:00	AAPL	Stock	20.9457	20.9457	20.9286	20.9311	119980.0
2012-05-01 08:50:00	AAPL	Stock	20.9321	20.9339	20.9286	20.9321	99260.0
2012-05-01 08:55:00	AAPL	Stock	20.9346	20.9354	20.8657	20.9068	338716.0
2012-05-01 09:00:00	AAPL	Stock	20.8982	20.9107	20.875	20.8789	320488.0
2012-05-01 09:05:00	AAPL	Stock	20.8829	20.9021	20.8657	20.8657	381304.0
2012-05-01 09:10:00	AAPL	Stock	20.9039	20.9039	20.8657	20.8714	317716.0
2012-05-01 09:15:00	AAPL	Stock	20.8786	20.8925	20.8657	20.8904	114016.0
2012-05-01 09:20:00	AAPL	Stock	20.8911	20.8921	20.8675	20.8714	80500.0
2012-05-01 09:25:00	AAPL	Stock	20.8671	20.8921	20.8671	20.8911	340060.0
2012-05-01 09:30:00	AAPL	Stock	20.8839	20.9893	20.7582	20.9829	30851604.0
2012-05-01 09:35:00	AAPL	Stock	20.9789	21.0539	20.9554	21.0107	23270156.0
2012-05-01 09:40:00	AAPL	Stock	21.0154	21.1418	21.0089	21.0675	24318000.0
2012-05-01 09:45:00	AAPL	Stock	21.0629	21.1586	21.0582	21.1086	16166220.0
2012-05-01 09:50:00	AAPL	Stock	21.1071	21.125	21.0564	21.0682	8970332.0
2012-05-01 09:55:00	AAPL	Stock	21.0686	21.1232	21.0629	21.075	8598996.0
2012-05-01 10:00:00	AAPL	Stock	21.0875	21.1768	21.0778	21.1761	17007144.0
2012-05-01 10:05:00	AAPL	Stock	21.1768	21.2264	21.1661	21.1918	13575128.0
2012-05-01 10:10:00	AAPL	Stock	21.1932	21.2136	21.1429	21.208	10099712.0
2012-05-01 10:15:00	AAPL	Stock	21.2071	21.2343	21.1757	21.2189	8586228.0
2012-05-01 10:20:00	AAPL	Stock	21.2196	21.3129	21.2179	21.2779	18022396.0
2012-05-01 10:25:00	AAPL	Stock	21.2807	21.3096	21.2679	21.2679	9567404.0
2012-05-01 10:30:00	AAPL	Stock	21.2679	21.3093	21.2543	21.2725	9554412.0
2012-05-01 10:35:00	AAPL	Stock	21.2693	21.2768	21.2146	21.2307	8882020.0

> showing 50 of 333,036 rows — these rows as CSV

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