PREVIEW / stock_1hour / 2006-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-06.parquet
  size:    600 KB
  rows:    28,425
  symbols: 2,184

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
2006-02-06 08:00:00	AAPL	Stock	2.5764	2.5768	2.5661	2.5736	1436400.0
2006-02-06 09:00:00	AAPL	Stock	2.5739	2.5896	2.5379	2.5471	113712452.0
2006-02-06 10:00:00	AAPL	Stock	2.5479	2.5511	2.4571	2.4679	391596324.0
2006-02-06 11:00:00	AAPL	Stock	2.4671	2.4854	2.4511	2.4707	187559708.0
2006-02-06 12:00:00	AAPL	Stock	2.4707	2.4714	2.42	2.4307	183395660.0
2006-02-06 13:00:00	AAPL	Stock	2.4304	2.4429	2.3861	2.4039	205704716.0
2006-02-06 14:00:00	AAPL	Stock	2.4039	2.4264	2.3836	2.4	253375276.0
2006-02-06 15:00:00	AAPL	Stock	2.3996	2.4775	2.3911	2.4036	286016556.0
2006-02-06 16:00:00	AAPL	Stock	2.4018	2.4501	2.3929	2.4218	13211100.0
2006-02-06 17:00:00	AAPL	Stock	2.4225	2.4257	2.4107	2.4111	1192380.0
2006-02-06 18:00:00	AAPL	Stock	2.4125	2.4196	2.4096	2.4107	457744.0
2006-02-06 08:00:00	MSFT	Stock	27.57	27.57	27.5	27.54	1545118.0
2006-02-06 09:00:00	MSFT	Stock	27.52	27.59	27.28	27.29	6169240.0
2006-02-06 10:00:00	MSFT	Stock	27.28	27.36	27.28	27.33	6584330.0
2006-02-06 11:00:00	MSFT	Stock	27.33	27.38	27.26	27.26	4714536.0
2006-02-06 12:00:00	MSFT	Stock	27.26	27.32	27.18	27.22	7240965.0
2006-02-06 13:00:00	MSFT	Stock	27.22	27.3	27.18	27.25	6113733.0
2006-02-06 14:00:00	MSFT	Stock	27.24	27.25	27.09	27.17	10163510.0
2006-02-06 15:00:00	MSFT	Stock	27.16	27.23	27.14	27.19	15830768.0
2006-02-06 16:00:00	MSFT	Stock	27.19	27.23	27.1	27.17	324773.0
2006-02-06 17:00:00	MSFT	Stock	27.17	27.19	27.16	27.19	10090.0
2006-02-06 18:00:00	MSFT	Stock	27.19	27.19	27.17	27.18	5070.0
2006-02-06 09:00:00	NVDA	Stock	0.365	0.3707	0.3642	0.3689	27603720.0
2006-02-06 10:00:00	NVDA	Stock	0.369	0.3727	0.3679	0.3727	58462800.0
2006-02-06 11:00:00	NVDA	Stock	0.3727	0.3748	0.3713	0.3747	42079080.0
2006-02-06 12:00:00	NVDA	Stock	0.3748	0.3767	0.3746	0.3759	44423760.0
2006-02-06 13:00:00	NVDA	Stock	0.3758	0.3776	0.3742	0.3752	31614720.0
2006-02-06 14:00:00	NVDA	Stock	0.375	0.3754	0.3722	0.3739	49291440.0
2006-02-06 15:00:00	NVDA	Stock	0.3739	0.3772	0.3733	0.3772	86128320.0
2006-02-06 16:00:00	NVDA	Stock	0.3773	0.379	0.3736	0.3775	5824920.0
2006-02-06 17:00:00	NVDA	Stock	0.3777	0.3777	0.3777	0.3777	12000.0
2006-02-06 08:00:00	AMZN	Stock	1.925	1.925	1.91	1.9125	64000.0
2006-02-06 09:00:00	AMZN	Stock	1.9135	1.9175	1.8885	1.89	27141380.0
2006-02-06 10:00:00	AMZN	Stock	1.8895	1.905	1.8885	1.901	29668040.0
2006-02-06 11:00:00	AMZN	Stock	1.901	1.9025	1.895	1.897	21271440.0
2006-02-06 12:00:00	AMZN	Stock	1.897	1.8995	1.8915	1.8975	17302480.0
2006-02-06 13:00:00	AMZN	Stock	1.8975	1.9	1.893	1.8955	15005740.0
2006-02-06 14:00:00	AMZN	Stock	1.8955	1.8975	1.8885	1.892	17969860.0
2006-02-06 15:00:00	AMZN	Stock	1.892	1.9035	1.8915	1.895	29453840.0
2006-02-06 16:00:00	AMZN	Stock	1.8975	1.898	1.89	1.895	606420.0
2006-02-06 17:00:00	AMZN	Stock	1.8965	1.8965	1.896	1.896	27000.0
2006-02-06 09:00:00	CL	Stock	27.1	27.195	27.1	27.15	363600.0
2006-02-06 10:00:00	CL	Stock	27.15	27.155	26.995	27.03	550200.0
2006-02-06 11:00:00	CL	Stock	27.04	27.09	27.035	27.075	219000.0
2006-02-06 12:00:00	CL	Stock	27.075	27.08	27.01	27.04	254000.0
2006-02-06 13:00:00	CL	Stock	27.04	27.095	27.02	27.075	224400.0
2006-02-06 14:00:00	CL	Stock	27.075	27.075	27.01	27.045	314200.0
2006-02-06 15:00:00	CL	Stock	27.05	27.075	27.03	27.055	546000.0
2006-02-06 16:00:00	CL	Stock	27.075	27.075	27.05	27.05	1000.0

> showing 49 of 28,425 rows — these rows as CSV

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