PREVIEW / stock_5min / 2009-09-01

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-01.parquet
  size:    4.9 MB
  rows:    332,765
  symbols: 3,378

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
2009-09-01 04:55:00	AAPL	Stock	6.0282	6.0282	6.0282	6.0282	2800.0
2009-09-01 05:25:00	AAPL	Stock	5.9489	5.9489	5.9489	5.9489	2800.0
2009-09-01 06:20:00	AAPL	Stock	5.9143	5.9286	5.9143	5.9286	8400.0
2009-09-01 06:25:00	AAPL	Stock	5.9143	5.9357	5.9143	5.9304	14000.0
2009-09-01 06:30:00	AAPL	Stock	5.9321	5.9321	5.9321	5.9321	2800.0
2009-09-01 06:40:00	AAPL	Stock	5.9289	5.9289	5.9289	5.9289	2800.0
2009-09-01 06:45:00	AAPL	Stock	5.9286	5.9286	5.9286	5.9286	5600.0
2009-09-01 07:05:00	AAPL	Stock	5.9621	5.9643	5.9621	5.9643	24024.0
2009-09-01 07:10:00	AAPL	Stock	5.9643	5.9643	5.9643	5.9643	11228.0
2009-09-01 07:20:00	AAPL	Stock	5.9571	5.9696	5.9571	5.9696	34888.0
2009-09-01 07:25:00	AAPL	Stock	5.9821	5.9821	5.9821	5.9821	5600.0
2009-09-01 07:30:00	AAPL	Stock	5.9786	5.9786	5.9786	5.9786	2800.0
2009-09-01 07:35:00	AAPL	Stock	5.98	5.9911	5.98	5.9871	18648.0
2009-09-01 07:55:00	AAPL	Stock	5.9786	6.0	5.9725	5.9725	64008.0
2009-09-01 08:00:00	AAPL	Stock	5.9871	6.0075	5.9786	5.9929	807828.0
2009-09-01 08:05:00	AAPL	Stock	5.9954	6.0057	5.9954	6.0054	114016.0
2009-09-01 08:10:00	AAPL	Stock	6.0064	6.0214	6.0064	6.0211	107408.0
2009-09-01 08:15:00	AAPL	Stock	6.0179	6.0179	6.0179	6.0179	2800.0
2009-09-01 08:20:00	AAPL	Stock	6.0132	6.0179	6.0093	6.0143	126700.0
2009-09-01 08:25:00	AAPL	Stock	6.0143	6.0143	6.0036	6.0036	37184.0
2009-09-01 08:30:00	AAPL	Stock	6.0061	6.0061	6.0004	6.0004	8400.0
2009-09-01 08:35:00	AAPL	Stock	6.0057	6.0086	6.0057	6.0057	61600.0
2009-09-01 08:40:00	AAPL	Stock	6.0071	6.0179	6.0025	6.0143	380212.0
2009-09-01 08:45:00	AAPL	Stock	6.0143	6.0196	6.0143	6.0143	53200.0
2009-09-01 08:50:00	AAPL	Stock	6.0107	6.0196	6.0107	6.0179	88704.0
2009-09-01 08:55:00	AAPL	Stock	6.0179	6.0179	6.0139	6.0139	42000.0
2009-09-01 09:00:00	AAPL	Stock	6.0107	6.0107	6.0104	6.0104	53228.0
2009-09-01 09:05:00	AAPL	Stock	6.0071	6.0104	6.0014	6.0014	91840.0
2009-09-01 09:10:00	AAPL	Stock	6.0014	6.0043	5.9936	5.9936	88900.0
2009-09-01 09:15:00	AAPL	Stock	5.995	6.0004	5.9914	5.9929	154700.0
2009-09-01 09:20:00	AAPL	Stock	5.9882	6.0	5.9857	5.9936	42672.0
2009-09-01 09:25:00	AAPL	Stock	6.0	6.0057	6.0	6.0057	89600.0
2009-09-01 09:30:00	AAPL	Stock	5.9996	6.0475	5.9975	6.0386	8448496.0
2009-09-01 09:35:00	AAPL	Stock	6.0375	6.0525	6.0357	6.0507	9512748.0
2009-09-01 09:40:00	AAPL	Stock	6.0514	6.06	6.0446	6.0596	9660280.0
2009-09-01 09:45:00	AAPL	Stock	6.0593	6.0679	6.0514	6.0571	6070456.0
2009-09-01 09:50:00	AAPL	Stock	6.0571	6.0689	6.0557	6.0589	6846812.0
2009-09-01 09:55:00	AAPL	Stock	6.0593	6.0686	6.0579	6.06	3993920.0
2009-09-01 10:00:00	AAPL	Stock	6.0593	6.0714	6.05	6.0639	9703260.0
2009-09-01 10:05:00	AAPL	Stock	6.0639	6.0714	6.0621	6.0681	6620040.0
2009-09-01 10:10:00	AAPL	Stock	6.0693	6.0696	6.0496	6.05	6774096.0
2009-09-01 10:15:00	AAPL	Stock	6.0504	6.0568	6.0454	6.0475	8516172.0
2009-09-01 10:20:00	AAPL	Stock	6.0479	6.0579	6.0432	6.0543	4185496.0
2009-09-01 10:25:00	AAPL	Stock	6.055	6.0682	6.0546	6.0632	4418316.0
2009-09-01 10:30:00	AAPL	Stock	6.0632	6.0679	6.0593	6.0643	3321472.0
2009-09-01 10:35:00	AAPL	Stock	6.065	6.0689	6.0646	6.0661	3765300.0
2009-09-01 10:40:00	AAPL	Stock	6.0661	6.0679	6.0554	6.0559	3747968.0
2009-09-01 10:45:00	AAPL	Stock	6.0568	6.0643	6.0554	6.0632	3406368.0
2009-09-01 10:50:00	AAPL	Stock	6.0625	6.0631	6.0389	6.042	5975844.0
2009-09-01 10:55:00	AAPL	Stock	6.0418	6.0421	6.0221	6.0222	8251796.0

> showing 50 of 332,765 rows — these rows as CSV

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