PREVIEW / stock_5min / 2010-09-09

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-09-09.parquet
  size:    4.5 MB
  rows:    311,709
  symbols: 3,460

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
2010-09-09 04:50:00	AAPL	Stock	9.3757	9.3757	9.3757	9.3757	4200.0
2010-09-09 05:20:00	AAPL	Stock	9.4046	9.405	9.4046	9.405	28000.0
2010-09-09 07:00:00	AAPL	Stock	9.4071	9.4111	9.4071	9.4111	22400.0
2010-09-09 07:10:00	AAPL	Stock	9.4196	9.4196	9.4196	9.4196	8400.0
2010-09-09 07:20:00	AAPL	Stock	9.41	9.41	9.41	9.41	2800.0
2010-09-09 07:25:00	AAPL	Stock	9.41	9.41	9.41	9.41	25200.0
2010-09-09 07:30:00	AAPL	Stock	9.4171	9.4204	9.4171	9.4179	67200.0
2010-09-09 07:35:00	AAPL	Stock	9.4239	9.425	9.4111	9.4111	40236.0
2010-09-09 07:40:00	AAPL	Stock	9.4214	9.4214	9.4211	9.4211	8400.0
2010-09-09 07:45:00	AAPL	Stock	9.4182	9.4182	9.4143	9.4143	5600.0
2010-09-09 07:50:00	AAPL	Stock	9.4107	9.4143	9.4107	9.4143	8400.0
2010-09-09 07:55:00	AAPL	Stock	9.4125	9.4125	9.4125	9.4125	2800.0
2010-09-09 08:00:00	AAPL	Stock	9.4139	9.4193	9.4057	9.4154	180880.0
2010-09-09 08:05:00	AAPL	Stock	9.4146	9.4175	9.4111	9.4114	117600.0
2010-09-09 08:10:00	AAPL	Stock	9.4114	9.4125	9.4036	9.4036	246400.0
2010-09-09 08:15:00	AAPL	Stock	9.4036	9.4036	9.3964	9.4	134400.0
2010-09-09 08:20:00	AAPL	Stock	9.4	9.4018	9.3964	9.4018	71960.0
2010-09-09 08:25:00	AAPL	Stock	9.4018	9.4018	9.3929	9.3964	176792.0
2010-09-09 08:30:00	AAPL	Stock	9.3964	9.4679	9.3964	9.4679	1710212.0
2010-09-09 08:35:00	AAPL	Stock	9.4668	9.4729	9.45	9.4529	1092840.0
2010-09-09 08:40:00	AAPL	Stock	9.4536	9.4557	9.4429	9.4557	603680.0
2010-09-09 08:45:00	AAPL	Stock	9.4571	9.4696	9.4464	9.4679	489300.0
2010-09-09 08:50:00	AAPL	Stock	9.47	9.4786	9.4607	9.4746	576296.0
2010-09-09 08:55:00	AAPL	Stock	9.4739	9.4804	9.4686	9.4775	607600.0
2010-09-09 09:00:00	AAPL	Stock	9.4775	9.4775	9.4668	9.4732	427868.0
2010-09-09 09:05:00	AAPL	Stock	9.4732	9.4771	9.4732	9.475	235368.0
2010-09-09 09:10:00	AAPL	Stock	9.4768	9.4779	9.4707	9.4754	221004.0
2010-09-09 09:15:00	AAPL	Stock	9.4743	9.4796	9.4707	9.4796	490644.0
2010-09-09 09:20:00	AAPL	Stock	9.4793	9.4868	9.4779	9.4843	582960.0
2010-09-09 09:25:00	AAPL	Stock	9.4864	9.4929	9.4646	9.4675	1185968.0
2010-09-09 09:30:00	AAPL	Stock	9.4675	9.4886	9.4521	9.4726	22704528.0
2010-09-09 09:35:00	AAPL	Stock	9.473	9.4789	9.4529	9.472	12926872.0
2010-09-09 09:40:00	AAPL	Stock	9.4721	9.4739	9.4543	9.4675	8802920.0
2010-09-09 09:45:00	AAPL	Stock	9.4661	9.4893	9.4568	9.4757	10646776.0
2010-09-09 09:50:00	AAPL	Stock	9.4768	9.4961	9.4732	9.4943	12055092.0
2010-09-09 09:55:00	AAPL	Stock	9.4946	9.5	9.4839	9.4907	12099528.0
2010-09-09 10:00:00	AAPL	Stock	9.49	9.5107	9.4864	9.5075	11081812.0
2010-09-09 10:05:00	AAPL	Stock	9.5064	9.5164	9.4929	9.4946	9509668.0
2010-09-09 10:10:00	AAPL	Stock	9.4936	9.5021	9.4861	9.4971	7689360.0
2010-09-09 10:15:00	AAPL	Stock	9.4979	9.5089	9.4946	9.5061	7695996.0
2010-09-09 10:20:00	AAPL	Stock	9.5064	9.5186	9.5021	9.5129	7256620.0
2010-09-09 10:25:00	AAPL	Stock	9.5132	9.5164	9.5	9.5154	6500536.0
2010-09-09 10:30:00	AAPL	Stock	9.5153	9.5157	9.495	9.4968	5152924.0
2010-09-09 10:35:00	AAPL	Stock	9.4954	9.4986	9.4839	9.496	7493808.0
2010-09-09 10:40:00	AAPL	Stock	9.495	9.4961	9.485	9.4929	3709888.0
2010-09-09 10:45:00	AAPL	Stock	9.4929	9.5071	9.4896	9.5064	5289760.0
2010-09-09 10:50:00	AAPL	Stock	9.5064	9.5107	9.4929	9.4971	4542468.0
2010-09-09 10:55:00	AAPL	Stock	9.4989	9.5071	9.4864	9.4864	3946712.0
2010-09-09 11:00:00	AAPL	Stock	9.4882	9.4996	9.4854	9.4911	4782428.0
2010-09-09 11:05:00	AAPL	Stock	9.4925	9.4971	9.4839	9.4917	2256436.0

> showing 50 of 311,709 rows — these rows as CSV

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