PREVIEW / stock_5min / 2007-01-23

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-01-23.parquet
  size:    3.4 MB
  rows:    245,182
  symbols: 2,499

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-23 05:55:00	AAPL	Stock	3.0932	3.0932	3.0932	3.0932	28000.0
2007-01-23 06:00:00	AAPL	Stock	3.0932	3.0932	3.0911	3.0918	25200.0
2007-01-23 06:20:00	AAPL	Stock	3.0932	3.0932	3.0932	3.0932	2800.0
2007-01-23 07:00:00	AAPL	Stock	3.0914	3.0914	3.0846	3.0846	14000.0
2007-01-23 07:10:00	AAPL	Stock	3.0821	3.0821	3.0821	3.0821	11200.0
2007-01-23 07:20:00	AAPL	Stock	3.0821	3.0821	3.0821	3.0821	39200.0
2007-01-23 07:25:00	AAPL	Stock	3.0807	3.0807	3.0807	3.0807	2800.0
2007-01-23 07:30:00	AAPL	Stock	3.0786	3.0821	3.0786	3.0786	47600.0
2007-01-23 07:35:00	AAPL	Stock	3.0786	3.0804	3.0771	3.0771	61600.0
2007-01-23 07:40:00	AAPL	Stock	3.075	3.0754	3.0682	3.0682	178500.0
2007-01-23 07:45:00	AAPL	Stock	3.0664	3.0664	3.0571	3.0589	243600.0
2007-01-23 07:50:00	AAPL	Stock	3.0586	3.0586	3.0489	3.0536	255780.0
2007-01-23 07:55:00	AAPL	Stock	3.0557	3.0557	3.0539	3.0557	36400.0
2007-01-23 08:00:00	AAPL	Stock	3.0571	3.0679	3.0554	3.0571	1147664.0
2007-01-23 08:05:00	AAPL	Stock	3.0571	3.0664	3.0571	3.0607	830592.0
2007-01-23 08:10:00	AAPL	Stock	3.0614	3.0661	3.0593	3.0614	273140.0
2007-01-23 08:15:00	AAPL	Stock	3.0625	3.0679	3.0625	3.0661	713804.0
2007-01-23 08:20:00	AAPL	Stock	3.0679	3.0729	3.0654	3.0696	581980.0
2007-01-23 08:25:00	AAPL	Stock	3.0696	3.0732	3.0664	3.0689	707364.0
2007-01-23 08:30:00	AAPL	Stock	3.0679	3.0689	3.0646	3.0682	773248.0
2007-01-23 08:35:00	AAPL	Stock	3.0675	3.0721	3.0671	3.0714	788704.0
2007-01-23 08:40:00	AAPL	Stock	3.0711	3.0714	3.0643	3.0657	968940.0
2007-01-23 08:45:00	AAPL	Stock	3.0661	3.0714	3.0654	3.07	1637944.0
2007-01-23 08:50:00	AAPL	Stock	3.0704	3.0786	3.0704	3.0757	870128.0
2007-01-23 08:55:00	AAPL	Stock	3.0757	3.0757	3.0711	3.0714	876792.0
2007-01-23 09:00:00	AAPL	Stock	3.0714	3.075	3.0657	3.0686	1042272.0
2007-01-23 09:05:00	AAPL	Stock	3.0679	3.0696	3.0643	3.0668	894880.0
2007-01-23 09:10:00	AAPL	Stock	3.0671	3.07	3.0671	3.0679	701680.0
2007-01-23 09:15:00	AAPL	Stock	3.0679	3.0696	3.0679	3.0696	968800.0
2007-01-23 09:20:00	AAPL	Stock	3.0689	3.0711	3.0643	3.0661	1003548.0
2007-01-23 09:25:00	AAPL	Stock	3.0661	3.0679	3.0571	3.0611	3144288.0
2007-01-23 09:30:00	AAPL	Stock	3.0614	3.0843	3.0543	3.0829	63598892.0
2007-01-23 09:35:00	AAPL	Stock	3.0825	3.0839	3.0579	3.06	33707604.0
2007-01-23 09:40:00	AAPL	Stock	3.0604	3.0768	3.0539	3.0757	31508372.0
2007-01-23 09:45:00	AAPL	Stock	3.0764	3.0975	3.0679	3.0943	46447744.0
2007-01-23 09:50:00	AAPL	Stock	3.0939	3.1125	3.09	3.1007	41474748.0
2007-01-23 09:55:00	AAPL	Stock	3.1004	3.1014	3.0875	3.09	27849052.0
2007-01-23 10:00:00	AAPL	Stock	3.0914	3.0925	3.0729	3.0786	36218392.0
2007-01-23 10:05:00	AAPL	Stock	3.0782	3.0839	3.0704	3.0782	25272772.0
2007-01-23 10:10:00	AAPL	Stock	3.0782	3.0911	3.0732	3.075	18617284.0
2007-01-23 10:15:00	AAPL	Stock	3.075	3.08	3.0646	3.0696	23286928.0
2007-01-23 10:20:00	AAPL	Stock	3.0689	3.0696	3.0596	3.0671	23359028.0
2007-01-23 10:25:00	AAPL	Stock	3.0671	3.0729	3.0614	3.0725	16733304.0
2007-01-23 10:30:00	AAPL	Stock	3.0729	3.0818	3.0721	3.0786	16471308.0
2007-01-23 10:35:00	AAPL	Stock	3.0679	3.0886	3.0679	3.0843	18574220.0
2007-01-23 10:40:00	AAPL	Stock	3.0846	3.0907	3.0743	3.0754	15800316.0
2007-01-23 10:45:00	AAPL	Stock	3.0754	3.0839	3.0739	3.0779	9650536.0
2007-01-23 10:50:00	AAPL	Stock	3.0779	3.0854	3.0779	3.0818	6268052.0
2007-01-23 10:55:00	AAPL	Stock	3.0811	3.0943	3.0775	3.0936	15269744.0
2007-01-23 11:00:00	AAPL	Stock	3.0921	3.1036	3.0896	3.0986	22739612.0

> showing 50 of 245,182 rows — these rows as CSV

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