PREVIEW / stock_30min / 2008-05-23

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-23.parquet
  size:    1.2 MB
  rows:    67,348
  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-05-23 04:00:00	AAPL	Stock	6.4079	6.4086	6.3739	6.3739	56000.0
2008-05-23 04:30:00	AAPL	Stock	6.4214	6.425	6.4214	6.425	78400.0
2008-05-23 05:00:00	AAPL	Stock	6.4268	6.4268	6.4107	6.4107	5600.0
2008-05-23 05:30:00	AAPL	Stock	6.4179	6.4179	6.3982	6.3982	16268.0
2008-05-23 06:00:00	AAPL	Stock	6.4286	6.4286	6.4286	6.4286	2800.0
2008-05-23 06:30:00	AAPL	Stock	6.4125	6.4357	6.4125	6.4357	507752.0
2008-05-23 07:00:00	AAPL	Stock	6.4179	6.4554	6.4179	6.45	689500.0
2008-05-23 07:30:00	AAPL	Stock	6.45	6.525	6.4464	6.5107	3015600.0
2008-05-23 08:00:00	AAPL	Stock	6.5107	6.5182	6.4286	6.475	8142456.0
2008-05-23 08:30:00	AAPL	Stock	6.475	6.4768	6.45	6.4504	4674460.0
2008-05-23 09:00:00	AAPL	Stock	6.4504	6.4818	6.4475	6.4571	4277952.0
2008-05-23 09:30:00	AAPL	Stock	6.4575	6.4889	6.4296	6.4425	149829680.0
2008-05-23 10:00:00	AAPL	Stock	6.4418	6.4964	6.4325	6.4875	83548220.0
2008-05-23 10:30:00	AAPL	Stock	6.4875	6.4875	6.4304	6.468	77242480.0
2008-05-23 11:00:00	AAPL	Stock	6.4671	6.4796	6.4393	6.4664	52153136.0
2008-05-23 11:30:00	AAPL	Stock	6.4664	6.4732	6.4314	6.4536	55746992.0
2008-05-23 12:00:00	AAPL	Stock	6.4521	6.4643	6.4154	6.4268	48995352.0
2008-05-23 12:30:00	AAPL	Stock	6.4264	6.4271	6.35	6.3795	75485844.0
2008-05-23 13:00:00	AAPL	Stock	6.3757	6.4014	6.3689	6.3857	37105432.0
2008-05-23 13:30:00	AAPL	Stock	6.3857	6.4364	6.3839	6.4021	50166452.0
2008-05-23 14:00:00	AAPL	Stock	6.4021	6.4643	6.3957	6.4643	47759040.0
2008-05-23 14:30:00	AAPL	Stock	6.4639	6.4996	6.4464	6.4829	66469732.0
2008-05-23 15:00:00	AAPL	Stock	6.4829	6.4982	6.4396	6.4618	63568876.0
2008-05-23 15:30:00	AAPL	Stock	6.4619	6.4721	6.4382	6.4704	63352296.0
2008-05-23 16:00:00	AAPL	Stock	6.4704	6.4768	6.3232	6.4689	7158508.0
2008-05-23 16:30:00	AAPL	Stock	6.4689	6.4732	6.4661	6.4689	309512.0
2008-05-23 17:00:00	AAPL	Stock	6.4668	6.475	6.465	6.4739	531272.0
2008-05-23 17:30:00	AAPL	Stock	6.475	6.4764	6.4721	6.4743	583744.0
2008-05-23 18:00:00	AAPL	Stock	6.4743	6.4764	6.4743	6.4761	114044.0
2008-05-23 18:30:00	AAPL	Stock	6.4761	6.4768	6.3857	6.4768	412832.0
2008-05-23 19:00:00	AAPL	Stock	6.4768	6.4818	6.4768	6.4818	193396.0
2008-05-23 19:30:00	AAPL	Stock	6.4818	6.4821	6.4789	6.4804	197596.0
2008-05-23 06:00:00	MSFT	Stock	28.35	28.35	28.35	28.35	200.0
2008-05-23 08:00:00	MSFT	Stock	28.47	28.55	28.47	28.48	2719.0
2008-05-23 08:30:00	MSFT	Stock	28.46	28.46	28.46	28.46	1062.0
2008-05-23 09:00:00	MSFT	Stock	28.41	28.42	28.25	28.29	30642.0
2008-05-23 09:30:00	MSFT	Stock	28.26	28.33	28.19	28.24	4081838.0
2008-05-23 10:00:00	MSFT	Stock	28.24	28.27	28.16	28.19	3428733.0
2008-05-23 10:30:00	MSFT	Stock	28.18	28.195	28.05	28.138	4532638.0
2008-05-23 11:00:00	MSFT	Stock	28.13	28.16	28.02	28.06	3705794.0
2008-05-23 11:30:00	MSFT	Stock	28.06	28.12	28.02	28.05	2966104.0
2008-05-23 12:00:00	MSFT	Stock	28.04	28.19	28.04	28.162	3264685.0
2008-05-23 12:30:00	MSFT	Stock	28.16	28.18	28.04	28.07	2278416.0
2008-05-23 13:00:00	MSFT	Stock	28.08	28.11	28.05	28.06	1530485.0
2008-05-23 13:30:00	MSFT	Stock	28.07	28.12	28.04	28.06	2210425.0
2008-05-23 14:00:00	MSFT	Stock	28.05	28.08	28.0	28.05	3040359.0
2008-05-23 14:30:00	MSFT	Stock	28.05	28.07	28.01	28.022	3144830.0
2008-05-23 15:00:00	MSFT	Stock	28.03	28.08	27.95	28.05	4507216.0
2008-05-23 15:30:00	MSFT	Stock	28.06	28.09	27.95	28.05	6895375.0
2008-05-23 16:00:00	MSFT	Stock	28.05	28.47	28.01	28.02	1633552.0

> showing 50 of 67,348 rows — these rows as CSV

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