PREVIEW / stock_30min / 2007-04-04

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-04.parquet
  size:    1023 KB
  rows:    55,114
  symbols: 2,551

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-04-04 07:00:00	AAPL	Stock	3.3854	3.3961	3.3839	3.3961	233800.0
2007-04-04 07:30:00	AAPL	Stock	3.4014	3.4014	3.3893	3.3893	252000.0
2007-04-04 08:00:00	AAPL	Stock	3.3893	3.3964	3.3857	3.3857	1242752.0
2007-04-04 08:30:00	AAPL	Stock	3.3871	3.3875	3.3839	3.3846	320712.0
2007-04-04 09:00:00	AAPL	Stock	3.3846	3.3929	3.375	3.3911	5045908.0
2007-04-04 09:30:00	AAPL	Stock	3.3904	3.3914	3.3696	3.3757	59177580.0
2007-04-04 10:00:00	AAPL	Stock	3.3754	3.3979	3.3661	3.3932	84326508.0
2007-04-04 10:30:00	AAPL	Stock	3.3929	3.3954	3.3761	3.3836	49255948.0
2007-04-04 11:00:00	AAPL	Stock	3.3832	3.3911	3.3825	3.3843	26713764.0
2007-04-04 11:30:00	AAPL	Stock	3.3843	3.3857	3.3725	3.38	31133704.0
2007-04-04 12:00:00	AAPL	Stock	3.38	3.3875	3.3779	3.3825	31440108.0
2007-04-04 12:30:00	AAPL	Stock	3.3829	3.3875	3.3811	3.3857	11443684.0
2007-04-04 13:00:00	AAPL	Stock	3.3857	3.3875	3.375	3.3764	20134884.0
2007-04-04 13:30:00	AAPL	Stock	3.3761	3.3775	3.3732	3.3761	19846932.0
2007-04-04 14:00:00	AAPL	Stock	3.3761	3.3796	3.3736	3.3761	15402716.0
2007-04-04 14:30:00	AAPL	Stock	3.3764	3.3818	3.3668	3.3701	30906540.0
2007-04-04 15:00:00	AAPL	Stock	3.3701	3.3907	3.3661	3.3716	20317920.0
2007-04-04 15:30:00	AAPL	Stock	3.3714	3.3736	3.3618	3.3675	52615640.0
2007-04-04 16:00:00	AAPL	Stock	3.3675	3.3682	3.3639	3.3682	9068892.0
2007-04-04 16:30:00	AAPL	Stock	3.3679	3.3746	3.3679	3.3686	923720.0
2007-04-04 17:00:00	AAPL	Stock	3.3707	3.3707	3.37	3.37	77000.0
2007-04-04 17:30:00	AAPL	Stock	3.3696	3.3707	3.3696	3.3704	36400.0
2007-04-04 18:00:00	AAPL	Stock	3.3704	3.3704	3.3704	3.3704	31892.0
2007-04-04 18:30:00	AAPL	Stock	3.3696	3.3707	3.3696	3.3707	98308.0
2007-04-04 19:00:00	AAPL	Stock	3.3718	3.3718	3.3714	3.3718	81200.0
2007-04-04 19:30:00	AAPL	Stock	3.3729	3.3729	3.3696	3.3696	53032.0
2007-04-04 07:00:00	MSFT	Stock	27.83	27.85	27.83	27.85	3500.0
2007-04-04 08:00:00	MSFT	Stock	27.87	27.92	27.87	27.92	3255.0
2007-04-04 08:30:00	MSFT	Stock	27.87	27.91	27.87	27.91	8307.0
2007-04-04 09:00:00	MSFT	Stock	27.92	28.13	27.87	28.01	533034.0
2007-04-04 09:30:00	MSFT	Stock	28.01	28.27	27.9	28.21	7249948.0
2007-04-04 10:00:00	MSFT	Stock	28.21	28.35	28.12	28.33	5054261.0
2007-04-04 10:30:00	MSFT	Stock	28.33	28.38	28.24	28.35	3901713.0
2007-04-04 11:00:00	MSFT	Stock	28.34	28.38	28.27	28.38	3055904.0
2007-04-04 11:30:00	MSFT	Stock	28.37	28.55	28.37	28.53	5146115.0
2007-04-04 12:00:00	MSFT	Stock	28.52	28.78	28.5	28.67	5694980.0
2007-04-04 12:30:00	MSFT	Stock	28.67	28.68	28.57	28.6	2574591.0
2007-04-04 13:00:00	MSFT	Stock	28.6	28.62	28.43	28.47	3191228.0
2007-04-04 13:30:00	MSFT	Stock	28.48	28.62	28.47	28.53	1940789.0
2007-04-04 14:00:00	MSFT	Stock	28.54	28.63	28.51	28.58	2211615.0
2007-04-04 14:30:00	MSFT	Stock	28.58	28.6	28.52	28.53	2390341.0
2007-04-04 15:00:00	MSFT	Stock	28.532	28.6	28.52	28.56	2766100.0
2007-04-04 15:30:00	MSFT	Stock	28.57	28.62	28.45	28.5	8740295.0
2007-04-04 16:00:00	MSFT	Stock	28.5	28.52	28.5	28.51	376786.0
2007-04-04 16:30:00	MSFT	Stock	28.5	28.52	28.5	28.52	2500.0
2007-04-04 17:00:00	MSFT	Stock	28.52	28.53	28.51	28.53	1145.0
2007-04-04 17:30:00	MSFT	Stock	28.53	28.53	28.53	28.53	200.0
2007-04-04 18:00:00	MSFT	Stock	28.52	28.52	28.52	28.52	1154.0
2007-04-04 18:30:00	MSFT	Stock	28.52	28.52	28.52	28.52	500.0
2007-04-04 19:00:00	MSFT	Stock	28.52	28.52	28.52	28.52	200.0

> showing 50 of 55,114 rows — these rows as CSV

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