PREVIEW / stock_5min / 2012-07-12

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-12.parquet
  size:    4.7 MB
  rows:    315,359
  symbols: 3,446

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-07-12 04:00:00	AAPL	Stock	21.5357	21.5357	21.4893	21.4893	70000.0
2012-07-12 04:05:00	AAPL	Stock	21.4893	21.4893	21.4893	21.4893	8400.0
2012-07-12 04:15:00	AAPL	Stock	21.5357	21.5357	21.5357	21.5357	2800.0
2012-07-12 04:55:00	AAPL	Stock	21.5018	21.5018	21.5018	21.5018	4200.0
2012-07-12 06:05:00	AAPL	Stock	21.5	21.5	21.5	21.5	11200.0
2012-07-12 06:25:00	AAPL	Stock	21.5132	21.5179	21.4929	21.4932	29456.0
2012-07-12 06:30:00	AAPL	Stock	21.4821	21.4821	21.4821	21.4821	2800.0
2012-07-12 06:40:00	AAPL	Stock	21.4643	21.4643	21.4643	21.4643	5600.0
2012-07-12 06:45:00	AAPL	Stock	21.4289	21.4289	21.4286	21.4286	11200.0
2012-07-12 06:55:00	AAPL	Stock	21.4107	21.4107	21.4107	21.4107	2800.0
2012-07-12 07:00:00	AAPL	Stock	21.4607	21.4646	21.4436	21.4436	38724.0
2012-07-12 07:05:00	AAPL	Stock	21.46	21.4639	21.4571	21.4571	10164.0
2012-07-12 07:10:00	AAPL	Stock	21.4643	21.4643	21.4454	21.4454	21728.0
2012-07-12 07:15:00	AAPL	Stock	21.4375	21.4375	21.4304	21.4336	19600.0
2012-07-12 07:20:00	AAPL	Stock	21.4361	21.4361	21.4168	21.4207	106512.0
2012-07-12 07:25:00	AAPL	Stock	21.4214	21.4289	21.4214	21.4282	14560.0
2012-07-12 07:30:00	AAPL	Stock	21.4218	21.4218	21.4054	21.4054	70196.0
2012-07-12 07:35:00	AAPL	Stock	21.4232	21.4286	21.4214	21.4286	25200.0
2012-07-12 07:40:00	AAPL	Stock	21.4282	21.4446	21.4282	21.4446	58380.0
2012-07-12 07:45:00	AAPL	Stock	21.4393	21.4436	21.4393	21.4436	18340.0
2012-07-12 07:50:00	AAPL	Stock	21.44	21.4418	21.44	21.4418	5600.0
2012-07-12 07:55:00	AAPL	Stock	21.4371	21.4393	21.4371	21.4393	30800.0
2012-07-12 08:00:00	AAPL	Stock	21.4429	21.4782	21.4193	21.4782	215404.0
2012-07-12 08:05:00	AAPL	Stock	21.4746	21.4818	21.4461	21.4461	248724.0
2012-07-12 08:10:00	AAPL	Stock	21.4464	21.4571	21.4446	21.4571	42140.0
2012-07-12 08:15:00	AAPL	Stock	21.4554	21.4554	21.4407	21.4407	71848.0
2012-07-12 08:20:00	AAPL	Stock	21.4429	21.4682	21.4339	21.4682	149268.0
2012-07-12 08:25:00	AAPL	Stock	21.4646	21.4893	21.4525	21.4821	171612.0
2012-07-12 08:30:00	AAPL	Stock	21.4754	21.4857	21.46	21.46	210952.0
2012-07-12 08:35:00	AAPL	Stock	21.4607	21.4643	21.4607	21.4643	109676.0
2012-07-12 08:40:00	AAPL	Stock	21.4536	21.4571	21.45	21.4521	112644.0
2012-07-12 08:45:00	AAPL	Stock	21.4514	21.4518	21.4393	21.4393	153244.0
2012-07-12 08:50:00	AAPL	Stock	21.4396	21.5522	21.4196	21.4286	371728.0
2012-07-12 08:55:00	AAPL	Stock	21.4289	21.4375	21.4196	21.4225	153328.0
2012-07-12 09:00:00	AAPL	Stock	21.4286	21.4411	21.4286	21.4325	221284.0
2012-07-12 09:05:00	AAPL	Stock	21.4318	21.4571	21.4318	21.4571	276080.0
2012-07-12 09:10:00	AAPL	Stock	21.4621	21.4621	21.4471	21.4471	120848.0
2012-07-12 09:15:00	AAPL	Stock	21.4475	21.4482	21.4282	21.4307	189364.0
2012-07-12 09:20:00	AAPL	Stock	21.4307	21.4307	21.4054	21.4161	308448.0
2012-07-12 09:25:00	AAPL	Stock	21.4079	21.4446	21.405	21.4425	1042664.0
2012-07-12 09:30:00	AAPL	Stock	21.4371	21.4821	21.4111	21.4311	16020508.0
2012-07-12 09:35:00	AAPL	Stock	21.4293	21.5071	21.4193	21.465	13310696.0
2012-07-12 09:40:00	AAPL	Stock	21.4625	21.4814	21.4214	21.4339	8538880.0
2012-07-12 09:45:00	AAPL	Stock	21.43	21.4774	21.4125	21.4139	8325716.0
2012-07-12 09:50:00	AAPL	Stock	21.4139	21.4179	21.3393	21.365	13090532.0
2012-07-12 09:55:00	AAPL	Stock	21.3664	21.3796	21.3036	21.3495	10080000.0
2012-07-12 10:00:00	AAPL	Stock	21.3557	21.3642	21.3064	21.3446	6721064.0
2012-07-12 10:05:00	AAPL	Stock	21.3479	21.3486	21.2911	21.2989	7819784.0
2012-07-12 10:10:00	AAPL	Stock	21.3	21.3461	21.2868	21.3346	5668740.0
2012-07-12 10:15:00	AAPL	Stock	21.3325	21.3325	21.2746	21.3054	5640824.0

> showing 50 of 315,359 rows — these rows as CSV

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