PREVIEW / stock_5min / 2012-04-02

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-02.parquet
  size:    5.0 MB
  rows:    338,547
  symbols: 3,533

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-04-02 04:00:00	AAPL	Stock	21.5	21.5714	21.5	21.5714	25200.0
2012-04-02 04:05:00	AAPL	Stock	21.575	21.575	21.575	21.575	2800.0
2012-04-02 04:10:00	AAPL	Stock	21.5893	21.6018	21.5357	21.6018	21000.0
2012-04-02 04:15:00	AAPL	Stock	21.5893	21.5893	21.5893	21.5893	2800.0
2012-04-02 04:20:00	AAPL	Stock	21.6061	21.6071	21.5807	21.5807	29120.0
2012-04-02 04:40:00	AAPL	Stock	21.5361	21.5361	21.5357	21.5357	16800.0
2012-04-02 04:50:00	AAPL	Stock	21.5004	21.5393	21.5	21.5393	13720.0
2012-04-02 04:55:00	AAPL	Stock	21.5393	21.5393	21.5393	21.5393	2800.0
2012-04-02 05:00:00	AAPL	Stock	21.5393	21.5393	21.5393	21.5393	5880.0
2012-04-02 05:10:00	AAPL	Stock	21.5146	21.5146	21.505	21.505	19600.0
2012-04-02 05:15:00	AAPL	Stock	21.5036	21.5036	21.49	21.49	28000.0
2012-04-02 05:20:00	AAPL	Stock	21.4939	21.4939	21.4939	21.4939	2800.0
2012-04-02 05:35:00	AAPL	Stock	21.5057	21.5057	21.5057	21.5057	2800.0
2012-04-02 05:45:00	AAPL	Stock	21.5075	21.5075	21.5075	21.5075	2800.0
2012-04-02 05:55:00	AAPL	Stock	21.5179	21.5179	21.5071	21.5071	28000.0
2012-04-02 06:05:00	AAPL	Stock	21.5143	21.5143	21.5143	21.5143	2800.0
2012-04-02 06:35:00	AAPL	Stock	21.5071	21.5071	21.5071	21.5071	5600.0
2012-04-02 06:40:00	AAPL	Stock	21.5071	21.5071	21.5071	21.5071	2800.0
2012-04-02 06:45:00	AAPL	Stock	21.5075	21.5075	21.5075	21.5075	2800.0
2012-04-02 06:50:00	AAPL	Stock	21.5011	21.5011	21.5011	21.5011	5600.0
2012-04-02 06:55:00	AAPL	Stock	21.5011	21.5011	21.5	21.5	14000.0
2012-04-02 07:00:00	AAPL	Stock	21.5107	21.5143	21.4893	21.4893	95424.0
2012-04-02 07:05:00	AAPL	Stock	21.4861	21.5	21.4861	21.5	14000.0
2012-04-02 07:10:00	AAPL	Stock	21.5	21.5068	21.5	21.5068	46844.0
2012-04-02 07:15:00	AAPL	Stock	21.5054	21.5104	21.4854	21.4854	46592.0
2012-04-02 07:20:00	AAPL	Stock	21.4843	21.4843	21.4554	21.4554	68852.0
2012-04-02 07:25:00	AAPL	Stock	21.4554	21.4554	21.4443	21.4443	43400.0
2012-04-02 07:30:00	AAPL	Stock	21.4464	21.4614	21.4393	21.4614	22960.0
2012-04-02 07:35:00	AAPL	Stock	21.4525	21.4525	21.4375	21.4393	93380.0
2012-04-02 07:40:00	AAPL	Stock	21.4375	21.4518	21.4375	21.4464	64120.0
2012-04-02 07:45:00	AAPL	Stock	21.4404	21.4454	21.4375	21.4382	55972.0
2012-04-02 07:50:00	AAPL	Stock	21.4396	21.4396	21.3661	21.3836	178948.0
2012-04-02 07:55:00	AAPL	Stock	21.3786	21.3929	21.3786	21.3786	64820.0
2012-04-02 08:00:00	AAPL	Stock	21.3911	21.4643	21.3304	21.3571	971404.0
2012-04-02 08:05:00	AAPL	Stock	21.3554	21.3718	21.3396	21.345	169120.0
2012-04-02 08:10:00	AAPL	Stock	21.3393	21.3743	21.3393	21.3607	147196.0
2012-04-02 08:15:00	AAPL	Stock	21.3607	21.3607	21.3332	21.3393	184968.0
2012-04-02 08:20:00	AAPL	Stock	21.3532	21.4125	21.3125	21.345	414456.0
2012-04-02 08:25:00	AAPL	Stock	21.3446	21.4096	21.3446	21.375	203056.0
2012-04-02 08:30:00	AAPL	Stock	21.38	21.3932	21.3761	21.3889	421288.0
2012-04-02 08:35:00	AAPL	Stock	21.3861	21.4064	21.3843	21.4057	176260.0
2012-04-02 08:40:00	AAPL	Stock	21.4104	21.4875	21.4104	21.4754	727944.0
2012-04-02 08:45:00	AAPL	Stock	21.4754	21.5093	21.4643	21.4993	1017240.0
2012-04-02 08:50:00	AAPL	Stock	21.5	21.5	21.4679	21.4821	872032.0
2012-04-02 08:55:00	AAPL	Stock	21.4821	21.4961	21.4818	21.4907	473284.0
2012-04-02 09:00:00	AAPL	Stock	21.4907	21.4911	21.4664	21.4746	658784.0
2012-04-02 09:05:00	AAPL	Stock	21.4743	21.4818	21.4729	21.4811	269500.0
2012-04-02 09:10:00	AAPL	Stock	21.4782	21.5089	21.4675	21.4675	874776.0
2012-04-02 09:15:00	AAPL	Stock	21.4714	21.4821	21.4096	21.4771	283864.0
2012-04-02 09:20:00	AAPL	Stock	21.4804	21.4882	21.4729	21.4804	632072.0

> showing 50 of 338,547 rows — these rows as CSV

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