PREVIEW / stock_5min / 2011-01-18

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-01-18.parquet
  size:    5.0 MB
  rows:    339,800
  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
2011-01-18 04:00:00	AAPL	Stock	11.6429	11.75	11.6429	11.7229	66360.0
2011-01-18 04:05:00	AAPL	Stock	11.7439	11.7854	11.7368	11.7546	92400.0
2011-01-18 04:10:00	AAPL	Stock	11.7668	11.7668	11.7464	11.75	105056.0
2011-01-18 04:15:00	AAPL	Stock	11.75	11.7857	11.75	11.7857	58016.0
2011-01-18 04:25:00	AAPL	Stock	11.7557	11.7857	11.7393	11.7857	59780.0
2011-01-18 04:30:00	AAPL	Stock	11.7857	11.8	11.7857	11.8	16800.0
2011-01-18 04:35:00	AAPL	Stock	11.7761	11.7929	11.7761	11.7929	28000.0
2011-01-18 04:40:00	AAPL	Stock	11.7932	11.7932	11.7932	11.7932	5600.0
2011-01-18 04:45:00	AAPL	Stock	11.7818	11.7818	11.7579	11.7768	25200.0
2011-01-18 04:50:00	AAPL	Stock	11.7768	11.7814	11.7768	11.7814	5600.0
2011-01-18 04:55:00	AAPL	Stock	11.7746	11.8107	11.7746	11.8107	68600.0
2011-01-18 05:00:00	AAPL	Stock	11.8211	11.8971	11.8211	11.8971	62160.0
2011-01-18 05:05:00	AAPL	Stock	11.9	11.9164	11.8879	11.9089	86240.0
2011-01-18 05:10:00	AAPL	Stock	11.9286	11.9454	11.9286	11.9286	19600.0
2011-01-18 05:15:00	AAPL	Stock	11.9025	11.9104	11.8839	11.8839	33600.0
2011-01-18 05:20:00	AAPL	Stock	11.8996	11.9236	11.8996	11.9236	161000.0
2011-01-18 05:25:00	AAPL	Stock	11.93	11.93	11.925	11.925	22400.0
2011-01-18 05:30:00	AAPL	Stock	11.9143	11.9196	11.9039	11.9039	49000.0
2011-01-18 05:35:00	AAPL	Stock	11.9046	11.9164	11.9	11.9132	28000.0
2011-01-18 05:40:00	AAPL	Stock	11.9171	11.9214	11.9171	11.9214	8400.0
2011-01-18 05:45:00	AAPL	Stock	11.9282	11.9282	11.8793	11.8929	167860.0
2011-01-18 05:50:00	AAPL	Stock	11.8914	11.8929	11.875	11.8857	72800.0
2011-01-18 05:55:00	AAPL	Stock	11.875	11.8829	11.8454	11.8493	174720.0
2011-01-18 06:00:00	AAPL	Stock	11.8571	11.9111	11.8411	11.9111	48020.0
2011-01-18 06:05:00	AAPL	Stock	11.9061	11.9236	11.9046	11.9196	29400.0
2011-01-18 06:10:00	AAPL	Stock	11.9143	11.9196	11.9071	11.9196	50400.0
2011-01-18 06:15:00	AAPL	Stock	11.9196	11.9404	11.9082	11.9404	46872.0
2011-01-18 06:20:00	AAPL	Stock	11.9032	11.9032	11.8729	11.875	92400.0
2011-01-18 06:25:00	AAPL	Stock	11.875	11.9046	11.8643	11.8789	72240.0
2011-01-18 06:30:00	AAPL	Stock	11.875	11.8789	11.8446	11.8446	190400.0
2011-01-18 06:35:00	AAPL	Stock	11.8429	11.8861	11.8429	11.875	239904.0
2011-01-18 06:40:00	AAPL	Stock	11.8861	11.9286	11.8861	11.9214	429912.0
2011-01-18 06:45:00	AAPL	Stock	11.9214	11.9286	11.9214	11.9286	246288.0
2011-01-18 06:50:00	AAPL	Stock	11.9286	11.9375	11.8607	11.8929	430892.0
2011-01-18 06:55:00	AAPL	Stock	11.8929	11.9143	11.8929	11.9018	176400.0
2011-01-18 07:00:00	AAPL	Stock	11.9018	11.9018	11.8643	11.8907	1308664.0
2011-01-18 07:05:00	AAPL	Stock	11.8821	11.8911	11.8196	11.8214	1180032.0
2011-01-18 07:10:00	AAPL	Stock	11.8146	11.8179	11.7839	11.8025	1239448.0
2011-01-18 07:15:00	AAPL	Stock	11.7954	11.8029	11.77	11.77	1743728.0
2011-01-18 07:20:00	AAPL	Stock	11.7732	11.8571	11.7529	11.8368	1605100.0
2011-01-18 07:25:00	AAPL	Stock	11.8243	11.8386	11.7996	11.8214	500276.0
2011-01-18 07:30:00	AAPL	Stock	11.8161	11.8393	11.8125	11.8304	1289736.0
2011-01-18 07:35:00	AAPL	Stock	11.8321	11.8407	11.8179	11.8214	1058176.0
2011-01-18 07:40:00	AAPL	Stock	11.8243	11.8271	11.8125	11.8243	592312.0
2011-01-18 07:45:00	AAPL	Stock	11.8271	11.8536	11.825	11.8536	1154776.0
2011-01-18 07:50:00	AAPL	Stock	11.8529	11.8679	11.8357	11.8679	1156596.0
2011-01-18 07:55:00	AAPL	Stock	11.8679	11.9089	11.8679	11.9	3073840.0
2011-01-18 08:00:00	AAPL	Stock	11.8929	11.9036	11.7714	11.8929	6790028.0
2011-01-18 08:05:00	AAPL	Stock	11.8964	11.9068	11.8754	11.8968	2243500.0
2011-01-18 08:10:00	AAPL	Stock	11.8932	11.8968	11.8796	11.8871	1665300.0

> showing 50 of 339,800 rows — these rows as CSV

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