PREVIEW / stock_5min / 2012-05-03

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-03.parquet
  size:    4.9 MB
  rows:    332,969
  symbols: 3,541

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-03 04:00:00	AAPL	Stock	20.9546	20.9643	20.9546	20.9643	22400.0
2012-05-03 04:20:00	AAPL	Stock	20.9643	20.9643	20.9643	20.9643	2800.0
2012-05-03 04:25:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	11200.0
2012-05-03 04:35:00	AAPL	Stock	20.9643	20.9643	20.9643	20.9643	13300.0
2012-05-03 04:45:00	AAPL	Stock	20.9643	20.9643	20.9643	20.9643	8400.0
2012-05-03 05:20:00	AAPL	Stock	20.9639	20.9639	20.9639	20.9639	14000.0
2012-05-03 05:55:00	AAPL	Stock	20.9464	20.9464	20.9464	20.9464	13580.0
2012-05-03 06:45:00	AAPL	Stock	20.9468	20.9468	20.9464	20.9464	11200.0
2012-05-03 07:00:00	AAPL	Stock	20.9643	20.9643	20.9461	20.9643	23520.0
2012-05-03 07:05:00	AAPL	Stock	20.9643	20.9643	20.9643	20.9643	13160.0
2012-05-03 07:10:00	AAPL	Stock	20.9729	21.0	20.9729	21.0	46424.0
2012-05-03 07:15:00	AAPL	Stock	21.0	21.0	20.9921	20.9921	11200.0
2012-05-03 07:25:00	AAPL	Stock	20.9804	21.0189	20.9804	21.0186	25200.0
2012-05-03 07:30:00	AAPL	Stock	21.0354	21.0354	21.0214	21.025	14000.0
2012-05-03 07:35:00	AAPL	Stock	21.0179	21.0179	21.0164	21.0164	14000.0
2012-05-03 07:40:00	AAPL	Stock	21.0232	21.0232	21.0071	21.0071	53200.0
2012-05-03 07:45:00	AAPL	Stock	21.0	21.0	20.9861	20.9996	24500.0
2012-05-03 07:50:00	AAPL	Stock	21.0	21.0	20.9964	21.0	56868.0
2012-05-03 07:55:00	AAPL	Stock	21.0068	21.0068	20.9825	20.9825	22400.0
2012-05-03 08:00:00	AAPL	Stock	20.9861	21.0321	20.9379	20.9793	388388.0
2012-05-03 08:05:00	AAPL	Stock	20.9814	20.9814	20.9446	20.9461	160916.0
2012-05-03 08:10:00	AAPL	Stock	20.9536	20.9636	20.9468	20.9571	61600.0
2012-05-03 08:15:00	AAPL	Stock	20.9511	20.9514	20.9286	20.9289	192696.0
2012-05-03 08:20:00	AAPL	Stock	20.9286	20.9911	20.9282	20.975	415968.0
2012-05-03 08:25:00	AAPL	Stock	20.975	20.9946	20.9643	20.9643	185360.0
2012-05-03 08:30:00	AAPL	Stock	20.9839	21.0536	20.9714	21.0536	1141028.0
2012-05-03 08:35:00	AAPL	Stock	21.05	21.0536	21.0179	21.0339	459956.0
2012-05-03 08:40:00	AAPL	Stock	21.0346	21.0514	21.0236	21.0507	294168.0
2012-05-03 08:45:00	AAPL	Stock	21.0432	21.0493	21.0043	21.0161	264068.0
2012-05-03 08:50:00	AAPL	Stock	21.0125	21.0318	20.9964	21.0318	673344.0
2012-05-03 08:55:00	AAPL	Stock	21.0211	21.0279	21.0118	21.0243	166348.0
2012-05-03 09:00:00	AAPL	Stock	21.0196	21.0482	21.0196	21.0411	352800.0
2012-05-03 09:05:00	AAPL	Stock	21.0339	21.0486	21.0254	21.0443	272524.0
2012-05-03 09:10:00	AAPL	Stock	21.0396	21.0643	21.0357	21.0525	318136.0
2012-05-03 09:15:00	AAPL	Stock	21.0632	21.0679	21.0536	21.0607	209832.0
2012-05-03 09:20:00	AAPL	Stock	21.0632	21.065	21.0464	21.0464	285012.0
2012-05-03 09:25:00	AAPL	Stock	21.0507	21.1	21.0357	21.1	1137220.0
2012-05-03 09:30:00	AAPL	Stock	21.0893	21.1214	21.0357	21.0779	17473344.0
2012-05-03 09:35:00	AAPL	Stock	21.0804	21.0918	21.0036	21.0711	13060796.0
2012-05-03 09:40:00	AAPL	Stock	21.0714	21.0714	21.0	21.0018	10281264.0
2012-05-03 09:45:00	AAPL	Stock	21.0021	21.0518	21.0021	21.0291	6990480.0
2012-05-03 09:50:00	AAPL	Stock	21.0318	21.0443	20.9911	21.0075	8853236.0
2012-05-03 09:55:00	AAPL	Stock	21.0175	21.0454	21.0	21.02	5910520.0
2012-05-03 10:00:00	AAPL	Stock	21.02	21.0257	20.9725	20.9914	8910636.0
2012-05-03 10:05:00	AAPL	Stock	20.9918	21.0106	20.9861	20.9932	4649960.0
2012-05-03 10:10:00	AAPL	Stock	20.9957	21.0168	20.9643	20.9643	5643008.0
2012-05-03 10:15:00	AAPL	Stock	20.9643	20.9782	20.9311	20.9311	7343056.0
2012-05-03 10:20:00	AAPL	Stock	20.9314	20.9714	20.9243	20.9714	7962416.0
2012-05-03 10:25:00	AAPL	Stock	20.9711	20.9729	20.9489	20.9686	3766616.0
2012-05-03 10:30:00	AAPL	Stock	20.9686	20.9923	20.9464	20.9789	5791800.0

> showing 50 of 332,969 rows — these rows as CSV

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