PREVIEW / stock_1hour / 2007-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-16.parquet
  size:    658 KB
  rows:    31,248
  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:00: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.4107	3.4107	25200.0
2007-01-16 07:00:00	AAPL	Stock	3.4179	3.4232	3.4071	3.4071	1519252.0
2007-01-16 08:00:00	AAPL	Stock	3.4157	3.4236	3.4075	3.4125	8829604.0
2007-01-16 09:00:00	AAPL	Stock	3.4114	3.4482	3.4046	3.4389	237767432.0
2007-01-16 10:00:00	AAPL	Stock	3.4382	3.4425	3.4171	3.4239	252883736.0
2007-01-16 11:00:00	AAPL	Stock	3.4239	3.4521	3.4236	3.4468	174412056.0
2007-01-16 12:00:00	AAPL	Stock	3.4468	3.4625	3.4429	3.45	127748236.0
2007-01-16 13:00:00	AAPL	Stock	3.4493	3.4571	3.445	3.45	72794372.0
2007-01-16 14:00:00	AAPL	Stock	3.45	3.4732	3.4457	3.4618	147794472.0
2007-01-16 15:00:00	AAPL	Stock	3.4614	3.4696	3.4529	3.4682	181982976.0
2007-01-16 16:00:00	AAPL	Stock	3.4661	3.4696	3.3589	3.4571	15943536.0
2007-01-16 17:00:00	AAPL	Stock	3.4557	3.4607	3.4546	3.4586	1004556.0
2007-01-16 18:00:00	AAPL	Stock	3.4589	3.4618	3.4571	3.4571	687456.0
2007-01-16 19:00:00	AAPL	Stock	3.4575	3.4675	3.4571	3.4675	699160.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.34	31.32	31.34	1500.0
2007-01-16 07:00:00	MSFT	Stock	31.25	31.32	31.23	31.25	9722.0
2007-01-16 08:00:00	MSFT	Stock	31.25	31.28	31.16	31.17	88192.0
2007-01-16 09:00:00	MSFT	Stock	31.18	31.45	31.16	31.35	11905177.0
2007-01-16 10:00:00	MSFT	Stock	31.35	31.35	31.12	31.17	10857788.0
2007-01-16 11:00:00	MSFT	Stock	31.18	31.27	31.03	31.08	9715677.0
2007-01-16 12:00:00	MSFT	Stock	31.102	31.29	31.08	31.1	7061869.0
2007-01-16 13:00:00	MSFT	Stock	31.1	31.22	31.1	31.16	4442418.0
2007-01-16 14:00:00	MSFT	Stock	31.16	31.24	31.1	31.14	7228109.0
2007-01-16 15:00:00	MSFT	Stock	31.15	31.19	31.08	31.15	7594420.0
2007-01-16 16:00:00	MSFT	Stock	31.15	31.212	31.06	31.06	159962.0
2007-01-16 17:00:00	MSFT	Stock	31.09	31.09	31.07	31.08	2700.0
2007-01-16 18:00:00	MSFT	Stock	31.09	31.09	30.7	30.7	60600.0
2007-01-16 19:00:00	MSFT	Stock	31.06	31.07	31.06	31.06	1795.0
2007-01-16 08:00:00	NVDA	Stock	0.5917	0.6	0.59	0.5975	618060.0
2007-01-16 09:00:00	NVDA	Stock	0.5955	0.5955	0.5845	0.5873	118815780.0
2007-01-16 10:00:00	NVDA	Stock	0.5873	0.5883	0.5827	0.5837	133036020.0
2007-01-16 11:00:00	NVDA	Stock	0.5835	0.5863	0.5815	0.5832	70453860.0
2007-01-16 12:00:00	NVDA	Stock	0.5832	0.5865	0.5828	0.5828	81682020.0
2007-01-16 13:00:00	NVDA	Stock	0.5828	0.5853	0.5817	0.5833	54151380.0
2007-01-16 14:00:00	NVDA	Stock	0.5835	0.5883	0.5828	0.5862	80974200.0
2007-01-16 15:00:00	NVDA	Stock	0.5862	0.5898	0.5852	0.5882	96696600.0
2007-01-16 16:00:00	NVDA	Stock	0.588	0.5918	0.5805	0.5805	4844520.0
2007-01-16 17:00:00	NVDA	Stock	0.5815	0.5827	0.5808	0.5827	208380.0
2007-01-16 18:00:00	NVDA	Stock	0.5827	0.5828	0.5827	0.5828	27420.0
2007-01-16 19:00:00	NVDA	Stock	0.5813	0.5813	0.581	0.581	346800.0
2007-01-16 08:00:00	AMZN	Stock	1.9055	1.9055	1.9005	1.9005	18200.0
2007-01-16 09:00:00	AMZN	Stock	1.8975	1.925	1.8965	1.9225	12109100.0
2007-01-16 10:00:00	AMZN	Stock	1.923	1.929	1.9145	1.9215	17602160.0
2007-01-16 11:00:00	AMZN	Stock	1.9215	1.935	1.913	1.9325	13857900.0
2007-01-16 12:00:00	AMZN	Stock	1.933	1.936	1.9285	1.9295	13595940.0
2007-01-16 13:00:00	AMZN	Stock	1.9295	1.9325	1.9215	1.93	9378160.0
2007-01-16 14:00:00	AMZN	Stock	1.9305	1.9445	1.9275	1.944	12470780.0

> showing 50 of 31,248 rows — these rows as CSV

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