PREVIEW / stock_5min / 2012-09-20

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-20.parquet
  size:    4.8 MB
  rows:    321,051
  symbols: 3,476

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-09-20 04:20:00	AAPL	Stock	24.9643	24.9643	24.9643	24.9643	2800.0
2012-09-20 05:00:00	AAPL	Stock	24.9821	24.9821	24.9643	24.9643	16744.0
2012-09-20 05:05:00	AAPL	Stock	24.975	24.975	24.975	24.975	13580.0
2012-09-20 05:10:00	AAPL	Stock	24.9643	24.9643	24.9621	24.9621	5600.0
2012-09-20 05:15:00	AAPL	Stock	24.9643	24.9643	24.9643	24.9643	2800.0
2012-09-20 05:35:00	AAPL	Stock	24.9429	24.9429	24.9314	24.9339	12600.0
2012-09-20 05:45:00	AAPL	Stock	24.9468	24.9468	24.9468	24.9468	6888.0
2012-09-20 06:20:00	AAPL	Stock	24.9504	24.9504	24.9504	24.9504	3276.0
2012-09-20 06:25:00	AAPL	Stock	24.9536	24.9536	24.9536	24.9536	2800.0
2012-09-20 06:30:00	AAPL	Stock	24.9643	24.9821	24.9643	24.9821	8400.0
2012-09-20 06:40:00	AAPL	Stock	24.9821	24.9821	24.9821	24.9821	7700.0
2012-09-20 06:45:00	AAPL	Stock	24.9821	24.9821	24.9821	24.9821	8120.0
2012-09-20 06:50:00	AAPL	Stock	24.9821	24.9821	24.9821	24.9821	7980.0
2012-09-20 07:00:00	AAPL	Stock	24.9911	25.0	24.98	24.98	31080.0
2012-09-20 07:05:00	AAPL	Stock	24.9821	24.9821	24.9821	24.9821	3360.0
2012-09-20 07:10:00	AAPL	Stock	25.0	25.0089	25.0	25.0089	27720.0
2012-09-20 07:15:00	AAPL	Stock	25.0071	25.0286	25.0071	25.0204	51716.0
2012-09-20 07:20:00	AAPL	Stock	25.0214	25.0232	25.0125	25.0232	51520.0
2012-09-20 07:25:00	AAPL	Stock	25.0232	25.0232	25.0232	25.0232	11900.0
2012-09-20 07:30:00	AAPL	Stock	25.0179	25.0179	25.0	25.0	62748.0
2012-09-20 07:35:00	AAPL	Stock	25.0089	25.0089	24.9821	24.9821	62244.0
2012-09-20 07:40:00	AAPL	Stock	24.9821	24.9821	24.9643	24.9821	104692.0
2012-09-20 07:45:00	AAPL	Stock	24.9893	24.9964	24.9821	24.9964	51100.0
2012-09-20 07:50:00	AAPL	Stock	24.9996	25.0	24.9996	25.0	5600.0
2012-09-20 07:55:00	AAPL	Stock	25.0	25.0	25.0	25.0	14000.0
2012-09-20 08:00:00	AAPL	Stock	24.9968	25.0179	24.9643	24.975	457128.0
2012-09-20 08:05:00	AAPL	Stock	24.9682	24.9821	24.9664	24.9821	37912.0
2012-09-20 08:10:00	AAPL	Stock	24.9857	24.9964	24.9839	24.9843	27216.0
2012-09-20 08:15:00	AAPL	Stock	24.985	24.9875	24.9796	24.9796	39200.0
2012-09-20 08:20:00	AAPL	Stock	24.9754	24.9882	24.9704	24.9761	55860.0
2012-09-20 08:25:00	AAPL	Stock	24.9854	25.0	24.985	25.0	102172.0
2012-09-20 08:30:00	AAPL	Stock	24.9839	24.9839	24.9679	24.9679	146048.0
2012-09-20 08:35:00	AAPL	Stock	24.9679	24.9771	24.9643	24.9771	171164.0
2012-09-20 08:40:00	AAPL	Stock	24.9782	24.9786	24.9646	24.9654	40908.0
2012-09-20 08:45:00	AAPL	Stock	24.9646	24.9696	24.9546	24.9607	124096.0
2012-09-20 08:50:00	AAPL	Stock	24.9564	24.9589	24.9536	24.9589	74984.0
2012-09-20 08:55:00	AAPL	Stock	24.9607	24.9857	24.9571	24.9854	243320.0
2012-09-20 09:00:00	AAPL	Stock	24.9854	24.99	24.9811	24.9868	102340.0
2012-09-20 09:05:00	AAPL	Stock	24.9836	24.9975	24.9825	24.9825	124908.0
2012-09-20 09:10:00	AAPL	Stock	24.9832	24.9832	24.9686	24.9768	215768.0
2012-09-20 09:15:00	AAPL	Stock	24.9768	24.9821	24.9754	24.9804	151816.0
2012-09-20 09:20:00	AAPL	Stock	24.9811	24.9821	24.9736	24.9736	126672.0
2012-09-20 09:25:00	AAPL	Stock	24.9732	24.9821	24.9654	24.9696	201656.0
2012-09-20 09:30:00	AAPL	Stock	24.97	24.9821	24.8871	24.9389	24642660.0
2012-09-20 09:35:00	AAPL	Stock	24.9392	24.9811	24.9232	24.975	9796864.0
2012-09-20 09:40:00	AAPL	Stock	24.9761	24.9786	24.9179	24.9179	6337016.0
2012-09-20 09:45:00	AAPL	Stock	24.9193	24.9496	24.9129	24.9196	5529636.0
2012-09-20 09:50:00	AAPL	Stock	24.9232	24.9232	24.8593	24.8621	10379964.0
2012-09-20 09:55:00	AAPL	Stock	24.8593	24.8682	24.7721	24.8154	18124064.0
2012-09-20 10:00:00	AAPL	Stock	24.815	24.8643	24.8036	24.8532	9873780.0

> showing 50 of 321,051 rows — these rows as CSV

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