PREVIEW / stock_5min / 2013-04-22

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-22.parquet
  size:    4.9 MB
  rows:    328,323
  symbols: 3,479

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
2013-04-22 04:00:00	AAPL	Stock	13.9639	13.9639	13.9639	13.9639	2800.0
2013-04-22 04:50:00	AAPL	Stock	13.9625	13.9643	13.9625	13.9643	5600.0
2013-04-22 05:00:00	AAPL	Stock	13.9679	13.9732	13.9679	13.9732	5600.0
2013-04-22 05:30:00	AAPL	Stock	14.0104	14.0143	14.0104	14.0143	33852.0
2013-04-22 06:15:00	AAPL	Stock	14.0186	14.0186	14.0186	14.0186	2800.0
2013-04-22 06:45:00	AAPL	Stock	14.0075	14.0075	14.0054	14.0054	8400.0
2013-04-22 06:50:00	AAPL	Stock	14.0075	14.0179	14.0075	14.0179	8400.0
2013-04-22 06:55:00	AAPL	Stock	14.0171	14.0171	14.0171	14.0171	2800.0
2013-04-22 07:00:00	AAPL	Stock	14.0071	14.0071	14.0007	14.0007	32088.0
2013-04-22 07:10:00	AAPL	Stock	14.0057	14.0057	14.0057	14.0057	3332.0
2013-04-22 07:15:00	AAPL	Stock	14.0089	14.0089	14.0	14.0	18396.0
2013-04-22 07:20:00	AAPL	Stock	14.0	14.0	14.0	14.0	19600.0
2013-04-22 07:25:00	AAPL	Stock	14.0121	14.0121	13.9875	13.9979	22876.0
2013-04-22 07:30:00	AAPL	Stock	13.9996	13.9996	13.9286	13.9443	118300.0
2013-04-22 07:35:00	AAPL	Stock	13.9307	13.9307	13.8843	13.8929	123312.0
2013-04-22 07:40:00	AAPL	Stock	13.9257	13.9264	13.8425	13.845	211316.0
2013-04-22 07:45:00	AAPL	Stock	13.8479	13.8821	13.8479	13.8821	25200.0
2013-04-22 07:50:00	AAPL	Stock	13.875	13.8832	13.8629	13.8629	25200.0
2013-04-22 07:55:00	AAPL	Stock	13.8614	13.8939	13.8611	13.8932	55776.0
2013-04-22 08:00:00	AAPL	Stock	13.8932	14.0089	13.8571	13.9807	576660.0
2013-04-22 08:05:00	AAPL	Stock	13.9821	14.0168	13.9496	13.9643	340816.0
2013-04-22 08:10:00	AAPL	Stock	13.9554	13.9643	13.9471	13.9571	148400.0
2013-04-22 08:15:00	AAPL	Stock	13.9604	14.0107	13.9586	14.0	607152.0
2013-04-22 08:20:00	AAPL	Stock	13.9868	14.0107	13.9771	14.0107	423248.0
2013-04-22 08:25:00	AAPL	Stock	14.0018	14.0225	13.9968	14.0179	405300.0
2013-04-22 08:30:00	AAPL	Stock	14.0071	14.0179	13.9754	13.9857	199696.0
2013-04-22 08:35:00	AAPL	Stock	13.9857	14.0107	13.9857	14.0	278040.0
2013-04-22 08:40:00	AAPL	Stock	14.0	14.0104	13.9861	13.9996	176512.0
2013-04-22 08:45:00	AAPL	Stock	13.9914	13.9989	13.9714	13.9839	341404.0
2013-04-22 08:50:00	AAPL	Stock	13.9821	14.0107	13.9821	14.0107	190568.0
2013-04-22 08:55:00	AAPL	Stock	14.0107	14.0232	13.9821	13.9979	482216.0
2013-04-22 09:00:00	AAPL	Stock	13.9986	14.0107	13.9857	13.9896	232288.0
2013-04-22 09:05:00	AAPL	Stock	14.0	14.0096	13.9946	14.0054	113680.0
2013-04-22 09:10:00	AAPL	Stock	14.0079	14.0107	14.0	14.0107	182364.0
2013-04-22 09:15:00	AAPL	Stock	14.0096	14.0482	14.0079	14.0482	531608.0
2013-04-22 09:20:00	AAPL	Stock	14.05	14.0829	14.0361	14.0625	517972.0
2013-04-22 09:25:00	AAPL	Stock	14.0625	14.0625	14.0268	14.0304	473788.0
2013-04-22 09:30:00	AAPL	Stock	14.0229	14.0779	13.9741	14.0529	20732180.0
2013-04-22 09:35:00	AAPL	Stock	14.045	14.0861	14.0179	14.0489	8917972.0
2013-04-22 09:40:00	AAPL	Stock	14.0493	14.0789	13.9889	14.0746	8800456.0
2013-04-22 09:45:00	AAPL	Stock	14.0786	14.0789	14.0179	14.0325	6399288.0
2013-04-22 09:50:00	AAPL	Stock	14.0368	14.16	14.0226	14.1488	14750904.0
2013-04-22 09:55:00	AAPL	Stock	14.1529	14.2071	14.1293	14.1904	10846388.0
2013-04-22 10:00:00	AAPL	Stock	14.1861	14.1964	14.1389	14.1589	8191876.0
2013-04-22 10:05:00	AAPL	Stock	14.1582	14.1757	14.12	14.1332	5893356.0
2013-04-22 10:10:00	AAPL	Stock	14.1336	14.1386	14.0739	14.0932	7582400.0
2013-04-22 10:15:00	AAPL	Stock	14.0954	14.1489	14.0944	14.1357	6221740.0
2013-04-22 10:20:00	AAPL	Stock	14.1318	14.1425	14.0893	14.0911	5660480.0
2013-04-22 10:25:00	AAPL	Stock	14.0933	14.1071	14.0478	14.0925	7154784.0
2013-04-22 10:30:00	AAPL	Stock	14.0962	14.0971	14.0539	14.0671	3919916.0

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

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