PREVIEW / stock_5min / 2007-07-18

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-07-18.parquet
  size:    4.1 MB
  rows:    299,608
  symbols: 3,064

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
2007-07-18 09:30:00	AAPL	Stock	4.9354	4.9357	4.8939	4.9215	36352120.0
2007-07-18 09:35:00	AAPL	Stock	4.9214	4.9241	4.8946	4.9161	28677068.0
2007-07-18 09:40:00	AAPL	Stock	4.9161	4.9329	4.9143	4.9325	17900904.0
2007-07-18 09:45:00	AAPL	Stock	4.9329	4.94	4.9199	4.9311	18774952.0
2007-07-18 09:50:00	AAPL	Stock	4.9314	4.9343	4.9232	4.9257	10838912.0
2007-07-18 09:55:00	AAPL	Stock	4.9264	4.9382	4.9221	4.9346	15151780.0
2007-07-18 10:00:00	AAPL	Stock	4.935	4.9443	4.9243	4.9301	18672948.0
2007-07-18 10:05:00	AAPL	Stock	4.929	4.9339	4.9207	4.9211	12331256.0
2007-07-18 10:10:00	AAPL	Stock	4.9211	4.9321	4.9207	4.9254	12449024.0
2007-07-18 10:15:00	AAPL	Stock	4.9254	4.9311	4.9171	4.9243	9282476.0
2007-07-18 10:20:00	AAPL	Stock	4.925	4.9275	4.9196	4.9207	5863396.0
2007-07-18 10:25:00	AAPL	Stock	4.9207	4.9214	4.9161	4.9193	8150520.0
2007-07-18 10:30:00	AAPL	Stock	4.9193	4.9204	4.9121	4.9136	10339196.0
2007-07-18 10:35:00	AAPL	Stock	4.9139	4.9168	4.9129	4.9129	4642036.0
2007-07-18 10:40:00	AAPL	Stock	4.9129	4.9143	4.9082	4.9082	9002840.0
2007-07-18 10:45:00	AAPL	Stock	4.9086	4.9093	4.8986	4.9	17922548.0
2007-07-18 10:50:00	AAPL	Stock	4.8998	4.9118	4.8982	4.9096	10481688.0
2007-07-18 10:55:00	AAPL	Stock	4.9096	4.9164	4.9086	4.9125	9317140.0
2007-07-18 11:00:00	AAPL	Stock	4.9129	4.9179	4.9075	4.9118	7583016.0
2007-07-18 11:05:00	AAPL	Stock	4.9104	4.9157	4.9086	4.9104	6524056.0
2007-07-18 11:10:00	AAPL	Stock	4.9118	4.9207	4.9089	4.9164	8444520.0
2007-07-18 11:15:00	AAPL	Stock	4.9164	4.92	4.9118	4.9155	4570244.0
2007-07-18 11:20:00	AAPL	Stock	4.9164	4.9261	4.9146	4.9243	6468756.0
2007-07-18 11:25:00	AAPL	Stock	4.9246	4.9254	4.9179	4.9221	5528320.0
2007-07-18 11:30:00	AAPL	Stock	4.9218	4.9232	4.9114	4.9129	6482812.0
2007-07-18 11:35:00	AAPL	Stock	4.9129	4.9132	4.9032	4.9057	10526544.0
2007-07-18 11:40:00	AAPL	Stock	4.9057	4.9136	4.9057	4.9136	5558280.0
2007-07-18 11:45:00	AAPL	Stock	4.9136	4.9157	4.9089	4.9104	4889024.0
2007-07-18 11:50:00	AAPL	Stock	4.9104	4.9104	4.9061	4.9068	4504696.0
2007-07-18 11:55:00	AAPL	Stock	4.9064	4.9093	4.9025	4.905	4075624.0
2007-07-18 12:00:00	AAPL	Stock	4.9054	4.9071	4.8929	4.8929	10918432.0
2007-07-18 12:05:00	AAPL	Stock	4.8932	4.8986	4.8889	4.8918	12328568.0
2007-07-18 12:10:00	AAPL	Stock	4.8911	4.8975	4.8879	4.8954	11320344.0
2007-07-18 12:15:00	AAPL	Stock	4.8961	4.8971	4.8825	4.8829	7847448.0
2007-07-18 12:20:00	AAPL	Stock	4.8829	4.8864	4.8586	4.8621	27728372.0
2007-07-18 12:25:00	AAPL	Stock	4.862	4.8779	4.8611	4.8775	14514780.0
2007-07-18 12:30:00	AAPL	Stock	4.8775	4.8882	4.87	4.8839	9804732.0
2007-07-18 12:35:00	AAPL	Stock	4.8836	4.8907	4.8796	4.8807	7053368.0
2007-07-18 12:40:00	AAPL	Stock	4.8807	4.8846	4.8796	4.8811	3940328.0
2007-07-18 12:45:00	AAPL	Stock	4.8811	4.8875	4.8786	4.8868	5618704.0
2007-07-18 12:50:00	AAPL	Stock	4.8871	4.8921	4.8857	4.8882	7866824.0
2007-07-18 12:55:00	AAPL	Stock	4.8871	4.8882	4.8796	4.885	4074616.0
2007-07-18 13:00:00	AAPL	Stock	4.8847	4.8871	4.8757	4.8786	3991008.0
2007-07-18 13:05:00	AAPL	Stock	4.8786	4.8818	4.8736	4.8807	3407096.0
2007-07-18 13:10:00	AAPL	Stock	4.8807	4.8864	4.8736	4.8854	5272064.0
2007-07-18 13:15:00	AAPL	Stock	4.8851	4.8879	4.8796	4.8825	3043236.0
2007-07-18 13:20:00	AAPL	Stock	4.8825	4.8904	4.8804	4.8893	4895828.0
2007-07-18 13:25:00	AAPL	Stock	4.8893	4.8943	4.8876	4.8896	5855388.0
2007-07-18 13:30:00	AAPL	Stock	4.8896	4.8989	4.8896	4.8957	5378856.0
2007-07-18 13:35:00	AAPL	Stock	4.8961	4.9064	4.8961	4.9043	11350892.0

> showing 50 of 299,608 rows — these rows as CSV

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