PREVIEW / stock_5min / 2012-05-24

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-24.parquet
  size:    4.8 MB
  rows:    325,890
  symbols: 3,542

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-24 04:00:00	AAPL	Stock	20.3796	20.3796	20.3571	20.3571	29904.0
2012-05-24 04:05:00	AAPL	Stock	20.3214	20.3214	20.3214	20.3214	2800.0
2012-05-24 04:35:00	AAPL	Stock	20.3214	20.3214	20.3214	20.3214	11900.0
2012-05-24 05:55:00	AAPL	Stock	20.4196	20.4196	20.4196	20.4196	14000.0
2012-05-24 06:00:00	AAPL	Stock	20.4504	20.4643	20.4504	20.4643	26180.0
2012-05-24 06:05:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	2800.0
2012-05-24 06:10:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	8400.0
2012-05-24 06:30:00	AAPL	Stock	20.4643	20.5	20.4643	20.5	43960.0
2012-05-24 06:35:00	AAPL	Stock	20.5	20.5	20.5	20.5	13608.0
2012-05-24 06:45:00	AAPL	Stock	20.4679	20.4679	20.4679	20.4679	2800.0
2012-05-24 06:50:00	AAPL	Stock	20.4821	20.4929	20.4821	20.4929	15540.0
2012-05-24 06:55:00	AAPL	Stock	20.4893	20.4893	20.4893	20.4893	5600.0
2012-05-24 07:00:00	AAPL	Stock	20.4889	20.5325	20.4889	20.5182	108584.0
2012-05-24 07:05:00	AAPL	Stock	20.5179	20.5321	20.5	20.5	89292.0
2012-05-24 07:10:00	AAPL	Stock	20.4996	20.5089	20.4996	20.5089	47600.0
2012-05-24 07:15:00	AAPL	Stock	20.505	20.505	20.4821	20.4821	11200.0
2012-05-24 07:20:00	AAPL	Stock	20.4821	20.4904	20.4796	20.4904	9688.0
2012-05-24 07:25:00	AAPL	Stock	20.4911	20.4929	20.4857	20.4911	61600.0
2012-05-24 07:30:00	AAPL	Stock	20.4911	20.4911	20.4643	20.4739	75600.0
2012-05-24 07:35:00	AAPL	Stock	20.4732	20.4911	20.4729	20.4911	72800.0
2012-05-24 07:40:00	AAPL	Stock	20.4911	20.4911	20.4821	20.4889	89600.0
2012-05-24 07:45:00	AAPL	Stock	20.4907	20.4996	20.4839	20.4861	57960.0
2012-05-24 07:50:00	AAPL	Stock	20.4964	20.4964	20.4789	20.4789	44800.0
2012-05-24 07:55:00	AAPL	Stock	20.4786	20.4829	20.4679	20.4786	60480.0
2012-05-24 08:00:00	AAPL	Stock	20.4818	20.5339	20.4571	20.4571	507276.0
2012-05-24 08:05:00	AAPL	Stock	20.4643	20.4946	20.4643	20.4907	233660.0
2012-05-24 08:10:00	AAPL	Stock	20.495	20.4986	20.4714	20.4714	377860.0
2012-05-24 08:15:00	AAPL	Stock	20.4721	20.4821	20.4721	20.4732	83328.0
2012-05-24 08:20:00	AAPL	Stock	20.4732	20.4814	20.4643	20.4743	204484.0
2012-05-24 08:25:00	AAPL	Stock	20.4664	20.4729	20.4511	20.4729	249704.0
2012-05-24 08:30:00	AAPL	Stock	20.4725	20.4725	20.3804	20.4071	709352.0
2012-05-24 08:35:00	AAPL	Stock	20.4011	20.4464	20.3971	20.4396	436912.0
2012-05-24 08:40:00	AAPL	Stock	20.4393	20.4671	20.4357	20.4671	615496.0
2012-05-24 08:45:00	AAPL	Stock	20.4671	20.4732	20.4518	20.4643	398328.0
2012-05-24 08:50:00	AAPL	Stock	20.4504	20.4771	20.4504	20.4768	648172.0
2012-05-24 08:55:00	AAPL	Stock	20.4768	20.505	20.4718	20.5018	736680.0
2012-05-24 09:00:00	AAPL	Stock	20.5054	20.525	20.4961	20.5068	602476.0
2012-05-24 09:05:00	AAPL	Stock	20.505	20.5089	20.4893	20.5	293860.0
2012-05-24 09:10:00	AAPL	Stock	20.5	20.5	20.4857	20.4939	143668.0
2012-05-24 09:15:00	AAPL	Stock	20.4939	20.4939	20.4725	20.4821	204960.0
2012-05-24 09:20:00	AAPL	Stock	20.4821	20.5	20.4793	20.4829	425432.0
2012-05-24 09:25:00	AAPL	Stock	20.4921	20.57	20.4839	20.57	1924160.0
2012-05-24 09:30:00	AAPL	Stock	20.5668	20.5893	20.4286	20.4347	25149208.0
2012-05-24 09:35:00	AAPL	Stock	20.4418	20.4757	20.3571	20.3571	17820600.0
2012-05-24 09:40:00	AAPL	Stock	20.3571	20.4093	20.2957	20.3659	21252896.0
2012-05-24 09:45:00	AAPL	Stock	20.3704	20.3846	20.3043	20.3204	11106312.0
2012-05-24 09:50:00	AAPL	Stock	20.3204	20.3489	20.2161	20.2516	16293452.0
2012-05-24 09:55:00	AAPL	Stock	20.2475	20.3268	20.2293	20.3245	10934336.0
2012-05-24 10:00:00	AAPL	Stock	20.3225	20.4021	20.3075	20.3736	15522164.0
2012-05-24 10:05:00	AAPL	Stock	20.3746	20.4443	20.3546	20.3904	13212220.0

> showing 50 of 325,890 rows — these rows as CSV

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