PREVIEW / stock_5min / 2012-10-18

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-10-18.parquet
  size:    4.7 MB
  rows:    314,672
  symbols: 3,452

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-18 05:15:00	AAPL	Stock	23.0	23.0	23.0	23.0	2800.0
2012-10-18 05:30:00	AAPL	Stock	23.0357	23.0357	23.0357	23.0357	2800.0
2012-10-18 06:00:00	AAPL	Stock	23.0479	23.0479	23.0479	23.0479	2800.0
2012-10-18 06:40:00	AAPL	Stock	23.0518	23.0518	23.0518	23.0518	5600.0
2012-10-18 07:00:00	AAPL	Stock	23.0357	23.0357	23.0357	23.0357	2800.0
2012-10-18 07:05:00	AAPL	Stock	23.0329	23.0329	23.0329	23.0329	2800.0
2012-10-18 07:10:00	AAPL	Stock	23.0318	23.0318	23.0318	23.0318	2800.0
2012-10-18 07:20:00	AAPL	Stock	23.0218	23.0218	23.0186	23.0186	16800.0
2012-10-18 07:25:00	AAPL	Stock	23.0179	23.0179	23.0004	23.0004	22260.0
2012-10-18 07:30:00	AAPL	Stock	22.9921	22.9939	22.9646	22.975	76860.0
2012-10-18 07:35:00	AAPL	Stock	22.9764	22.9764	22.9532	22.9532	33600.0
2012-10-18 07:40:00	AAPL	Stock	22.9554	22.9643	22.9554	22.9554	11200.0
2012-10-18 07:45:00	AAPL	Stock	22.96	22.9625	22.96	22.9625	8400.0
2012-10-18 07:50:00	AAPL	Stock	22.9643	22.9643	22.9321	22.9357	156660.0
2012-10-18 07:55:00	AAPL	Stock	22.9461	22.9518	22.9357	22.9357	22400.0
2012-10-18 08:00:00	AAPL	Stock	22.9514	22.9929	22.9396	22.9714	193928.0
2012-10-18 08:05:00	AAPL	Stock	22.9657	22.9896	22.9643	22.9782	94724.0
2012-10-18 08:10:00	AAPL	Stock	22.9775	22.9775	22.875	22.875	336224.0
2012-10-18 08:15:00	AAPL	Stock	22.8886	22.8929	22.8357	22.8643	485800.0
2012-10-18 08:20:00	AAPL	Stock	22.8804	22.8804	22.8143	22.8221	395500.0
2012-10-18 08:25:00	AAPL	Stock	22.8321	22.8464	22.7368	22.8243	817376.0
2012-10-18 08:30:00	AAPL	Stock	22.8118	22.815	22.7375	22.8018	533848.0
2012-10-18 08:35:00	AAPL	Stock	22.8014	22.8071	22.7836	22.8071	132804.0
2012-10-18 08:40:00	AAPL	Stock	22.8071	22.8275	22.8071	22.8275	165760.0
2012-10-18 08:45:00	AAPL	Stock	22.8196	22.825	22.7968	22.8043	203840.0
2012-10-18 08:50:00	AAPL	Stock	22.8125	22.8125	22.7686	22.7779	419776.0
2012-10-18 08:55:00	AAPL	Stock	22.7771	22.8339	22.7757	22.8161	328048.0
2012-10-18 09:00:00	AAPL	Stock	22.8161	22.875	22.8125	22.8696	424480.0
2012-10-18 09:05:00	AAPL	Stock	22.8736	22.8821	22.8582	22.8746	272468.0
2012-10-18 09:10:00	AAPL	Stock	22.8711	22.9089	22.8521	22.8589	656516.0
2012-10-18 09:15:00	AAPL	Stock	22.8575	22.8661	22.84	22.84	209412.0
2012-10-18 09:20:00	AAPL	Stock	22.8404	22.8404	22.8146	22.8357	145488.0
2012-10-18 09:25:00	AAPL	Stock	22.8304	22.8696	22.8132	22.8546	484820.0
2012-10-18 09:30:00	AAPL	Stock	22.8425	22.8746	22.8036	22.8172	17299408.0
2012-10-18 09:35:00	AAPL	Stock	22.8204	22.8314	22.7632	22.8112	10535028.0
2012-10-18 09:40:00	AAPL	Stock	22.8121	22.8543	22.7918	22.8532	6863556.0
2012-10-18 09:45:00	AAPL	Stock	22.8532	22.9307	22.8396	22.9143	13010172.0
2012-10-18 09:50:00	AAPL	Stock	22.9218	22.9296	22.87	22.87	5252296.0
2012-10-18 09:55:00	AAPL	Stock	22.8707	22.8832	22.8325	22.85	6095600.0
2012-10-18 10:00:00	AAPL	Stock	22.8518	22.8804	22.825	22.8318	6567176.0
2012-10-18 10:05:00	AAPL	Stock	22.8318	22.8329	22.7379	22.7823	11878440.0
2012-10-18 10:10:00	AAPL	Stock	22.7811	22.8014	22.7625	22.7804	5948768.0
2012-10-18 10:15:00	AAPL	Stock	22.7792	22.7793	22.7111	22.7471	8624980.0
2012-10-18 10:20:00	AAPL	Stock	22.7457	22.7932	22.7271	22.7475	6040804.0
2012-10-18 10:25:00	AAPL	Stock	22.745	22.7668	22.7246	22.7522	4014164.0
2012-10-18 10:30:00	AAPL	Stock	22.7529	22.7871	22.7254	22.7811	5077520.0
2012-10-18 10:35:00	AAPL	Stock	22.7779	22.8	22.7743	22.7862	4124204.0
2012-10-18 10:40:00	AAPL	Stock	22.7861	22.7896	22.7599	22.7775	2492056.0
2012-10-18 10:45:00	AAPL	Stock	22.7757	22.8125	22.7725	22.7968	4130336.0
2012-10-18 10:50:00	AAPL	Stock	22.7996	22.8096	22.7868	22.7921	2371600.0

> showing 50 of 314,672 rows — these rows as CSV

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