PREVIEW / stock_1hour / 2007-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-11.parquet
  size:    750 KB
  rows:    36,917
  symbols: 3,019

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-06-11 09:00:00	AAPL	Stock	4.5	4.5054	4.4554	4.4661	170730756.0
2007-06-11 10:00:00	AAPL	Stock	4.4668	4.4668	4.4196	4.4382	215675012.0
2007-06-11 11:00:00	AAPL	Stock	4.4386	4.4525	4.4361	4.4411	110852504.0
2007-06-11 12:00:00	AAPL	Stock	4.4404	4.4618	4.4286	4.4575	99380708.0
2007-06-11 13:00:00	AAPL	Stock	4.4571	4.4939	4.4389	4.445	208671064.0
2007-06-11 14:00:00	AAPL	Stock	4.4446	4.4629	4.2929	4.3436	527037364.0
2007-06-11 15:00:00	AAPL	Stock	4.3429	4.3493	4.2693	4.2921	498864016.0
2007-06-11 16:00:00	AAPL	Stock	4.2918	4.2932	4.2918	4.2925	5158832.0
2007-06-11 09:00:00	MSFT	Stock	29.94	30.24	29.93	30.22	3278883.0
2007-06-11 10:00:00	MSFT	Stock	30.222	30.25	29.97	30.0	6820454.0
2007-06-11 11:00:00	MSFT	Stock	30.0	30.18	29.98	30.17	3894194.0
2007-06-11 12:00:00	MSFT	Stock	30.17	30.19	30.02	30.15	2849660.0
2007-06-11 13:00:00	MSFT	Stock	30.15	30.18	30.082	30.1	3542685.0
2007-06-11 14:00:00	MSFT	Stock	30.1	30.23	30.09	30.16	7717146.0
2007-06-11 15:00:00	MSFT	Stock	30.16	30.18	30.0	30.02	13118045.0
2007-06-11 16:00:00	MSFT	Stock	30.02	30.02	30.02	30.02	709969.0
2007-06-11 17:00:00	MSFT	Stock	30.13	30.19	30.02	30.03	17500.0
2007-06-11 08:00:00	NVDA	Stock	0.6092	0.6095	0.6092	0.6095	18000.0
2007-06-11 09:00:00	NVDA	Stock	0.6092	0.615	0.6058	0.6133	60143340.0
2007-06-11 10:00:00	NVDA	Stock	0.6136	0.6147	0.6077	0.6107	71798280.0
2007-06-11 11:00:00	NVDA	Stock	0.6107	0.6123	0.6093	0.6123	43166040.0
2007-06-11 12:00:00	NVDA	Stock	0.6123	0.6137	0.6103	0.6127	41406060.0
2007-06-11 13:00:00	NVDA	Stock	0.6127	0.6133	0.611	0.6112	40754400.0
2007-06-11 14:00:00	NVDA	Stock	0.6112	0.6142	0.6103	0.6112	57506640.0
2007-06-11 15:00:00	NVDA	Stock	0.6112	0.6133	0.6108	0.6113	106026600.0
2007-06-11 16:00:00	NVDA	Stock	0.6113	0.6121	0.6113	0.6113	5021880.0
2007-06-11 17:00:00	NVDA	Stock	0.6107	0.6133	0.607	0.6125	1014000.0
2007-06-11 18:00:00	NVDA	Stock	0.6125	0.6125	0.6125	0.6125	12000.0
2007-06-11 19:00:00	NVDA	Stock	0.6083	0.6083	0.6083	0.6083	6000.0
2007-06-11 07:00:00	AMZN	Stock	3.644	3.6445	3.6375	3.64	22000.0
2007-06-11 08:00:00	AMZN	Stock	3.6315	3.65	3.628	3.6405	341100.0
2007-06-11 09:00:00	AMZN	Stock	3.639	3.653	3.6225	3.626	27807460.0
2007-06-11 10:00:00	AMZN	Stock	3.626	3.6265	3.575	3.591	50334180.0
2007-06-11 11:00:00	AMZN	Stock	3.591	3.602	3.577	3.5885	30442220.0
2007-06-11 12:00:00	AMZN	Stock	3.5885	3.6102	3.5825	3.601	18092940.0
2007-06-11 13:00:00	AMZN	Stock	3.601	3.6115	3.597	3.5986	20226120.0
2007-06-11 14:00:00	AMZN	Stock	3.5985	3.6069	3.581	3.5815	21560860.0
2007-06-11 15:00:00	AMZN	Stock	3.581	3.5825	3.55	3.559	48010300.0
2007-06-11 16:00:00	AMZN	Stock	3.559	3.5685	3.556	3.562	977340.0
2007-06-11 17:00:00	AMZN	Stock	3.5635	3.6	3.554	3.5575	280300.0
2007-06-11 18:00:00	AMZN	Stock	3.56	3.562	3.5585	3.5585	26000.0
2007-06-11 19:00:00	AMZN	Stock	3.5625	3.566	3.5625	3.563	14000.0
2007-06-11 09:00:00	TLT	Stock	83.49	83.59	83.26	83.58	362600.0
2007-06-11 10:00:00	TLT	Stock	83.58	83.71	83.49	83.69	473700.0
2007-06-11 11:00:00	TLT	Stock	83.68	83.73	83.62	83.72	117900.0
2007-06-11 12:00:00	TLT	Stock	83.71	83.85	83.66	83.79	206700.0
2007-06-11 13:00:00	TLT	Stock	83.8	83.89	83.75	83.86	212500.0
2007-06-11 14:00:00	TLT	Stock	83.86	83.87	83.69	83.72	217125.0
2007-06-11 15:00:00	TLT	Stock	83.71	83.72	83.5	83.57	383800.0
2007-06-11 16:00:00	TLT	Stock	83.58	83.6	83.56	83.56	13700.0

> showing 50 of 36,917 rows — these rows as CSV

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