PREVIEW / stock_30min / 2008-02-19

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-19.parquet
  size:    1.2 MB
  rows:    70,164
  symbols: 3,282

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
2008-02-19 04:00:00	AAPL	Stock	4.4854	4.4854	4.4746	4.4746	15400.0
2008-02-19 05:30:00	AAPL	Stock	4.49	4.49	4.49	4.49	7000.0
2008-02-19 06:00:00	AAPL	Stock	4.49	4.4964	4.49	4.4964	61600.0
2008-02-19 06:30:00	AAPL	Stock	4.4964	4.4996	4.4964	4.4996	39200.0
2008-02-19 07:00:00	AAPL	Stock	4.5086	4.5086	4.4964	4.5036	209132.0
2008-02-19 07:30:00	AAPL	Stock	4.5004	4.5175	4.4982	4.5132	280308.0
2008-02-19 08:00:00	AAPL	Stock	4.5132	4.5179	4.495	4.5071	3159688.0
2008-02-19 08:30:00	AAPL	Stock	4.5071	4.5111	4.4936	4.5018	1878716.0
2008-02-19 09:00:00	AAPL	Stock	4.5011	4.505	4.4925	4.5	2965284.0
2008-02-19 09:30:00	AAPL	Stock	4.4989	4.5268	4.4746	4.4854	139466516.0
2008-02-19 10:00:00	AAPL	Stock	4.4857	4.5011	4.4618	4.4679	88338936.0
2008-02-19 10:30:00	AAPL	Stock	4.4675	4.4732	4.45	4.47	76851012.0
2008-02-19 11:00:00	AAPL	Stock	4.47	4.475	4.4543	4.4689	46750760.0
2008-02-19 11:30:00	AAPL	Stock	4.47	4.495	4.4689	4.4925	40992672.0
2008-02-19 12:00:00	AAPL	Stock	4.4932	4.5082	4.4843	4.5075	48701912.0
2008-02-19 12:30:00	AAPL	Stock	4.5068	4.5068	4.4754	4.4861	41098820.0
2008-02-19 13:00:00	AAPL	Stock	4.4861	4.5204	4.4861	4.5133	39872504.0
2008-02-19 13:30:00	AAPL	Stock	4.5139	4.5143	4.4661	4.4718	55329820.0
2008-02-19 14:00:00	AAPL	Stock	4.4714	4.4793	4.4564	4.4611	51072252.0
2008-02-19 14:30:00	AAPL	Stock	4.4614	4.4614	4.3814	4.3818	109648504.0
2008-02-19 15:00:00	AAPL	Stock	4.3839	4.3946	4.3514	4.3521	111965112.0
2008-02-19 15:30:00	AAPL	Stock	4.3521	4.3718	4.3371	4.3714	128850568.0
2008-02-19 16:00:00	AAPL	Stock	4.3714	4.4482	4.3579	4.4179	16858184.0
2008-02-19 16:30:00	AAPL	Stock	4.4179	4.4179	4.3636	4.3636	932176.0
2008-02-19 17:00:00	AAPL	Stock	4.4071	4.5002	4.3636	4.4036	584500.0
2008-02-19 17:30:00	AAPL	Stock	4.4036	4.4036	4.3964	4.3982	212184.0
2008-02-19 18:00:00	AAPL	Stock	4.3982	4.4036	4.3864	4.3936	445004.0
2008-02-19 18:30:00	AAPL	Stock	4.3932	4.3982	4.3896	4.3896	229516.0
2008-02-19 19:00:00	AAPL	Stock	4.3929	4.3929	4.3893	4.3893	119644.0
2008-02-19 19:30:00	AAPL	Stock	4.3875	4.4018	4.3861	4.3961	279860.0
2008-02-19 07:00:00	MSFT	Stock	28.75	28.8	28.75	28.8	1900.0
2008-02-19 07:30:00	MSFT	Stock	28.75	28.84	28.75	28.82	133200.0
2008-02-19 08:00:00	MSFT	Stock	28.8	28.9	28.8	28.87	300568.0
2008-02-19 08:30:00	MSFT	Stock	28.87	28.91	28.68	28.7	143241.0
2008-02-19 09:00:00	MSFT	Stock	28.71	28.83	28.7	28.79	154772.0
2008-02-19 09:30:00	MSFT	Stock	28.8	28.84	28.71	28.798	8898054.0
2008-02-19 10:00:00	MSFT	Stock	28.8	28.81	28.66	28.788	6338081.0
2008-02-19 10:30:00	MSFT	Stock	28.79	28.79	28.621	28.63	4597174.0
2008-02-19 11:00:00	MSFT	Stock	28.628	28.65	28.53	28.6	3367049.0
2008-02-19 11:30:00	MSFT	Stock	28.61	28.65	28.59	28.65	1984376.0
2008-02-19 12:00:00	MSFT	Stock	28.65	28.78	28.61	28.77	3675943.0
2008-02-19 12:30:00	MSFT	Stock	28.77	28.772	28.62	28.62	2421255.0
2008-02-19 13:00:00	MSFT	Stock	28.63	28.71	28.63	28.67	3551109.0
2008-02-19 13:30:00	MSFT	Stock	28.67	28.68	28.56	28.6	4021424.0
2008-02-19 14:00:00	MSFT	Stock	28.6	28.6	28.46	28.46	4142326.0
2008-02-19 14:30:00	MSFT	Stock	28.46	28.47	28.15	28.16	6871682.0
2008-02-19 15:00:00	MSFT	Stock	28.15	28.23	28.07	28.18	6557556.0
2008-02-19 15:30:00	MSFT	Stock	28.19	28.26	28.1	28.2	8038319.0
2008-02-19 16:00:00	MSFT	Stock	28.2	28.85	28.16	28.464	2333701.0
2008-02-19 16:30:00	MSFT	Stock	28.37	28.43	28.17	28.39	50525.0

> showing 50 of 70,164 rows — these rows as CSV

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