PREVIEW / stock_5min / 2007-01-31

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-01-31.parquet
  size:    3.4 MB
  rows:    244,993
  symbols: 2,505

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-01-31 06:20:00	AAPL	Stock	3.0554	3.0554	3.0554	3.0554	5600.0
2007-01-31 06:50:00	AAPL	Stock	3.0468	3.0468	3.0468	3.0468	2800.0
2007-01-31 07:15:00	AAPL	Stock	3.0436	3.0436	3.0321	3.0321	5600.0
2007-01-31 07:20:00	AAPL	Stock	3.0321	3.0321	3.0321	3.0321	21280.0
2007-01-31 07:55:00	AAPL	Stock	3.0446	3.0446	3.0446	3.0446	2800.0
2007-01-31 08:00:00	AAPL	Stock	3.0464	3.05	3.0429	3.0429	148680.0
2007-01-31 08:05:00	AAPL	Stock	3.0429	3.0446	3.0411	3.0429	506912.0
2007-01-31 08:10:00	AAPL	Stock	3.0446	3.0464	3.0414	3.0446	114632.0
2007-01-31 08:15:00	AAPL	Stock	3.0446	3.0464	3.0446	3.0464	135016.0
2007-01-31 08:20:00	AAPL	Stock	3.0446	3.0446	3.0446	3.0446	14000.0
2007-01-31 08:25:00	AAPL	Stock	3.0446	3.0446	3.0446	3.0446	8792.0
2007-01-31 08:30:00	AAPL	Stock	3.0429	3.0464	3.0357	3.0379	741188.0
2007-01-31 08:35:00	AAPL	Stock	3.0429	3.0446	3.0393	3.0446	75600.0
2007-01-31 08:40:00	AAPL	Stock	3.0446	3.0446	3.0446	3.0446	14000.0
2007-01-31 08:45:00	AAPL	Stock	3.0411	3.0446	3.04	3.0411	99456.0
2007-01-31 08:50:00	AAPL	Stock	3.0446	3.0479	3.0436	3.0446	242732.0
2007-01-31 08:55:00	AAPL	Stock	3.0446	3.0446	3.0411	3.0421	123060.0
2007-01-31 09:00:00	AAPL	Stock	3.0411	3.0421	3.04	3.0421	79492.0
2007-01-31 09:05:00	AAPL	Stock	3.0432	3.0457	3.0429	3.0457	271040.0
2007-01-31 09:10:00	AAPL	Stock	3.0454	3.0454	3.0429	3.0429	673820.0
2007-01-31 09:15:00	AAPL	Stock	3.0414	3.0429	3.0414	3.0429	78512.0
2007-01-31 09:25:00	AAPL	Stock	3.0429	3.0436	3.0214	3.0314	4105276.0
2007-01-31 09:30:00	AAPL	Stock	3.0307	3.0407	3.0286	3.0318	36998360.0
2007-01-31 09:35:00	AAPL	Stock	3.0318	3.0325	3.0154	3.0221	27038872.0
2007-01-31 09:40:00	AAPL	Stock	3.0218	3.0225	3.0125	3.0186	24175704.0
2007-01-31 09:45:00	AAPL	Stock	3.0189	3.0264	3.0164	3.0261	19175772.0
2007-01-31 09:50:00	AAPL	Stock	3.0261	3.0264	3.0161	3.0207	15041236.0
2007-01-31 09:55:00	AAPL	Stock	3.0207	3.0239	3.0168	3.0193	10779832.0
2007-01-31 10:00:00	AAPL	Stock	3.0196	3.025	3.0182	3.0225	9883860.0
2007-01-31 10:05:00	AAPL	Stock	3.0225	3.0357	3.0186	3.0336	15847412.0
2007-01-31 10:10:00	AAPL	Stock	3.0339	3.0429	3.0264	3.0311	28514668.0
2007-01-31 10:15:00	AAPL	Stock	3.0314	3.0325	3.0254	3.0279	8517852.0
2007-01-31 10:20:00	AAPL	Stock	3.0282	3.0361	3.0271	3.0354	10527104.0
2007-01-31 10:25:00	AAPL	Stock	3.0357	3.0375	3.0214	3.0325	12908476.0
2007-01-31 10:30:00	AAPL	Stock	3.0325	3.0443	3.0293	3.0414	15010744.0
2007-01-31 10:35:00	AAPL	Stock	3.0411	3.0429	3.0321	3.0354	19358416.0
2007-01-31 10:40:00	AAPL	Stock	3.035	3.0364	3.0321	3.035	11303040.0
2007-01-31 10:45:00	AAPL	Stock	3.035	3.0375	3.0321	3.0332	7341292.0
2007-01-31 10:50:00	AAPL	Stock	3.0332	3.0371	3.0289	3.0321	8593424.0
2007-01-31 10:55:00	AAPL	Stock	3.0321	3.0396	3.0321	3.0371	8025220.0
2007-01-31 11:00:00	AAPL	Stock	3.0371	3.0375	3.0321	3.0329	6906004.0
2007-01-31 11:05:00	AAPL	Stock	3.0329	3.035	3.0296	3.0346	6404440.0
2007-01-31 11:10:00	AAPL	Stock	3.0343	3.035	3.0311	3.0321	3255252.0
2007-01-31 11:15:00	AAPL	Stock	3.0321	3.0332	3.0279	3.03	6209392.0
2007-01-31 11:20:00	AAPL	Stock	3.0296	3.0339	3.0254	3.0282	6006056.0
2007-01-31 11:25:00	AAPL	Stock	3.0286	3.0304	3.0275	3.0282	3223108.0
2007-01-31 11:30:00	AAPL	Stock	3.0282	3.0307	3.0268	3.0285	3686116.0
2007-01-31 11:35:00	AAPL	Stock	3.0282	3.0304	3.0264	3.0268	3943660.0
2007-01-31 11:40:00	AAPL	Stock	3.0268	3.0286	3.0232	3.0264	6554968.0
2007-01-31 11:45:00	AAPL	Stock	3.0271	3.0321	3.0268	3.0311	5089392.0

> showing 50 of 244,993 rows — these rows as CSV

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