PREVIEW / stock_30min / 2007-08-21

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-21.parquet
  size:    1.1 MB
  rows:    64,664
  symbols: 3,117

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-08-21 09:30:00	AAPL	Stock	4.3646	4.4068	4.3214	4.3929	78084412.0
2007-08-21 10:00:00	AAPL	Stock	4.3929	4.4214	4.3654	4.4125	67746868.0
2007-08-21 10:30:00	AAPL	Stock	4.4116	4.5582	4.4116	4.5386	248236688.0
2007-08-21 11:00:00	AAPL	Stock	4.5411	4.6	4.4736	4.5464	148794660.0
2007-08-21 11:30:00	AAPL	Stock	4.545	4.6057	4.545	4.5939	125237028.0
2007-08-21 12:00:00	AAPL	Stock	4.5939	4.5982	4.5493	4.5496	85620584.0
2007-08-21 12:30:00	AAPL	Stock	4.5496	4.5589	4.53	4.5554	81283356.0
2007-08-21 13:00:00	AAPL	Stock	4.555	4.5714	4.5332	4.5686	52488548.0
2007-08-21 13:30:00	AAPL	Stock	4.5696	4.5875	4.5511	4.56	64166676.0
2007-08-21 14:00:00	AAPL	Stock	4.5593	4.5729	4.5536	4.5632	49957208.0
2007-08-21 14:30:00	AAPL	Stock	4.5632	4.5664	4.5211	4.5561	83348300.0
2007-08-21 15:00:00	AAPL	Stock	4.5564	4.5893	4.5339	4.5511	66245676.0
2007-08-21 15:30:00	AAPL	Stock	4.5511	4.5643	4.5407	4.5589	103357940.0
2007-08-21 16:00:00	AAPL	Stock	4.5561	4.5584	4.5561	4.5561	7477428.0
2007-08-21 09:30:00	MSFT	Stock	28.1	28.32	28.08	28.23	3408739.0
2007-08-21 10:00:00	MSFT	Stock	28.221	28.23	27.99	28.04	3546557.0
2007-08-21 10:30:00	MSFT	Stock	28.04	28.05	27.9	27.948	3926704.0
2007-08-21 11:00:00	MSFT	Stock	27.95	27.97	27.87	27.95	3981567.0
2007-08-21 11:30:00	MSFT	Stock	27.95	28.09	27.941	28.06	4007261.0
2007-08-21 12:00:00	MSFT	Stock	28.06	28.23	28.01	28.2	4019147.0
2007-08-21 12:30:00	MSFT	Stock	28.2	28.23	27.99	28.05	3415193.0
2007-08-21 13:00:00	MSFT	Stock	28.06	28.1	28.02	28.03	1552754.0
2007-08-21 13:30:00	MSFT	Stock	28.03	28.07	28.0	28.021	1640314.0
2007-08-21 14:00:00	MSFT	Stock	28.02	28.1	28.02	28.06	1695951.0
2007-08-21 14:30:00	MSFT	Stock	28.06	28.07	27.9	27.933	3114181.0
2007-08-21 15:00:00	MSFT	Stock	27.94	27.97	27.9	27.93	2662165.0
2007-08-21 15:30:00	MSFT	Stock	27.93	28.09	27.93	28.08	6762394.0
2007-08-21 16:00:00	MSFT	Stock	28.07	28.07	28.07	28.07	1327894.0
2007-08-21 08:00:00	NVDA	Stock	0.7492	0.7542	0.7492	0.7542	588000.0
2007-08-21 09:00:00	NVDA	Stock	0.7483	0.7508	0.745	0.7508	561480.0
2007-08-21 09:30:00	NVDA	Stock	0.7512	0.7532	0.7425	0.744	41517660.0
2007-08-21 10:00:00	NVDA	Stock	0.7438	0.7492	0.7417	0.7478	33416580.0
2007-08-21 10:30:00	NVDA	Stock	0.7478	0.7558	0.7477	0.7542	35849520.0
2007-08-21 11:00:00	NVDA	Stock	0.7543	0.7662	0.7537	0.7655	48990000.0
2007-08-21 11:30:00	NVDA	Stock	0.7655	0.77	0.7648	0.7693	62934720.0
2007-08-21 12:00:00	NVDA	Stock	0.7695	0.78	0.7682	0.779	39784320.0
2007-08-21 12:30:00	NVDA	Stock	0.7792	0.7795	0.7737	0.777	34512960.0
2007-08-21 13:00:00	NVDA	Stock	0.7773	0.7897	0.7767	0.7878	64186380.0
2007-08-21 13:30:00	NVDA	Stock	0.7882	0.7948	0.7877	0.7921	72889140.0
2007-08-21 14:00:00	NVDA	Stock	0.792	0.7945	0.7883	0.79	56633160.0
2007-08-21 14:30:00	NVDA	Stock	0.79	0.7928	0.788	0.7928	60746400.0
2007-08-21 15:00:00	NVDA	Stock	0.7927	0.7932	0.7845	0.7875	57662400.0
2007-08-21 15:30:00	NVDA	Stock	0.7877	0.7917	0.7873	0.7893	66547200.0
2007-08-21 16:00:00	NVDA	Stock	0.7882	0.7888	0.7857	0.7877	18200040.0
2007-08-21 16:30:00	NVDA	Stock	0.7872	0.7875	0.7867	0.7875	132000.0
2007-08-21 17:00:00	NVDA	Stock	0.7875	0.7875	0.7858	0.7875	95760.0
2007-08-21 18:00:00	NVDA	Stock	0.7875	0.7888	0.787	0.7875	306900.0
2007-08-21 18:30:00	NVDA	Stock	0.7862	0.7862	0.7858	0.786	48000.0
2007-08-21 19:00:00	NVDA	Stock	0.7875	0.7875	0.7863	0.7863	12000.0
2007-08-21 19:30:00	NVDA	Stock	0.786	0.786	0.786	0.786	15360.0

> showing 50 of 64,664 rows — these rows as CSV

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