PREVIEW / stock_30min / 2008-03-05

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-05.parquet
  size:    1.3 MB
  rows:    72,704
  symbols: 3,249

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-03-05 05:00:00	AAPL	Stock	4.4639	4.4639	4.4639	4.4639	5600.0
2008-03-05 06:00:00	AAPL	Stock	4.4643	4.4821	4.4643	4.4821	58800.0
2008-03-05 06:30:00	AAPL	Stock	4.4818	4.4821	4.4818	4.4821	84000.0
2008-03-05 07:00:00	AAPL	Stock	4.4925	4.4925	4.4714	4.4786	398356.0
2008-03-05 07:30:00	AAPL	Stock	4.4768	4.5129	4.475	4.4957	2752988.0
2008-03-05 08:00:00	AAPL	Stock	4.4893	4.4964	4.4507	4.4607	6369832.0
2008-03-05 08:30:00	AAPL	Stock	4.4596	4.4664	4.4329	4.4511	5136880.0
2008-03-05 09:00:00	AAPL	Stock	4.4511	4.4518	4.4136	4.4136	4966052.0
2008-03-05 09:30:00	AAPL	Stock	4.4136	4.4321	4.3661	4.3839	177091796.0
2008-03-05 10:00:00	AAPL	Stock	4.3836	4.4404	4.3825	4.39	161190456.0
2008-03-05 10:30:00	AAPL	Stock	4.39	4.4264	4.3789	4.4068	95932536.0
2008-03-05 11:00:00	AAPL	Stock	4.4064	4.4268	4.4039	4.42	55407744.0
2008-03-05 11:30:00	AAPL	Stock	4.42	4.4621	4.4157	4.4368	92821820.0
2008-03-05 12:00:00	AAPL	Stock	4.4364	4.4693	4.4189	4.4236	101303132.0
2008-03-05 12:30:00	AAPL	Stock	4.4236	4.7857	4.4143	4.4493	50719116.0
2008-03-05 13:00:00	AAPL	Stock	4.4489	4.4582	4.4039	4.43	76333656.0
2008-03-05 13:30:00	AAPL	Stock	4.4304	4.4314	4.3929	4.405	77195244.0
2008-03-05 14:00:00	AAPL	Stock	4.4054	4.4282	4.3771	4.4182	73181724.0
2008-03-05 14:30:00	AAPL	Stock	4.4179	4.435	4.3971	4.4261	64641612.0
2008-03-05 15:00:00	AAPL	Stock	4.4254	4.4304	4.4086	4.417	66906784.0
2008-03-05 15:30:00	AAPL	Stock	4.4161	4.4486	4.4143	4.4479	82848724.0
2008-03-05 16:00:00	AAPL	Stock	4.4464	4.4486	4.4121	4.4325	14222712.0
2008-03-05 16:30:00	AAPL	Stock	4.4321	4.4464	4.4304	4.4371	1087520.0
2008-03-05 17:00:00	AAPL	Stock	4.4379	4.4786	4.4218	4.4768	6181112.0
2008-03-05 17:30:00	AAPL	Stock	4.4768	4.4964	4.475	4.4921	2548000.0
2008-03-05 18:00:00	AAPL	Stock	4.4907	4.4925	4.4714	4.4768	864780.0
2008-03-05 18:30:00	AAPL	Stock	4.4209	4.4857	4.4209	4.4821	1227912.0
2008-03-05 19:00:00	AAPL	Stock	4.4775	4.4811	4.4736	4.4736	226128.0
2008-03-05 19:30:00	AAPL	Stock	4.4714	4.4732	4.4682	4.4704	146104.0
2008-03-05 04:00:00	MSFT	Stock	27.55	27.55	27.55	27.55	100.0
2008-03-05 06:00:00	MSFT	Stock	27.48	27.48	27.48	27.48	600.0
2008-03-05 07:00:00	MSFT	Stock	27.65	27.8	27.65	27.75	6676.0
2008-03-05 07:30:00	MSFT	Stock	27.77	27.77	27.71	27.75	11778.0
2008-03-05 08:00:00	MSFT	Stock	27.75	27.79	27.63	27.65	17528.0
2008-03-05 08:30:00	MSFT	Stock	27.63	27.66	27.6	27.63	24078.0
2008-03-05 09:00:00	MSFT	Stock	27.62	27.79	27.6	27.72	224186.0
2008-03-05 09:30:00	MSFT	Stock	27.74	27.9	27.7	27.859	8076170.0
2008-03-05 10:00:00	MSFT	Stock	27.85	28.33	27.85	28.32	13473129.0
2008-03-05 10:30:00	MSFT	Stock	28.32	28.41	28.24	28.3	9670105.0
2008-03-05 11:00:00	MSFT	Stock	28.3	28.32	28.22	28.265	5484411.0
2008-03-05 11:30:00	MSFT	Stock	28.26	28.34	28.18	28.2	4984855.0
2008-03-05 12:00:00	MSFT	Stock	28.2	28.38	28.2	28.341	10325443.0
2008-03-05 12:30:00	MSFT	Stock	28.34	28.37	28.27	28.32	5028856.0
2008-03-05 13:00:00	MSFT	Stock	28.33	28.34	28.1	28.1	5757936.0
2008-03-05 13:30:00	MSFT	Stock	28.11	28.11	27.89	28.02	8322662.0
2008-03-05 14:00:00	MSFT	Stock	28.02	28.2	27.96	28.13	6834996.0
2008-03-05 14:30:00	MSFT	Stock	28.13	28.24	28.06	28.12	6048680.0
2008-03-05 15:00:00	MSFT	Stock	28.12	28.12	27.99	28.08	6317555.0
2008-03-05 15:30:00	MSFT	Stock	28.07	28.13	27.98	28.13	10058869.0
2008-03-05 16:00:00	MSFT	Stock	28.14	28.18	28.04	28.14	3324429.0

> showing 50 of 72,704 rows — these rows as CSV

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