PREVIEW / stock_5min / 2009-04-28

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-28.parquet
  size:    4.4 MB
  rows:    305,387
  symbols: 3,313

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
2009-04-28 06:10:00	AAPL	Stock	4.3896	4.3896	4.3896	4.3896	2800.0
2009-04-28 06:50:00	AAPL	Stock	4.3882	4.3882	4.3882	4.3882	2800.0
2009-04-28 07:00:00	AAPL	Stock	4.3896	4.3896	4.3896	4.3896	2800.0
2009-04-28 07:05:00	AAPL	Stock	4.3929	4.3929	4.3929	4.3929	8400.0
2009-04-28 07:10:00	AAPL	Stock	4.3946	4.4254	4.3946	4.3968	33600.0
2009-04-28 07:15:00	AAPL	Stock	4.3982	4.3982	4.3982	4.3982	2800.0
2009-04-28 07:40:00	AAPL	Stock	4.4021	4.4021	4.4	4.4	15400.0
2009-04-28 07:45:00	AAPL	Stock	4.4	4.4	4.4	4.4	8400.0
2009-04-28 07:50:00	AAPL	Stock	4.4	4.4	4.3996	4.3996	21000.0
2009-04-28 08:00:00	AAPL	Stock	4.4546	4.4546	4.3996	4.4129	118412.0
2009-04-28 08:05:00	AAPL	Stock	4.4175	4.4175	4.4161	4.4161	15960.0
2009-04-28 08:10:00	AAPL	Stock	4.4161	4.4229	4.4161	4.4214	58716.0
2009-04-28 08:15:00	AAPL	Stock	4.4229	4.4286	4.4229	4.4286	26320.0
2009-04-28 08:20:00	AAPL	Stock	4.4286	4.4393	4.4286	4.4286	43960.0
2009-04-28 08:25:00	AAPL	Stock	4.4286	4.4286	4.4093	4.41	381640.0
2009-04-28 08:30:00	AAPL	Stock	4.4107	4.4107	4.4018	4.4029	96320.0
2009-04-28 08:35:00	AAPL	Stock	4.4021	4.4218	4.4021	4.4218	14392.0
2009-04-28 08:40:00	AAPL	Stock	4.4143	4.4143	4.4143	4.4143	14000.0
2009-04-28 08:45:00	AAPL	Stock	4.4129	4.4129	4.4125	4.4125	44800.0
2009-04-28 08:50:00	AAPL	Stock	4.4179	4.4182	4.4171	4.4182	14000.0
2009-04-28 08:55:00	AAPL	Stock	4.4182	4.42	4.4179	4.42	16800.0
2009-04-28 09:00:00	AAPL	Stock	4.4179	4.4179	4.4021	4.4036	327600.0
2009-04-28 09:05:00	AAPL	Stock	4.4046	4.4139	4.4043	4.4139	137536.0
2009-04-28 09:15:00	AAPL	Stock	4.4146	4.4146	4.4143	4.4143	13300.0
2009-04-28 09:20:00	AAPL	Stock	4.4171	4.4214	4.4171	4.4214	33600.0
2009-04-28 09:25:00	AAPL	Stock	4.4179	4.4179	4.4021	4.4057	723408.0
2009-04-28 09:30:00	AAPL	Stock	4.4064	4.4343	4.4021	4.4057	22396752.0
2009-04-28 09:35:00	AAPL	Stock	4.4061	4.4282	4.4054	4.4209	14275884.0
2009-04-28 09:40:00	AAPL	Stock	4.4204	4.4282	4.4146	4.4179	7509824.0
2009-04-28 09:45:00	AAPL	Stock	4.4175	4.4271	4.4129	4.4218	7293496.0
2009-04-28 09:50:00	AAPL	Stock	4.4218	4.4407	4.4218	4.4404	6996808.0
2009-04-28 09:55:00	AAPL	Stock	4.4404	4.4539	4.4339	4.4536	7937328.0
2009-04-28 10:00:00	AAPL	Stock	4.45	4.4764	4.4486	4.4721	15272600.0
2009-04-28 10:05:00	AAPL	Stock	4.4725	4.5025	4.4718	4.4989	16961700.0
2009-04-28 10:10:00	AAPL	Stock	4.4989	4.4989	4.4784	4.485	9923508.0
2009-04-28 10:15:00	AAPL	Stock	4.4832	4.4939	4.4804	4.4921	6100976.0
2009-04-28 10:20:00	AAPL	Stock	4.4921	4.5	4.4896	4.4932	9182208.0
2009-04-28 10:25:00	AAPL	Stock	4.4911	4.4993	4.4904	4.4971	3893988.0
2009-04-28 10:30:00	AAPL	Stock	4.4971	4.4993	4.4871	4.4886	5945548.0
2009-04-28 10:35:00	AAPL	Stock	4.4893	4.4957	4.4871	4.4926	3437196.0
2009-04-28 10:40:00	AAPL	Stock	4.4928	4.5064	4.4889	4.5	8110760.0
2009-04-28 10:45:00	AAPL	Stock	4.5	4.5075	4.4986	4.5011	5374656.0
2009-04-28 10:50:00	AAPL	Stock	4.5022	4.5064	4.4925	4.4945	4235168.0
2009-04-28 10:55:00	AAPL	Stock	4.4946	4.4964	4.4886	4.4953	3111360.0
2009-04-28 11:00:00	AAPL	Stock	4.495	4.5004	4.4911	4.4921	3085320.0
2009-04-28 11:05:00	AAPL	Stock	4.4918	4.4918	4.4825	4.4879	3778880.0
2009-04-28 11:10:00	AAPL	Stock	4.4879	4.4932	4.4832	4.4836	3295628.0
2009-04-28 11:15:00	AAPL	Stock	4.4843	4.4882	4.4732	4.4843	4679052.0
2009-04-28 11:20:00	AAPL	Stock	4.4843	4.4846	4.4739	4.4768	3350396.0
2009-04-28 11:25:00	AAPL	Stock	4.4771	4.4854	4.475	4.4771	2759316.0

> showing 50 of 305,387 rows — these rows as CSV

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