PREVIEW / stock_5min / 2009-09-04

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-04.parquet
  size:    4.4 MB
  rows:    310,308
  symbols: 3,331

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
2009-09-04 04:15:00	AAPL	Stock	6.0	6.0	6.0	6.0	2800.0
2009-09-04 06:50:00	AAPL	Stock	5.95	5.95	5.95	5.95	2800.0
2009-09-04 07:00:00	AAPL	Stock	5.95	5.95	5.95	5.95	11200.0
2009-09-04 07:10:00	AAPL	Stock	5.9643	5.9643	5.9643	5.9643	12320.0
2009-09-04 07:25:00	AAPL	Stock	5.9643	5.9643	5.9464	5.9464	30800.0
2009-09-04 07:40:00	AAPL	Stock	5.9471	5.9471	5.9464	5.9464	8400.0
2009-09-04 07:50:00	AAPL	Stock	5.9629	5.9643	5.9629	5.9643	12600.0
2009-09-04 07:55:00	AAPL	Stock	5.9643	5.9643	5.9643	5.9643	12880.0
2009-09-04 08:00:00	AAPL	Stock	5.9754	5.9821	5.9643	5.9786	272300.0
2009-09-04 08:05:00	AAPL	Stock	5.975	5.975	5.9714	5.9714	102760.0
2009-09-04 08:10:00	AAPL	Stock	5.9714	5.9714	5.9643	5.9679	62496.0
2009-09-04 08:15:00	AAPL	Stock	5.9671	5.9679	5.9614	5.9614	46032.0
2009-09-04 08:20:00	AAPL	Stock	5.9639	5.9639	5.9596	5.9596	42028.0
2009-09-04 08:25:00	AAPL	Stock	5.9639	5.9643	5.9625	5.9625	75628.0
2009-09-04 08:30:00	AAPL	Stock	5.9586	5.9586	5.9225	5.955	445424.0
2009-09-04 08:35:00	AAPL	Stock	5.9611	5.98	5.9561	5.9786	511952.0
2009-09-04 08:40:00	AAPL	Stock	5.9786	5.9786	5.9704	5.9714	394268.0
2009-09-04 08:45:00	AAPL	Stock	5.9721	5.9779	5.9704	5.9779	342496.0
2009-09-04 08:50:00	AAPL	Stock	5.9757	5.9811	5.975	5.9757	179564.0
2009-09-04 08:55:00	AAPL	Stock	5.9757	5.9789	5.975	5.9786	166320.0
2009-09-04 09:00:00	AAPL	Stock	5.9786	5.9814	5.9746	5.9746	504000.0
2009-09-04 09:05:00	AAPL	Stock	5.9786	5.9804	5.9757	5.9764	219800.0
2009-09-04 09:10:00	AAPL	Stock	5.9775	5.9789	5.9746	5.9768	156800.0
2009-09-04 09:15:00	AAPL	Stock	5.9761	5.9786	5.9757	5.9786	44800.0
2009-09-04 09:20:00	AAPL	Stock	5.9789	5.9836	5.9789	5.9821	342552.0
2009-09-04 09:25:00	AAPL	Stock	5.9793	5.9836	5.9679	5.9729	250600.0
2009-09-04 09:30:00	AAPL	Stock	5.9721	5.9982	5.9675	5.9975	10859072.0
2009-09-04 09:35:00	AAPL	Stock	5.9975	6.0039	5.9893	5.9971	6806212.0
2009-09-04 09:40:00	AAPL	Stock	5.9974	6.0214	5.9974	6.0104	9535260.0
2009-09-04 09:45:00	AAPL	Stock	6.0104	6.0132	5.9871	5.9914	7443352.0
2009-09-04 09:50:00	AAPL	Stock	5.992	5.9982	5.9868	5.9954	5731572.0
2009-09-04 09:55:00	AAPL	Stock	5.9946	6.0061	5.9943	5.9954	5677924.0
2009-09-04 10:00:00	AAPL	Stock	5.9946	6.0084	5.9939	6.0039	4339328.0
2009-09-04 10:05:00	AAPL	Stock	6.0032	6.0107	6.0021	6.005	3695748.0
2009-09-04 10:10:00	AAPL	Stock	6.0045	6.0143	5.9996	6.0096	3879540.0
2009-09-04 10:15:00	AAPL	Stock	6.0107	6.0154	6.0089	6.0143	3643668.0
2009-09-04 10:20:00	AAPL	Stock	6.015	6.021	6.0143	6.0186	5183080.0
2009-09-04 10:25:00	AAPL	Stock	6.0186	6.0205	6.0125	6.0129	3602116.0
2009-09-04 10:30:00	AAPL	Stock	6.0125	6.0281	6.0125	6.0268	6382432.0
2009-09-04 10:35:00	AAPL	Stock	6.0257	6.0379	6.0257	6.0304	7779156.0
2009-09-04 10:40:00	AAPL	Stock	6.0311	6.0425	6.0311	6.0351	5599944.0
2009-09-04 10:45:00	AAPL	Stock	6.035	6.0432	6.0346	6.0421	4920412.0
2009-09-04 10:50:00	AAPL	Stock	6.0421	6.0446	6.0379	6.0396	8704528.0
2009-09-04 10:55:00	AAPL	Stock	6.04	6.045	6.0382	6.0407	5304348.0
2009-09-04 11:00:00	AAPL	Stock	6.0407	6.0418	6.0296	6.0303	5502028.0
2009-09-04 11:05:00	AAPL	Stock	6.0307	6.0339	6.0271	6.0286	3631880.0
2009-09-04 11:10:00	AAPL	Stock	6.0289	6.0304	6.025	6.0304	1987496.0
2009-09-04 11:15:00	AAPL	Stock	6.0289	6.0368	6.0289	6.0309	2942016.0
2009-09-04 11:20:00	AAPL	Stock	6.0311	6.0373	6.0279	6.035	3487372.0
2009-09-04 11:25:00	AAPL	Stock	6.0343	6.0391	6.0332	6.0388	3736152.0

> showing 50 of 310,308 rows — these rows as CSV

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