PREVIEW / stock_5min / 2012-10-04

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-10-04.parquet
  size:    4.7 MB
  rows:    318,748
  symbols: 3,480

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-10-04 04:05:00	AAPL	Stock	24.075	24.075	24.075	24.075	5600.0
2012-10-04 04:10:00	AAPL	Stock	24.0857	24.0857	24.0546	24.0546	14000.0
2012-10-04 04:15:00	AAPL	Stock	24.0357	24.0357	24.0357	24.0357	5600.0
2012-10-04 05:15:00	AAPL	Stock	23.9329	23.9329	23.9329	23.9329	2800.0
2012-10-04 05:45:00	AAPL	Stock	24.0	24.0	24.0	24.0	2800.0
2012-10-04 05:50:00	AAPL	Stock	24.0268	24.0268	24.0268	24.0268	2800.0
2012-10-04 06:20:00	AAPL	Stock	24.0357	24.0357	24.0357	24.0357	2800.0
2012-10-04 06:25:00	AAPL	Stock	24.0454	24.0493	24.0454	24.0493	8400.0
2012-10-04 06:30:00	AAPL	Stock	24.0489	24.0493	24.0489	24.0493	11200.0
2012-10-04 06:35:00	AAPL	Stock	24.0489	24.0493	24.0489	24.0493	16800.0
2012-10-04 06:45:00	AAPL	Stock	24.0429	24.0429	24.0429	24.0429	2800.0
2012-10-04 07:00:00	AAPL	Stock	24.0321	24.0321	24.0179	24.0321	56448.0
2012-10-04 07:05:00	AAPL	Stock	24.0289	24.0393	24.0143	24.0286	143108.0
2012-10-04 07:10:00	AAPL	Stock	24.035	24.0361	24.025	24.025	114660.0
2012-10-04 07:15:00	AAPL	Stock	24.0286	24.0321	24.0286	24.0321	28476.0
2012-10-04 07:20:00	AAPL	Stock	24.0271	24.035	24.0268	24.0268	25200.0
2012-10-04 07:25:00	AAPL	Stock	24.0343	24.0393	24.0296	24.0296	128940.0
2012-10-04 07:30:00	AAPL	Stock	24.0357	24.0429	24.0357	24.0357	35868.0
2012-10-04 07:35:00	AAPL	Stock	24.0304	24.0304	24.0089	24.0243	87920.0
2012-10-04 07:40:00	AAPL	Stock	24.0179	24.0261	24.0143	24.025	86352.0
2012-10-04 07:45:00	AAPL	Stock	24.025	24.025	23.9604	23.9643	153664.0
2012-10-04 07:50:00	AAPL	Stock	23.9682	23.9989	23.9682	23.9857	78960.0
2012-10-04 07:55:00	AAPL	Stock	23.9718	23.9893	23.97	23.9893	49700.0
2012-10-04 08:00:00	AAPL	Stock	23.9821	24.0304	23.9693	24.0054	249508.0
2012-10-04 08:05:00	AAPL	Stock	24.0	24.0	23.9843	23.9843	35700.0
2012-10-04 08:10:00	AAPL	Stock	23.9839	23.9989	23.9832	23.9857	60816.0
2012-10-04 08:15:00	AAPL	Stock	23.9911	24.0104	23.9893	24.0036	114408.0
2012-10-04 08:20:00	AAPL	Stock	24.0086	24.0182	24.0004	24.0004	147420.0
2012-10-04 08:25:00	AAPL	Stock	24.0079	24.0082	23.9754	23.9754	382060.0
2012-10-04 08:30:00	AAPL	Stock	23.9804	23.9829	23.9571	23.9786	226856.0
2012-10-04 08:35:00	AAPL	Stock	23.9943	24.0054	23.9825	23.9825	269220.0
2012-10-04 08:40:00	AAPL	Stock	23.9961	24.0093	23.9961	24.0	205884.0
2012-10-04 08:45:00	AAPL	Stock	24.0	24.0	23.9768	23.9768	298816.0
2012-10-04 08:50:00	AAPL	Stock	23.9771	23.9911	23.9768	23.99	182140.0
2012-10-04 08:55:00	AAPL	Stock	23.9839	23.9911	23.9768	23.9821	254100.0
2012-10-04 09:00:00	AAPL	Stock	23.9804	23.9804	23.9536	23.9725	179760.0
2012-10-04 09:05:00	AAPL	Stock	23.9643	23.965	23.9289	23.9289	315644.0
2012-10-04 09:10:00	AAPL	Stock	23.9289	23.9818	23.9289	23.9804	353948.0
2012-10-04 09:15:00	AAPL	Stock	23.9786	23.9786	23.9554	23.9554	95620.0
2012-10-04 09:20:00	AAPL	Stock	23.9629	23.9639	23.9468	23.9468	101080.0
2012-10-04 09:25:00	AAPL	Stock	23.9468	23.9839	23.9332	23.9743	580748.0
2012-10-04 09:30:00	AAPL	Stock	23.9732	24.0175	23.9154	24.0047	16001160.0
2012-10-04 09:35:00	AAPL	Stock	24.0071	24.0175	23.904	23.9218	10780196.0
2012-10-04 09:40:00	AAPL	Stock	23.9182	23.9811	23.8968	23.9536	8819860.0
2012-10-04 09:45:00	AAPL	Stock	23.9589	24.0314	23.9375	24.0311	7902384.0
2012-10-04 09:50:00	AAPL	Stock	24.0307	24.0389	23.9839	23.9964	8004808.0
2012-10-04 09:55:00	AAPL	Stock	24.0029	24.0264	23.9679	23.9732	5066404.0
2012-10-04 10:00:00	AAPL	Stock	23.9843	24.0089	23.9564	23.9966	5358416.0
2012-10-04 10:05:00	AAPL	Stock	23.9982	24.0593	23.9982	24.0357	8109528.0
2012-10-04 10:10:00	AAPL	Stock	24.036	24.0757	24.0357	24.0561	6922888.0

> showing 50 of 318,748 rows — these rows as CSV

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