PREVIEW / stock_5min / 2009-05-20

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-05-20.parquet
  size:    4.7 MB
  rows:    324,165
  symbols: 3,354

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-05-20 04:45:00	AAPL	Stock	4.5911	4.5911	4.5911	4.5911	2800.0
2009-05-20 07:00:00	AAPL	Stock	4.5632	4.5632	4.5632	4.5632	2800.0
2009-05-20 07:05:00	AAPL	Stock	4.5946	4.5946	4.5946	4.5946	2800.0
2009-05-20 07:20:00	AAPL	Stock	4.5714	4.5714	4.5714	4.5714	2800.0
2009-05-20 07:35:00	AAPL	Stock	4.5711	4.5714	4.5711	4.5714	11200.0
2009-05-20 07:40:00	AAPL	Stock	4.5821	4.5821	4.5821	4.5821	5600.0
2009-05-20 07:50:00	AAPL	Stock	4.58	4.5911	4.58	4.5911	9240.0
2009-05-20 08:00:00	AAPL	Stock	4.5871	4.5875	4.5754	4.5789	55048.0
2009-05-20 08:05:00	AAPL	Stock	4.5789	4.5829	4.5714	4.5714	93828.0
2009-05-20 08:10:00	AAPL	Stock	4.5714	4.5714	4.5696	4.5696	22400.0
2009-05-20 08:15:00	AAPL	Stock	4.5693	4.5693	4.5679	4.5693	22400.0
2009-05-20 08:20:00	AAPL	Stock	4.5693	4.5696	4.5646	4.5682	92904.0
2009-05-20 08:25:00	AAPL	Stock	4.5696	4.5714	4.5679	4.5679	70000.0
2009-05-20 08:30:00	AAPL	Stock	4.5679	4.575	4.5679	4.575	39368.0
2009-05-20 08:35:00	AAPL	Stock	4.575	4.5768	4.575	4.575	99400.0
2009-05-20 08:40:00	AAPL	Stock	4.5768	4.5768	4.575	4.575	16800.0
2009-05-20 08:45:00	AAPL	Stock	4.5761	4.5768	4.5761	4.5768	33600.0
2009-05-20 08:50:00	AAPL	Stock	4.5793	4.5793	4.5679	4.5679	76356.0
2009-05-20 08:55:00	AAPL	Stock	4.5679	4.5711	4.5636	4.5711	83720.0
2009-05-20 09:00:00	AAPL	Stock	4.5714	4.5714	4.5675	4.5675	19880.0
2009-05-20 09:05:00	AAPL	Stock	4.5664	4.5664	4.5657	4.5661	19600.0
2009-05-20 09:10:00	AAPL	Stock	4.5675	4.5682	4.5643	4.5643	81900.0
2009-05-20 09:15:00	AAPL	Stock	4.5636	4.5636	4.5518	4.5557	157556.0
2009-05-20 09:20:00	AAPL	Stock	4.5561	4.5561	4.55	4.5536	142016.0
2009-05-20 09:25:00	AAPL	Stock	4.5529	4.5671	4.55	4.5582	441392.0
2009-05-20 09:30:00	AAPL	Stock	4.5629	4.5632	4.5214	4.5382	16005108.0
2009-05-20 09:35:00	AAPL	Stock	4.5393	4.5407	4.5182	4.5306	11358928.0
2009-05-20 09:40:00	AAPL	Stock	4.5321	4.5782	4.53	4.5714	13354208.0
2009-05-20 09:45:00	AAPL	Stock	4.5718	4.5793	4.5596	4.5718	8410444.0
2009-05-20 09:50:00	AAPL	Stock	4.5732	4.5779	4.5654	4.5671	6141352.0
2009-05-20 09:55:00	AAPL	Stock	4.5668	4.5681	4.5446	4.5446	7263480.0
2009-05-20 10:00:00	AAPL	Stock	4.5475	4.5846	4.5446	4.5744	11326280.0
2009-05-20 10:05:00	AAPL	Stock	4.5725	4.6018	4.5711	4.5939	7737716.0
2009-05-20 10:10:00	AAPL	Stock	4.5943	4.5975	4.5811	4.5871	6402704.0
2009-05-20 10:15:00	AAPL	Stock	4.5889	4.6114	4.5861	4.6039	7166180.0
2009-05-20 10:20:00	AAPL	Stock	4.6043	4.6146	4.6021	4.6059	5917492.0
2009-05-20 10:25:00	AAPL	Stock	4.6064	4.6071	4.5925	4.5971	4467120.0
2009-05-20 10:30:00	AAPL	Stock	4.5979	4.6064	4.5886	4.5893	4221784.0
2009-05-20 10:35:00	AAPL	Stock	4.5893	4.5964	4.5839	4.5907	3466204.0
2009-05-20 10:40:00	AAPL	Stock	4.5907	4.5993	4.5904	4.5954	4798332.0
2009-05-20 10:45:00	AAPL	Stock	4.5961	4.6	4.5911	4.5974	3344740.0
2009-05-20 10:50:00	AAPL	Stock	4.5975	4.6061	4.5929	4.5932	3466848.0
2009-05-20 10:55:00	AAPL	Stock	4.5921	4.5971	4.5882	4.5918	2613632.0
2009-05-20 11:00:00	AAPL	Stock	4.5911	4.6007	4.5907	4.5939	1968540.0
2009-05-20 11:05:00	AAPL	Stock	4.5936	4.5971	4.5839	4.5843	2154124.0
2009-05-20 11:10:00	AAPL	Stock	4.5839	4.5918	4.5821	4.59	2875208.0
2009-05-20 11:15:00	AAPL	Stock	4.5896	4.5939	4.5796	4.58	3299940.0
2009-05-20 11:20:00	AAPL	Stock	4.5807	4.5821	4.5686	4.57	5941040.0
2009-05-20 11:25:00	AAPL	Stock	4.5704	4.5754	4.5689	4.5743	3415468.0
2009-05-20 11:30:00	AAPL	Stock	4.5746	4.5839	4.5732	4.5818	2888844.0

> showing 50 of 324,165 rows — these rows as CSV

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