PREVIEW / stock_5min / 2011-01-05

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-01-05.parquet
  size:    4.9 MB
  rows:    335,699
  symbols: 3,528

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-01-05 04:00:00	AAPL	Stock	11.5714	11.5714	11.5714	11.5714	2800.0
2011-01-05 04:05:00	AAPL	Stock	11.8161	11.8161	11.8161	11.8161	2800.0
2011-01-05 04:25:00	AAPL	Stock	11.8125	11.8125	11.8125	11.8125	2800.0
2011-01-05 05:25:00	AAPL	Stock	11.7886	11.7886	11.7886	11.7886	2800.0
2011-01-05 05:35:00	AAPL	Stock	11.7929	11.7929	11.7929	11.7929	11200.0
2011-01-05 05:40:00	AAPL	Stock	11.7929	11.8	11.7929	11.8	19600.0
2011-01-05 06:00:00	AAPL	Stock	11.7929	11.7929	11.7929	11.7929	14000.0
2011-01-05 06:10:00	AAPL	Stock	11.7929	11.7929	11.7907	11.7907	5600.0
2011-01-05 06:30:00	AAPL	Stock	11.7746	11.7746	11.7746	11.7746	2800.0
2011-01-05 06:55:00	AAPL	Stock	11.7839	11.7839	11.7839	11.7839	2800.0
2011-01-05 07:00:00	AAPL	Stock	11.7618	11.7618	11.7618	11.7618	5600.0
2011-01-05 07:15:00	AAPL	Stock	11.7679	11.7757	11.7671	11.7757	21560.0
2011-01-05 07:25:00	AAPL	Stock	11.7682	11.7682	11.7543	11.7543	75040.0
2011-01-05 07:30:00	AAPL	Stock	11.7543	11.7543	11.7543	11.7543	5600.0
2011-01-05 07:40:00	AAPL	Stock	11.7546	11.7643	11.7543	11.7546	16800.0
2011-01-05 07:45:00	AAPL	Stock	11.7546	11.7639	11.7543	11.7639	22960.0
2011-01-05 07:50:00	AAPL	Stock	11.7621	11.7625	11.75	11.7625	24920.0
2011-01-05 07:55:00	AAPL	Stock	11.7532	11.7639	11.7532	11.7625	38920.0
2011-01-05 08:00:00	AAPL	Stock	11.7536	11.7782	11.7532	11.7679	243264.0
2011-01-05 08:05:00	AAPL	Stock	11.7661	11.7725	11.7643	11.7725	84728.0
2011-01-05 08:10:00	AAPL	Stock	11.7764	11.7821	11.7693	11.7786	353864.0
2011-01-05 08:15:00	AAPL	Stock	11.7825	11.8011	11.775	11.8011	568008.0
2011-01-05 08:20:00	AAPL	Stock	11.8054	11.8189	11.7968	11.8046	673820.0
2011-01-05 08:25:00	AAPL	Stock	11.8007	11.8007	11.7911	11.7946	768264.0
2011-01-05 08:30:00	AAPL	Stock	11.7896	11.7964	11.7861	11.7964	108780.0
2011-01-05 08:35:00	AAPL	Stock	11.7964	11.7993	11.7907	11.7964	401072.0
2011-01-05 08:40:00	AAPL	Stock	11.795	11.7961	11.775	11.7814	309904.0
2011-01-05 08:45:00	AAPL	Stock	11.7836	11.7914	11.7796	11.7914	73780.0
2011-01-05 08:50:00	AAPL	Stock	11.7879	11.7946	11.7857	11.7914	96684.0
2011-01-05 08:55:00	AAPL	Stock	11.7893	11.7893	11.785	11.7893	73640.0
2011-01-05 09:00:00	AAPL	Stock	11.7932	11.7943	11.7893	11.7907	63000.0
2011-01-05 09:05:00	AAPL	Stock	11.7896	11.7946	11.7864	11.7946	90496.0
2011-01-05 09:10:00	AAPL	Stock	11.7907	11.7964	11.7907	11.7964	224812.0
2011-01-05 09:15:00	AAPL	Stock	11.8011	11.8054	11.7964	11.7964	140000.0
2011-01-05 09:20:00	AAPL	Stock	11.7936	11.7946	11.7857	11.7864	114800.0
2011-01-05 09:25:00	AAPL	Stock	11.7857	11.7861	11.765	11.7661	316120.0
2011-01-05 09:30:00	AAPL	Stock	11.7661	11.8118	11.7661	11.8043	13719720.0
2011-01-05 09:35:00	AAPL	Stock	11.8059	11.8179	11.7861	11.8175	6480236.0
2011-01-05 09:40:00	AAPL	Stock	11.8154	11.8313	11.8125	11.8246	7662928.0
2011-01-05 09:45:00	AAPL	Stock	11.822	11.8393	11.8219	11.8332	5501132.0
2011-01-05 09:50:00	AAPL	Stock	11.8337	11.8429	11.8304	11.8357	4403476.0
2011-01-05 09:55:00	AAPL	Stock	11.8371	11.8382	11.8229	11.8304	3525340.0
2011-01-05 10:00:00	AAPL	Stock	11.8279	11.8518	11.8164	11.8514	6293420.0
2011-01-05 10:05:00	AAPL	Stock	11.8511	11.8629	11.8421	11.8486	7130928.0
2011-01-05 10:10:00	AAPL	Stock	11.8486	11.85	11.84	11.8486	2978136.0
2011-01-05 10:15:00	AAPL	Stock	11.8486	11.8618	11.8468	11.8561	4847640.0
2011-01-05 10:20:00	AAPL	Stock	11.8561	11.8654	11.8543	11.8575	4715592.0
2011-01-05 10:25:00	AAPL	Stock	11.8589	11.8629	11.8468	11.8507	3035592.0
2011-01-05 10:30:00	AAPL	Stock	11.8511	11.8557	11.8486	11.8536	2497852.0
2011-01-05 10:35:00	AAPL	Stock	11.8525	11.8607	11.8511	11.8532	2329600.0

> showing 50 of 335,699 rows — these rows as CSV

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