PREVIEW / stock_1hour / 2006-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-14.parquet
  size:    605 KB
  rows:    28,473
  symbols: 2,195

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-14 06:00:00	AAPL	Stock	2.3107	2.3107	2.3107	2.3107	30800.0
2006-02-14 07:00:00	AAPL	Stock	2.3107	2.3232	2.3107	2.3179	193200.0
2006-02-14 08:00:00	AAPL	Stock	2.3207	2.3493	2.3179	2.3411	5927124.0
2006-02-14 09:00:00	AAPL	Stock	2.3411	2.3807	2.3214	2.3793	177183860.0
2006-02-14 10:00:00	AAPL	Stock	2.3793	2.3889	2.3596	2.3789	196244356.0
2006-02-14 11:00:00	AAPL	Stock	2.3789	2.3857	2.3639	2.3782	121118676.0
2006-02-14 12:00:00	AAPL	Stock	2.3782	2.4007	2.3718	2.3903	133526736.0
2006-02-14 13:00:00	AAPL	Stock	2.3907	2.3982	2.3821	2.395	103163116.0
2006-02-14 14:00:00	AAPL	Stock	2.395	2.4321	2.3946	2.4296	196417564.0
2006-02-14 15:00:00	AAPL	Stock	2.4296	2.4321	2.4054	2.4161	189331492.0
2006-02-14 16:00:00	AAPL	Stock	2.4157	2.4193	2.4111	2.4143	3178028.0
2006-02-14 17:00:00	AAPL	Stock	2.4146	2.4163	2.4107	2.4143	531272.0
2006-02-14 18:00:00	AAPL	Stock	2.4157	2.4161	2.4125	2.4146	175028.0
2006-02-14 08:00:00	MSFT	Stock	26.48	26.48	26.43	26.44	17925.0
2006-02-14 09:00:00	MSFT	Stock	26.44	26.49	26.39	26.472	7054582.0
2006-02-14 10:00:00	MSFT	Stock	26.472	26.5	26.35	26.4	6984498.0
2006-02-14 11:00:00	MSFT	Stock	26.4	26.5	26.38	26.45	8359336.0
2006-02-14 12:00:00	MSFT	Stock	26.45	26.49	26.43	26.48	6043905.0
2006-02-14 13:00:00	MSFT	Stock	26.48	26.5	26.44	26.46	3426282.0
2006-02-14 14:00:00	MSFT	Stock	26.46	26.662	26.46	26.63	11672761.0
2006-02-14 15:00:00	MSFT	Stock	26.639	26.68	26.46	26.65	11773771.0
2006-02-14 16:00:00	MSFT	Stock	26.65	26.71	26.531	26.69	279484.0
2006-02-14 17:00:00	MSFT	Stock	26.66	26.7	26.649	26.69	9454.0
2006-02-14 18:00:00	MSFT	Stock	26.7	26.7	26.69	26.69	1100.0
2006-02-14 08:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	120000.0
2006-02-14 09:00:00	NVDA	Stock	0.368	0.3687	0.3629	0.3666	36633480.0
2006-02-14 10:00:00	NVDA	Stock	0.3668	0.3691	0.3642	0.3681	68999400.0
2006-02-14 11:00:00	NVDA	Stock	0.368	0.3687	0.3633	0.3637	48246600.0
2006-02-14 12:00:00	NVDA	Stock	0.3636	0.3646	0.3633	0.3637	26290680.0
2006-02-14 13:00:00	NVDA	Stock	0.3637	0.3658	0.3635	0.365	31087080.0
2006-02-14 14:00:00	NVDA	Stock	0.3652	0.3677	0.3645	0.3664	50335080.0
2006-02-14 15:00:00	NVDA	Stock	0.3665	0.3678	0.3651	0.3677	52763040.0
2006-02-14 16:00:00	NVDA	Stock	0.3677	0.3677	0.3675	0.3677	456000.0
2006-02-14 17:00:00	NVDA	Stock	0.3675	0.3677	0.3675	0.3677	154080.0
2006-02-14 08:00:00	AMZN	Stock	1.9	1.9	1.9	1.9	4000.0
2006-02-14 09:00:00	AMZN	Stock	1.893	1.9035	1.869	1.895	11524220.0
2006-02-14 10:00:00	AMZN	Stock	1.8955	1.8995	1.875	1.8845	12130500.0
2006-02-14 11:00:00	AMZN	Stock	1.8845	1.905	1.881	1.9025	11295360.0
2006-02-14 12:00:00	AMZN	Stock	1.9035	1.9075	1.894	1.8985	7583280.0
2006-02-14 13:00:00	AMZN	Stock	1.8988	1.908	1.898	1.905	8212820.0
2006-02-14 14:00:00	AMZN	Stock	1.9055	1.9245	1.9045	1.911	13648240.0
2006-02-14 15:00:00	AMZN	Stock	1.9105	1.919	1.9005	1.9125	22511840.0
2006-02-14 16:00:00	AMZN	Stock	1.9125	1.9135	1.91	1.9125	360320.0
2006-02-14 17:00:00	AMZN	Stock	1.915	1.9235	1.9124	1.9124	41000.0
2006-02-14 09:00:00	CL	Stock	27.08	27.175	27.0	27.08	280600.0
2006-02-14 10:00:00	CL	Stock	27.09	27.2	27.07	27.125	320000.0
2006-02-14 11:00:00	CL	Stock	27.125	27.225	27.105	27.22	406600.0
2006-02-14 12:00:00	CL	Stock	27.215	27.22	27.1	27.115	246000.0
2006-02-14 13:00:00	CL	Stock	27.115	27.19	27.11	27.115	248400.0
2006-02-14 14:00:00	CL	Stock	27.115	27.215	27.105	27.2	332800.0

> showing 50 of 28,473 rows — these rows as CSV

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