PREVIEW / stock_30min / 2008-08-14

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-14.parquet
  size:    1.2 MB
  rows:    68,458
  symbols: 3,329

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-08-14 07:00:00	AAPL	Stock	6.4107	6.4214	6.4107	6.4214	44660.0
2008-08-14 07:30:00	AAPL	Stock	6.4214	6.4214	6.4107	6.4211	107660.0
2008-08-14 08:00:00	AAPL	Stock	6.4196	6.4268	6.4107	6.4211	891604.0
2008-08-14 08:30:00	AAPL	Stock	6.4157	6.4157	6.3661	6.3839	1548232.0
2008-08-14 09:00:00	AAPL	Stock	6.3804	6.3875	6.3579	6.3689	1290408.0
2008-08-14 09:30:00	AAPL	Stock	6.3682	6.4446	6.3514	6.4304	126455616.0
2008-08-14 10:00:00	AAPL	Stock	6.4304	6.4375	6.3679	6.4086	82551812.0
2008-08-14 10:30:00	AAPL	Stock	6.4075	6.4282	6.395	6.4157	57489908.0
2008-08-14 11:00:00	AAPL	Stock	6.4161	6.4282	6.4086	6.4194	41026720.0
2008-08-14 11:30:00	AAPL	Stock	6.4193	6.4293	6.3932	6.4025	49941976.0
2008-08-14 12:00:00	AAPL	Stock	6.4032	6.4125	6.375	6.3825	42321916.0
2008-08-14 12:30:00	AAPL	Stock	6.3815	6.4071	6.3764	6.3836	34346032.0
2008-08-14 13:00:00	AAPL	Stock	6.3846	6.4089	6.3825	6.3911	26212536.0
2008-08-14 13:30:00	AAPL	Stock	6.3895	6.4014	6.3607	6.3962	45415748.0
2008-08-14 14:00:00	AAPL	Stock	6.3971	6.4029	6.3804	6.3879	28527660.0
2008-08-14 14:30:00	AAPL	Stock	6.3882	6.4054	6.3732	6.3893	29753472.0
2008-08-14 15:00:00	AAPL	Stock	6.3893	6.4032	6.3611	6.3954	46122860.0
2008-08-14 15:30:00	AAPL	Stock	6.395	6.4079	6.3907	6.4021	57464540.0
2008-08-14 16:00:00	AAPL	Stock	6.4023	6.4089	6.3949	6.4043	25037572.0
2008-08-14 16:30:00	AAPL	Stock	6.4043	6.4075	6.3979	6.4004	452844.0
2008-08-14 17:00:00	AAPL	Stock	6.4018	6.4046	6.4018	6.4021	84672.0
2008-08-14 17:30:00	AAPL	Stock	6.4021	6.4054	6.4007	6.4011	248332.0
2008-08-14 18:00:00	AAPL	Stock	6.4029	6.4036	6.4011	6.4036	19600.0
2008-08-14 18:30:00	AAPL	Stock	6.4018	6.4054	6.4018	6.4036	168476.0
2008-08-14 19:00:00	AAPL	Stock	6.4036	6.4046	6.4036	6.4036	50344.0
2008-08-14 19:30:00	AAPL	Stock	6.405	6.4061	6.4036	6.4057	73360.0
2008-08-14 07:00:00	MSFT	Stock	27.88	27.88	27.88	27.88	100.0
2008-08-14 08:00:00	MSFT	Stock	27.99	27.99	27.83	27.91	10213.0
2008-08-14 08:30:00	MSFT	Stock	27.91	27.96	27.85	27.91	8809.0
2008-08-14 09:00:00	MSFT	Stock	27.88	27.88	27.74	27.79	117218.0
2008-08-14 09:30:00	MSFT	Stock	27.79	28.05	27.6	27.781	6237913.0
2008-08-14 10:00:00	MSFT	Stock	27.78	27.79	27.56	27.62	4866601.0
2008-08-14 10:30:00	MSFT	Stock	27.62	28.06	27.6	27.85	5530616.0
2008-08-14 11:00:00	MSFT	Stock	27.85	28.06	27.8	27.98	4023959.0
2008-08-14 11:30:00	MSFT	Stock	27.97	28.05	27.93	28.04	1523923.0
2008-08-14 12:00:00	MSFT	Stock	28.04	28.17	28.0	28.1	2089203.0
2008-08-14 12:30:00	MSFT	Stock	28.1	28.28	28.07	28.19	2277996.0
2008-08-14 13:00:00	MSFT	Stock	28.198	28.26	28.14	28.18	2141810.0
2008-08-14 13:30:00	MSFT	Stock	28.18	28.19	28.0	28.02	1953728.0
2008-08-14 14:00:00	MSFT	Stock	28.03	28.08	27.95	27.995	2917843.0
2008-08-14 14:30:00	MSFT	Stock	27.99	28.01	27.94	27.95	1793298.0
2008-08-14 15:00:00	MSFT	Stock	27.95	28.0	27.91	27.945	3041793.0
2008-08-14 15:30:00	MSFT	Stock	27.95	27.98	27.87	27.92	4725757.0
2008-08-14 16:00:00	MSFT	Stock	27.9	28.01	27.88	27.91	2740887.0
2008-08-14 16:30:00	MSFT	Stock	27.9	27.959	27.9	27.91	4148.0
2008-08-14 17:00:00	MSFT	Stock	27.96	27.96	27.96	27.96	100.0
2008-08-14 17:30:00	MSFT	Stock	28.042	28.042	27.93	27.93	90000.0
2008-08-14 19:00:00	MSFT	Stock	27.97	27.98	27.95	27.98	2400.0
2008-08-14 19:30:00	MSFT	Stock	27.94	27.94	27.93	27.93	400.0
2008-08-14 08:00:00	NVDA	Stock	0.3075	0.3113	0.3065	0.3088	466640.0

> showing 50 of 68,458 rows — these rows as CSV

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