PREVIEW / stock_1hour / 2006-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-20.parquet
  size:    649 KB
  rows:    30,782
  symbols: 2,446

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-11-20 04:00:00	AAPL	Stock	3.0575	3.0575	3.0575	3.0575	14000.0
2006-11-20 07:00:00	AAPL	Stock	3.0454	3.0529	3.0404	3.0529	49476.0
2006-11-20 08:00:00	AAPL	Stock	3.0525	3.0657	3.0525	3.0636	534296.0
2006-11-20 09:00:00	AAPL	Stock	3.0607	3.0664	3.0429	3.0529	65688784.0
2006-11-20 10:00:00	AAPL	Stock	3.0529	3.1071	3.0464	3.0914	105050148.0
2006-11-20 11:00:00	AAPL	Stock	3.0911	3.0996	3.0789	3.0996	70917476.0
2006-11-20 12:00:00	AAPL	Stock	3.0996	3.1071	3.0914	3.0975	67191740.0
2006-11-20 13:00:00	AAPL	Stock	3.0975	3.1025	3.0911	3.0961	52950884.0
2006-11-20 14:00:00	AAPL	Stock	3.0964	3.105	3.0714	3.086	94698268.0
2006-11-20 15:00:00	AAPL	Stock	3.0861	3.0918	3.0761	3.09	100746184.0
2006-11-20 16:00:00	AAPL	Stock	3.0889	3.0936	3.0821	3.0893	3500224.0
2006-11-20 17:00:00	AAPL	Stock	3.0911	3.0921	3.0871	3.0875	3312008.0
2006-11-20 18:00:00	AAPL	Stock	3.0911	3.0911	3.0911	3.0911	16548.0
2006-11-20 19:00:00	AAPL	Stock	3.0907	3.0925	3.0893	3.0896	229460.0
2006-11-20 04:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	1000.0
2006-11-20 06:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	2000.0
2006-11-20 07:00:00	MSFT	Stock	29.6	29.6	29.5	29.5	26550.0
2006-11-20 08:00:00	MSFT	Stock	29.58	29.6	29.4	29.59	547621.0
2006-11-20 09:00:00	MSFT	Stock	29.59	29.72	29.4	29.67	11579103.0
2006-11-20 10:00:00	MSFT	Stock	29.66	29.83	29.65	29.818	12915684.0
2006-11-20 11:00:00	MSFT	Stock	29.82	29.91	29.79	29.9	9008258.0
2006-11-20 12:00:00	MSFT	Stock	29.9	29.97	29.85	29.96	11119606.0
2006-11-20 13:00:00	MSFT	Stock	29.96	30.0	29.86	29.98	11551245.0
2006-11-20 14:00:00	MSFT	Stock	29.98	30.0	29.798	29.92	10943157.0
2006-11-20 15:00:00	MSFT	Stock	29.92	29.96	29.83	29.9	13784586.0
2006-11-20 16:00:00	MSFT	Stock	29.91	29.97	29.83	29.97	1780086.0
2006-11-20 17:00:00	MSFT	Stock	29.89	29.97	29.89	29.92	722890.0
2006-11-20 18:00:00	MSFT	Stock	29.92	29.98	29.92	29.97	9490.0
2006-11-20 19:00:00	MSFT	Stock	29.97	29.98	29.96	29.97	20880.0
2006-11-20 07:00:00	NVDA	Stock	0.6037	0.6037	0.6037	0.6037	6000.0
2006-11-20 08:00:00	NVDA	Stock	0.6017	0.6017	0.5992	0.5992	131160.0
2006-11-20 09:00:00	NVDA	Stock	0.5992	0.6013	0.5933	0.5992	59237280.0
2006-11-20 10:00:00	NVDA	Stock	0.5992	0.6097	0.5973	0.6083	84070080.0
2006-11-20 11:00:00	NVDA	Stock	0.6083	0.6143	0.608	0.6137	62383020.0
2006-11-20 12:00:00	NVDA	Stock	0.6137	0.6137	0.606	0.6088	42355740.0
2006-11-20 13:00:00	NVDA	Stock	0.6087	0.6108	0.6042	0.606	108249300.0
2006-11-20 14:00:00	NVDA	Stock	0.6058	0.6083	0.6002	0.6053	76823520.0
2006-11-20 15:00:00	NVDA	Stock	0.6053	0.612	0.6037	0.612	155592480.0
2006-11-20 16:00:00	NVDA	Stock	0.6112	0.6125	0.6085	0.6107	2850300.0
2006-11-20 17:00:00	NVDA	Stock	0.6115	0.6122	0.611	0.611	2712000.0
2006-11-20 18:00:00	NVDA	Stock	0.6107	0.6107	0.61	0.61	54000.0
2006-11-20 19:00:00	NVDA	Stock	0.61	0.61	0.61	0.61	66000.0
2006-11-20 08:00:00	AMZN	Stock	2.125	2.125	2.121	2.121	77700.0
2006-11-20 09:00:00	AMZN	Stock	2.1225	2.124	2.109	2.123	16730900.0
2006-11-20 10:00:00	AMZN	Stock	2.1225	2.1245	2.1055	2.1075	18792900.0
2006-11-20 11:00:00	AMZN	Stock	2.108	2.1175	2.097	2.116	17187660.0
2006-11-20 12:00:00	AMZN	Stock	2.116	2.127	2.114	2.1225	13654960.0
2006-11-20 13:00:00	AMZN	Stock	2.123	2.1275	2.1165	2.121	8463140.0
2006-11-20 14:00:00	AMZN	Stock	2.1205	2.127	2.1085	2.1155	19033040.0
2006-11-20 15:00:00	AMZN	Stock	2.1155	2.123	2.109	2.123	17095020.0

> showing 50 of 30,782 rows — these rows as CSV

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