PREVIEW / stock_30min / 2008-04-04

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-04.parquet
  size:    1.2 MB
  rows:    66,890
  symbols: 3,262

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-04-04 07:00:00	AAPL	Stock	5.4286	5.4286	5.4286	5.4286	8400.0
2008-04-04 07:30:00	AAPL	Stock	5.4421	5.4464	5.4321	5.4386	46564.0
2008-04-04 08:00:00	AAPL	Stock	5.4393	5.4636	5.4375	5.4443	2656724.0
2008-04-04 08:30:00	AAPL	Stock	5.4446	5.4464	5.3668	5.4439	9574152.0
2008-04-04 09:00:00	AAPL	Stock	5.4446	5.4471	5.4071	5.4321	3543148.0
2008-04-04 09:30:00	AAPL	Stock	5.4346	5.4761	5.3982	5.4414	131454428.0
2008-04-04 10:00:00	AAPL	Stock	5.4414	5.4604	5.3875	5.4321	98171332.0
2008-04-04 10:30:00	AAPL	Stock	5.4318	5.4396	5.385	5.4314	76995660.0
2008-04-04 11:00:00	AAPL	Stock	5.4314	5.4539	5.4214	5.4518	58072224.0
2008-04-04 11:30:00	AAPL	Stock	5.4518	5.46	5.4218	5.4304	44738512.0
2008-04-04 12:00:00	AAPL	Stock	5.4309	5.4679	5.4271	5.4619	49623196.0
2008-04-04 12:30:00	AAPL	Stock	5.4611	5.4911	5.4543	5.4886	37836680.0
2008-04-04 13:00:00	AAPL	Stock	5.4889	5.5232	5.4796	5.5221	51866080.0
2008-04-04 13:30:00	AAPL	Stock	5.5225	5.5255	5.4889	5.4918	42056896.0
2008-04-04 14:00:00	AAPL	Stock	5.4918	5.5089	5.4702	5.4814	42364476.0
2008-04-04 14:30:00	AAPL	Stock	5.4811	5.4911	5.4657	5.4732	36728972.0
2008-04-04 15:00:00	AAPL	Stock	5.4732	5.4793	5.4321	5.4398	60145624.0
2008-04-04 15:30:00	AAPL	Stock	5.4393	5.4725	5.4371	5.4671	74728332.0
2008-04-04 16:00:00	AAPL	Stock	5.4671	5.4671	5.4429	5.4607	7526568.0
2008-04-04 16:30:00	AAPL	Stock	5.4607	5.4671	5.4579	5.46	1109332.0
2008-04-04 17:00:00	AAPL	Stock	5.4607	5.4889	5.3975	5.4746	766444.0
2008-04-04 17:30:00	AAPL	Stock	5.4732	5.4793	5.46	5.4775	1375724.0
2008-04-04 18:00:00	AAPL	Stock	5.48	5.4804	5.4757	5.4757	83552.0
2008-04-04 18:30:00	AAPL	Stock	5.4764	5.4786	5.4736	5.475	66052.0
2008-04-04 19:00:00	AAPL	Stock	5.4736	5.4786	5.4736	5.4757	137872.0
2008-04-04 19:30:00	AAPL	Stock	5.4757	5.4775	5.4721	5.4746	152432.0
2008-04-04 08:00:00	MSFT	Stock	29.09	29.22	29.08	29.15	28938.0
2008-04-04 08:30:00	MSFT	Stock	29.1	29.18	29.06	29.17	15751.0
2008-04-04 09:00:00	MSFT	Stock	29.18	29.18	29.11	29.14	53111.0
2008-04-04 09:30:00	MSFT	Stock	29.13	29.15	28.76	28.9	5171431.0
2008-04-04 10:00:00	MSFT	Stock	28.91	28.93	28.75	28.81	3714768.0
2008-04-04 10:30:00	MSFT	Stock	28.8	28.88	28.74	28.85	2675503.0
2008-04-04 11:00:00	MSFT	Stock	28.85	28.92	28.8	28.909	2125152.0
2008-04-04 11:30:00	MSFT	Stock	28.92	28.96	28.828	28.89	1977768.0
2008-04-04 12:00:00	MSFT	Stock	28.88	29.11	28.88	29.0	3594424.0
2008-04-04 12:30:00	MSFT	Stock	28.99	29.19	28.95	29.171	2433863.0
2008-04-04 13:00:00	MSFT	Stock	29.17	29.26	29.11	29.24	2640550.0
2008-04-04 13:30:00	MSFT	Stock	29.24	29.25	29.1	29.11	1503850.0
2008-04-04 14:00:00	MSFT	Stock	29.11	29.195	29.11	29.19	1924720.0
2008-04-04 14:30:00	MSFT	Stock	29.2	29.23	29.12	29.17	2016808.0
2008-04-04 15:00:00	MSFT	Stock	29.16	29.23	29.13	29.2	4279292.0
2008-04-04 15:30:00	MSFT	Stock	29.2	29.21	29.09	29.16	6156693.0
2008-04-04 16:00:00	MSFT	Stock	29.16	29.75	29.028	29.74	2247573.0
2008-04-04 16:30:00	MSFT	Stock	29.7	29.75	29.38	29.4	473595.0
2008-04-04 17:00:00	MSFT	Stock	29.43	29.58	29.4	29.4	68416.0
2008-04-04 17:30:00	MSFT	Stock	29.41	29.55	29.4	29.55	16671.0
2008-04-04 18:00:00	MSFT	Stock	29.55	29.67	29.46	29.67	49055.0
2008-04-04 18:30:00	MSFT	Stock	29.67	29.67	29.53	29.6	15620.0
2008-04-04 19:00:00	MSFT	Stock	29.6	29.63	29.6	29.6	2861.0
2008-04-04 19:30:00	MSFT	Stock	29.57	29.63	29.56	29.6	10246.0

> showing 50 of 66,890 rows — these rows as CSV

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