PREVIEW / stock_5min / 2011-01-31

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-01-31.parquet
  size:    5.0 MB
  rows:    340,250
  symbols: 3,539

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
2011-01-31 04:15:00	AAPL	Stock	11.9654	11.9654	11.9654	11.9654	2800.0
2011-01-31 04:45:00	AAPL	Stock	11.9929	11.9929	11.9929	11.9929	16520.0
2011-01-31 05:10:00	AAPL	Stock	11.9893	11.9929	11.9893	11.9929	5600.0
2011-01-31 05:25:00	AAPL	Stock	11.9971	11.9971	11.9971	11.9971	2800.0
2011-01-31 05:55:00	AAPL	Stock	11.9836	11.9836	11.9836	11.9836	5600.0
2011-01-31 06:05:00	AAPL	Stock	12.0082	12.0096	12.0082	12.0096	17360.0
2011-01-31 06:25:00	AAPL	Stock	12.0289	12.0289	12.0289	12.0289	5600.0
2011-01-31 06:50:00	AAPL	Stock	12.0139	12.0139	12.0096	12.0096	8400.0
2011-01-31 07:00:00	AAPL	Stock	12.0214	12.0214	12.0139	12.0143	20300.0
2011-01-31 07:10:00	AAPL	Stock	12.0	12.0	12.0	12.0	19068.0
2011-01-31 07:15:00	AAPL	Stock	12.0121	12.0121	12.0036	12.0036	10668.0
2011-01-31 07:20:00	AAPL	Stock	12.0161	12.0339	12.0161	12.0196	84532.0
2011-01-31 07:25:00	AAPL	Stock	12.0243	12.0243	12.0243	12.0243	2800.0
2011-01-31 07:30:00	AAPL	Stock	12.0111	12.0393	12.0111	12.0393	45612.0
2011-01-31 07:35:00	AAPL	Stock	12.0464	12.0532	12.0411	12.0464	85260.0
2011-01-31 07:40:00	AAPL	Stock	12.0521	12.0571	12.0464	12.0471	131908.0
2011-01-31 07:45:00	AAPL	Stock	12.0471	12.05	12.0468	12.0496	42420.0
2011-01-31 07:50:00	AAPL	Stock	12.0536	12.0536	12.0536	12.0536	5600.0
2011-01-31 07:55:00	AAPL	Stock	12.0525	12.0525	12.0525	12.0525	2800.0
2011-01-31 08:00:00	AAPL	Stock	12.0386	12.0536	12.0021	12.0161	209076.0
2011-01-31 08:05:00	AAPL	Stock	12.0175	12.0357	12.0161	12.0357	159180.0
2011-01-31 08:10:00	AAPL	Stock	12.0357	12.0536	12.0357	12.0468	229376.0
2011-01-31 08:15:00	AAPL	Stock	12.0493	12.05	12.0429	12.0429	140504.0
2011-01-31 08:20:00	AAPL	Stock	12.0479	12.0586	12.0436	12.0586	163688.0
2011-01-31 08:25:00	AAPL	Stock	12.0604	12.0679	12.0568	12.0607	310828.0
2011-01-31 08:30:00	AAPL	Stock	12.0607	12.0696	12.0571	12.0661	194740.0
2011-01-31 08:35:00	AAPL	Stock	12.0661	12.0689	12.0639	12.0639	112672.0
2011-01-31 08:40:00	AAPL	Stock	12.0664	12.0732	12.0661	12.0714	220332.0
2011-01-31 08:45:00	AAPL	Stock	12.0714	12.0725	12.0625	12.0654	99736.0
2011-01-31 08:50:00	AAPL	Stock	12.0679	12.0679	12.0536	12.0536	112224.0
2011-01-31 08:55:00	AAPL	Stock	12.0546	12.0629	12.0536	12.0607	76188.0
2011-01-31 09:00:00	AAPL	Stock	12.0554	12.0554	12.045	12.0504	153468.0
2011-01-31 09:05:00	AAPL	Stock	12.0536	12.0636	12.0536	12.0636	49924.0
2011-01-31 09:10:00	AAPL	Stock	12.0629	12.0629	12.05	12.05	25200.0
2011-01-31 09:15:00	AAPL	Stock	12.0482	12.0482	12.0364	12.0382	135352.0
2011-01-31 09:20:00	AAPL	Stock	12.0364	12.0364	12.0196	12.0214	104552.0
2011-01-31 09:25:00	AAPL	Stock	12.0321	12.0339	11.9936	11.9936	587748.0
2011-01-31 09:30:00	AAPL	Stock	11.9932	12.0589	11.9907	12.0221	14805112.0
2011-01-31 09:35:00	AAPL	Stock	12.0197	12.0239	11.9814	12.0018	11364332.0
2011-01-31 09:40:00	AAPL	Stock	12.0018	12.0532	11.9754	11.9982	11547480.0
2011-01-31 09:45:00	AAPL	Stock	11.9982	11.9986	11.9589	11.9793	12210016.0
2011-01-31 09:50:00	AAPL	Stock	11.9818	12.0029	11.9589	11.9657	7304472.0
2011-01-31 09:55:00	AAPL	Stock	11.9657	12.0071	11.9586	11.9789	10124352.0
2011-01-31 10:00:00	AAPL	Stock	11.9786	12.0046	11.9689	11.9864	5564076.0
2011-01-31 10:05:00	AAPL	Stock	11.9861	12.0007	11.9679	11.9721	3912076.0
2011-01-31 10:10:00	AAPL	Stock	11.9729	11.9929	11.9536	11.9693	5342204.0
2011-01-31 10:15:00	AAPL	Stock	11.9696	11.98	11.9393	11.9661	6900152.0
2011-01-31 10:20:00	AAPL	Stock	11.9679	12.0257	11.9657	11.9979	10376212.0
2011-01-31 10:25:00	AAPL	Stock	11.9964	12.0154	11.9857	12.0107	4432232.0
2011-01-31 10:30:00	AAPL	Stock	12.0111	12.0257	12.0029	12.0156	3785544.0

> showing 50 of 340,250 rows — these rows as CSV

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