PREVIEW / stock_30min / 2007-01-16

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-16.parquet
  size:    998 KB
  rows:    53,615
  symbols: 2,509

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-16 04:00:00	AAPL	Stock	3.4114	3.4114	3.4114	3.4114	11200.0
2007-01-16 05:30:00	AAPL	Stock	3.4175	3.4257	3.4018	3.4018	22400.0
2007-01-16 06:00:00	AAPL	Stock	3.4229	3.4229	3.4143	3.4143	8400.0
2007-01-16 06:30:00	AAPL	Stock	3.4107	3.4107	3.4107	3.4107	16800.0
2007-01-16 07:00:00	AAPL	Stock	3.4179	3.4179	3.4071	3.4171	207200.0
2007-01-16 07:30:00	AAPL	Stock	3.4143	3.4232	3.4071	3.4071	1312052.0
2007-01-16 08:00:00	AAPL	Stock	3.4157	3.4236	3.4075	3.4204	5754448.0
2007-01-16 08:30:00	AAPL	Stock	3.4207	3.4214	3.4107	3.4125	3075156.0
2007-01-16 09:00:00	AAPL	Stock	3.4114	3.4193	3.4046	3.4175	12804820.0
2007-01-16 09:30:00	AAPL	Stock	3.4171	3.4482	3.4089	3.4389	224962612.0
2007-01-16 10:00:00	AAPL	Stock	3.4382	3.44	3.4171	3.4339	163083536.0
2007-01-16 10:30:00	AAPL	Stock	3.4339	3.4425	3.4225	3.4239	89800200.0
2007-01-16 11:00:00	AAPL	Stock	3.4239	3.4435	3.4236	3.44	82381068.0
2007-01-16 11:30:00	AAPL	Stock	3.4404	3.4521	3.4382	3.4468	92030988.0
2007-01-16 12:00:00	AAPL	Stock	3.4468	3.4564	3.4457	3.4561	61890584.0
2007-01-16 12:30:00	AAPL	Stock	3.4561	3.4625	3.4429	3.45	65857652.0
2007-01-16 13:00:00	AAPL	Stock	3.4493	3.4571	3.4464	3.451	38332000.0
2007-01-16 13:30:00	AAPL	Stock	3.4511	3.4554	3.445	3.45	34462372.0
2007-01-16 14:00:00	AAPL	Stock	3.45	3.4629	3.4457	3.4579	53242196.0
2007-01-16 14:30:00	AAPL	Stock	3.4579	3.4732	3.4579	3.4618	94552276.0
2007-01-16 15:00:00	AAPL	Stock	3.4614	3.4693	3.4529	3.4593	75152280.0
2007-01-16 15:30:00	AAPL	Stock	3.4593	3.4696	3.4571	3.4682	106830696.0
2007-01-16 16:00:00	AAPL	Stock	3.4661	3.4696	3.3589	3.4643	5125428.0
2007-01-16 16:30:00	AAPL	Stock	3.4625	3.4625	3.4568	3.4571	10818108.0
2007-01-16 17:00:00	AAPL	Stock	3.4557	3.4593	3.4546	3.4589	629076.0
2007-01-16 17:30:00	AAPL	Stock	3.4586	3.4607	3.4561	3.4586	375480.0
2007-01-16 18:00:00	AAPL	Stock	3.4589	3.4618	3.4571	3.4611	381864.0
2007-01-16 18:30:00	AAPL	Stock	3.4607	3.4607	3.4571	3.4571	305592.0
2007-01-16 19:00:00	AAPL	Stock	3.4575	3.4643	3.4571	3.4639	249396.0
2007-01-16 19:30:00	AAPL	Stock	3.4639	3.4675	3.4629	3.4675	449764.0
2007-01-16 04:00:00	MSFT	Stock	31.36	31.36	31.36	31.36	200.0
2007-01-16 05:00:00	MSFT	Stock	31.32	31.32	31.32	31.32	1000.0
2007-01-16 05:30:00	MSFT	Stock	31.34	31.34	31.34	31.34	500.0
2007-01-16 07:00:00	MSFT	Stock	31.25	31.25	31.25	31.25	800.0
2007-01-16 07:30:00	MSFT	Stock	31.32	31.32	31.23	31.25	8922.0
2007-01-16 08:00:00	MSFT	Stock	31.25	31.28	31.25	31.27	9637.0
2007-01-16 08:30:00	MSFT	Stock	31.27	31.28	31.16	31.17	78555.0
2007-01-16 09:00:00	MSFT	Stock	31.18	31.26	31.16	31.26	93117.0
2007-01-16 09:30:00	MSFT	Stock	31.26	31.45	31.2	31.35	11812060.0
2007-01-16 10:00:00	MSFT	Stock	31.35	31.35	31.26	31.3	4291815.0
2007-01-16 10:30:00	MSFT	Stock	31.31	31.33	31.12	31.17	6565973.0
2007-01-16 11:00:00	MSFT	Stock	31.18	31.22	31.12	31.13	3935104.0
2007-01-16 11:30:00	MSFT	Stock	31.13	31.27	31.03	31.08	5780573.0
2007-01-16 12:00:00	MSFT	Stock	31.102	31.26	31.1	31.24	3866204.0
2007-01-16 12:30:00	MSFT	Stock	31.24	31.29	31.08	31.1	3195665.0
2007-01-16 13:00:00	MSFT	Stock	31.1	31.22	31.1	31.15	1845427.0
2007-01-16 13:30:00	MSFT	Stock	31.15	31.19	31.1	31.16	2596991.0
2007-01-16 14:00:00	MSFT	Stock	31.16	31.19	31.1	31.12	3907153.0
2007-01-16 14:30:00	MSFT	Stock	31.12	31.24	31.1	31.14	3320956.0
2007-01-16 15:00:00	MSFT	Stock	31.15	31.19	31.08	31.13	3031675.0

> showing 50 of 53,615 rows — these rows as CSV

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