PREVIEW / stock_30min / 2007-01-17

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-17.parquet
  size:    978 KB
  rows:    52,986
  symbols: 2,502

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
2007-01-17 07:00:00	AAPL	Stock	3.4729	3.4846	3.4714	3.4839	120400.0
2007-01-17 07:30:00	AAPL	Stock	3.4839	3.4839	3.48	3.4821	688800.0
2007-01-17 08:00:00	AAPL	Stock	3.4811	3.4911	3.4775	3.4857	5738628.0
2007-01-17 08:30:00	AAPL	Stock	3.4846	3.4925	3.4793	3.4818	5809832.0
2007-01-17 09:00:00	AAPL	Stock	3.4818	3.4879	3.4786	3.4843	3641260.0
2007-01-17 09:30:00	AAPL	Stock	3.4843	3.4857	3.4071	3.4179	223392260.0
2007-01-17 10:00:00	AAPL	Stock	3.4182	3.4382	3.4114	3.4268	138807536.0
2007-01-17 10:30:00	AAPL	Stock	3.4271	3.4464	3.425	3.4307	89403524.0
2007-01-17 11:00:00	AAPL	Stock	3.4304	3.4375	3.4268	3.4296	71960420.0
2007-01-17 11:30:00	AAPL	Stock	3.4296	3.4396	3.4282	3.4375	56784252.0
2007-01-17 12:00:00	AAPL	Stock	3.4371	3.4443	3.4336	3.4389	48871200.0
2007-01-17 12:30:00	AAPL	Stock	3.4386	3.4429	3.4232	3.4239	56099652.0
2007-01-17 13:00:00	AAPL	Stock	3.4239	3.4357	3.4154	3.4246	62350932.0
2007-01-17 13:30:00	AAPL	Stock	3.425	3.4321	3.3943	3.4246	48137264.0
2007-01-17 14:00:00	AAPL	Stock	3.4239	3.4304	3.4161	3.4185	62129620.0
2007-01-17 14:30:00	AAPL	Stock	3.4186	3.4304	3.4164	3.4218	69762448.0
2007-01-17 15:00:00	AAPL	Stock	3.4214	3.4239	3.4057	3.4229	105169736.0
2007-01-17 15:30:00	AAPL	Stock	3.4232	3.4243	3.3864	3.3946	195902448.0
2007-01-17 16:00:00	AAPL	Stock	3.393	3.4186	3.3736	3.3843	14447412.0
2007-01-17 16:30:00	AAPL	Stock	3.4643	3.5529	3.4511	3.5	136932320.0
2007-01-17 17:00:00	AAPL	Stock	3.5	3.5071	3.3429	3.3571	157997280.0
2007-01-17 17:30:00	AAPL	Stock	3.3571	3.3911	3.3389	3.3714	68282648.0
2007-01-17 18:00:00	AAPL	Stock	3.3714	3.3714	3.3304	3.3546	21756224.0
2007-01-17 18:30:00	AAPL	Stock	3.3568	3.3668	3.3529	3.3568	4420024.0
2007-01-17 19:00:00	AAPL	Stock	3.3568	3.3629	3.3561	3.3579	2037308.0
2007-01-17 19:30:00	AAPL	Stock	3.3589	3.3643	3.3575	3.3632	1376872.0
2007-01-17 07:30:00	MSFT	Stock	31.12	31.12	31.12	31.12	1700.0
2007-01-17 08:00:00	MSFT	Stock	31.12	31.25	31.12	31.23	36326.0
2007-01-17 08:30:00	MSFT	Stock	31.2	31.34	31.15	31.19	33513.0
2007-01-17 09:00:00	MSFT	Stock	31.19	31.29	31.12	31.26	297480.0
2007-01-17 09:30:00	MSFT	Stock	31.26	31.44	31.21	31.39	9389471.0
2007-01-17 10:00:00	MSFT	Stock	31.39	31.4	31.29	31.3	4216090.0
2007-01-17 10:30:00	MSFT	Stock	31.31	31.39	31.26	31.31	3523860.0
2007-01-17 11:00:00	MSFT	Stock	31.31	31.36	31.28	31.28	2514492.0
2007-01-17 11:30:00	MSFT	Stock	31.29	31.34	31.25	31.32	2883283.0
2007-01-17 12:00:00	MSFT	Stock	31.32	31.39	31.3	31.33	2527689.0
2007-01-17 12:30:00	MSFT	Stock	31.33	31.34	31.27	31.29	1292256.0
2007-01-17 13:00:00	MSFT	Stock	31.3	31.36	31.26	31.27	2254046.0
2007-01-17 13:30:00	MSFT	Stock	31.27	31.34	31.2	31.25	2708835.0
2007-01-17 14:00:00	MSFT	Stock	31.24	31.32	31.16	31.21	4278084.0
2007-01-17 14:30:00	MSFT	Stock	31.21	31.24	31.05	31.07	4692288.0
2007-01-17 15:00:00	MSFT	Stock	31.09	31.11	31.02	31.09	3978429.0
2007-01-17 15:30:00	MSFT	Stock	31.08	31.16	31.01	31.12	7659917.0
2007-01-17 16:00:00	MSFT	Stock	31.12	31.12	31.01	31.1	936025.0
2007-01-17 16:30:00	MSFT	Stock	31.12	31.13	31.03	31.05	1835903.0
2007-01-17 17:00:00	MSFT	Stock	31.06	31.08	31.05	31.08	700.0
2007-01-17 17:30:00	MSFT	Stock	31.05	31.05	30.97	30.97	18809.0
2007-01-17 18:00:00	MSFT	Stock	30.97	31.0	30.81	30.99	38302.0
2007-01-17 18:30:00	MSFT	Stock	30.98	31.0	30.95	30.97	6854.0
2007-01-17 19:00:00	MSFT	Stock	30.93	30.93	30.92	30.92	625.0

> showing 50 of 52,986 rows — these rows as CSV

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