PREVIEW / stock_5min / 2011-09-02

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-09-02.parquet
  size:    4.8 MB
  rows:    328,446
  symbols: 3,475

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
2011-09-02 04:00:00	AAPL	Stock	13.5714	13.5714	13.5686	13.5686	11200.0
2011-09-02 04:05:00	AAPL	Stock	13.5682	13.5682	13.5682	13.5682	2800.0
2011-09-02 04:10:00	AAPL	Stock	13.5621	13.5621	13.5621	13.5621	2800.0
2011-09-02 05:00:00	AAPL	Stock	13.5493	13.5493	13.5493	13.5493	2800.0
2011-09-02 05:20:00	AAPL	Stock	13.5357	13.5357	13.5357	13.5357	2800.0
2011-09-02 05:30:00	AAPL	Stock	13.5393	13.5393	13.5393	13.5393	2800.0
2011-09-02 05:45:00	AAPL	Stock	13.5143	13.5143	13.5071	13.5071	10500.0
2011-09-02 05:55:00	AAPL	Stock	13.5357	13.5357	13.5357	13.5357	2800.0
2011-09-02 06:35:00	AAPL	Stock	13.5179	13.5186	13.5179	13.5186	5600.0
2011-09-02 06:40:00	AAPL	Stock	13.5186	13.5357	13.5186	13.5357	43400.0
2011-09-02 06:45:00	AAPL	Stock	13.5357	13.5357	13.5357	13.5357	30800.0
2011-09-02 07:00:00	AAPL	Stock	13.5357	13.5357	13.5357	13.5357	8400.0
2011-09-02 07:05:00	AAPL	Stock	13.5407	13.5407	13.5357	13.5357	8400.0
2011-09-02 07:10:00	AAPL	Stock	13.5357	13.5421	13.52	13.5421	33432.0
2011-09-02 07:15:00	AAPL	Stock	13.525	13.5393	13.525	13.5361	14000.0
2011-09-02 07:20:00	AAPL	Stock	13.5364	13.5368	13.5364	13.5368	5600.0
2011-09-02 07:25:00	AAPL	Stock	13.5443	13.5536	13.5443	13.5536	51100.0
2011-09-02 07:30:00	AAPL	Stock	13.5525	13.5525	13.5525	13.5525	2800.0
2011-09-02 07:35:00	AAPL	Stock	13.545	13.5464	13.5421	13.5464	16800.0
2011-09-02 07:40:00	AAPL	Stock	13.5464	13.5464	13.5464	13.5464	8400.0
2011-09-02 07:45:00	AAPL	Stock	13.5461	13.5482	13.5454	13.5454	72800.0
2011-09-02 07:50:00	AAPL	Stock	13.5446	13.5446	13.5446	13.5446	3780.0
2011-09-02 07:55:00	AAPL	Stock	13.5425	13.5429	13.5268	13.5268	42056.0
2011-09-02 08:00:00	AAPL	Stock	13.5354	13.5439	13.5182	13.5182	147084.0
2011-09-02 08:05:00	AAPL	Stock	13.5264	13.5279	13.5179	13.5179	60424.0
2011-09-02 08:10:00	AAPL	Stock	13.5143	13.5286	13.5125	13.5268	152628.0
2011-09-02 08:15:00	AAPL	Stock	13.5204	13.5357	13.5204	13.5275	61460.0
2011-09-02 08:20:00	AAPL	Stock	13.5286	13.5461	13.5196	13.5311	114100.0
2011-09-02 08:25:00	AAPL	Stock	13.5293	13.5625	13.5179	13.5625	172956.0
2011-09-02 08:30:00	AAPL	Stock	13.5657	13.5893	13.44	13.4429	1541456.0
2011-09-02 08:35:00	AAPL	Stock	13.4389	13.4643	13.4311	13.4532	1236312.0
2011-09-02 08:40:00	AAPL	Stock	13.45	13.4621	13.4329	13.4621	598976.0
2011-09-02 08:45:00	AAPL	Stock	13.4593	13.4596	13.4404	13.45	377440.0
2011-09-02 08:50:00	AAPL	Stock	13.4468	13.4475	13.4125	13.4175	483840.0
2011-09-02 08:55:00	AAPL	Stock	13.4168	13.4286	13.4018	13.4279	813568.0
2011-09-02 09:00:00	AAPL	Stock	13.4243	13.4293	13.4107	13.4286	386064.0
2011-09-02 09:05:00	AAPL	Stock	13.4286	13.43	13.4143	13.4143	264012.0
2011-09-02 09:10:00	AAPL	Stock	13.4161	13.4179	13.4107	13.4118	227920.0
2011-09-02 09:15:00	AAPL	Stock	13.4114	13.4129	13.3846	13.3857	1077328.0
2011-09-02 09:20:00	AAPL	Stock	13.3857	13.4036	13.3754	13.3829	800632.0
2011-09-02 09:25:00	AAPL	Stock	13.3829	13.3964	13.375	13.385	1294188.0
2011-09-02 09:30:00	AAPL	Stock	13.3846	13.4239	13.3321	13.4095	21784420.0
2011-09-02 09:35:00	AAPL	Stock	13.4079	13.4321	13.3571	13.3666	14379904.0
2011-09-02 09:40:00	AAPL	Stock	13.3637	13.3754	13.3304	13.3634	13447308.0
2011-09-02 09:45:00	AAPL	Stock	13.3634	13.4086	13.3454	13.4085	10322816.0
2011-09-02 09:50:00	AAPL	Stock	13.4053	13.42	13.3886	13.4	8610700.0
2011-09-02 09:55:00	AAPL	Stock	13.4002	13.4325	13.3857	13.4261	7753172.0
2011-09-02 10:00:00	AAPL	Stock	13.4218	13.4554	13.4157	13.4293	9609544.0
2011-09-02 10:05:00	AAPL	Stock	13.4289	13.4711	13.4207	13.4711	8519084.0
2011-09-02 10:10:00	AAPL	Stock	13.4686	13.5	13.4671	13.4846	11149180.0

> showing 50 of 328,446 rows — these rows as CSV

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