PREVIEW / stock_1hour / 2006-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-14.parquet
  size:    622 KB
  rows:    29,977
  symbols: 2,304

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-07-14 07:00:00	AAPL	Stock	1.8643	1.8643	1.8643	1.8643	2800.0
2006-07-14 08:00:00	AAPL	Stock	1.8668	1.8796	1.8654	1.8796	929712.0
2006-07-14 09:00:00	AAPL	Stock	1.8786	1.8889	1.8221	1.8364	156101064.0
2006-07-14 10:00:00	AAPL	Stock	1.8368	1.8446	1.825	1.8296	192169908.0
2006-07-14 11:00:00	AAPL	Stock	1.8296	1.8339	1.8057	1.8175	138503260.0
2006-07-14 12:00:00	AAPL	Stock	1.8175	1.835	1.8111	1.825	104360060.0
2006-07-14 13:00:00	AAPL	Stock	1.825	1.8257	1.8089	1.8096	86027424.0
2006-07-14 14:00:00	AAPL	Stock	1.8089	1.8132	1.7982	1.8043	111760012.0
2006-07-14 15:00:00	AAPL	Stock	1.8043	1.8171	1.7914	1.805	191633428.0
2006-07-14 16:00:00	AAPL	Stock	1.8054	1.8241	1.7982	1.7982	3227924.0
2006-07-14 17:00:00	AAPL	Stock	1.7982	1.8021	1.7979	1.8007	510860.0
2006-07-14 18:00:00	AAPL	Stock	1.8007	1.8053	1.8	1.8	211344.0
2006-07-14 07:00:00	MSFT	Stock	22.28	22.28	22.26	22.26	1800.0
2006-07-14 08:00:00	MSFT	Stock	22.27	22.33	22.25	22.3	62704.0
2006-07-14 09:00:00	MSFT	Stock	22.32	22.37	22.23	22.31	6525137.0
2006-07-14 10:00:00	MSFT	Stock	22.32	22.44	22.27	22.31	8891306.0
2006-07-14 11:00:00	MSFT	Stock	22.31	22.48	22.26	22.462	10916865.0
2006-07-14 12:00:00	MSFT	Stock	22.47	22.55	22.4	22.47	7303493.0
2006-07-14 13:00:00	MSFT	Stock	22.47	22.5	22.31	22.35	11618766.0
2006-07-14 14:00:00	MSFT	Stock	22.35	22.38	22.27	22.34	7790695.0
2006-07-14 15:00:00	MSFT	Stock	22.33	22.41	22.29	22.3	12158911.0
2006-07-14 16:00:00	MSFT	Stock	22.28	22.32	22.25	22.31	483762.0
2006-07-14 17:00:00	MSFT	Stock	22.31	22.31	22.31	22.31	1900.0
2006-07-14 18:00:00	MSFT	Stock	22.29	22.3	22.29	22.3	6011.0
2006-07-14 08:00:00	NVDA	Stock	0.298	0.3	0.2977	0.3	247260.0
2006-07-14 09:00:00	NVDA	Stock	0.3	0.3032	0.2958	0.2977	72231540.0
2006-07-14 10:00:00	NVDA	Stock	0.2978	0.3007	0.295	0.2952	80016960.0
2006-07-14 11:00:00	NVDA	Stock	0.295	0.2952	0.2877	0.2902	94325760.0
2006-07-14 12:00:00	NVDA	Stock	0.29	0.2903	0.2862	0.2878	108054420.0
2006-07-14 13:00:00	NVDA	Stock	0.2878	0.2938	0.2868	0.2913	58627320.0
2006-07-14 14:00:00	NVDA	Stock	0.2912	0.293	0.2905	0.2927	55005360.0
2006-07-14 15:00:00	NVDA	Stock	0.2927	0.2948	0.2923	0.294	85303020.0
2006-07-14 16:00:00	NVDA	Stock	0.2942	0.2945	0.2927	0.2927	1151880.0
2006-07-14 17:00:00	NVDA	Stock	0.2913	0.2943	0.2913	0.2943	138000.0
2006-07-14 18:00:00	NVDA	Stock	0.2945	0.2945	0.2945	0.2945	34920.0
2006-07-14 07:00:00	AMZN	Stock	1.675	1.675	1.675	1.675	6000.0
2006-07-14 08:00:00	AMZN	Stock	1.675	1.6775	1.67	1.67	50980.0
2006-07-14 09:00:00	AMZN	Stock	1.671	1.6865	1.6495	1.652	13541000.0
2006-07-14 10:00:00	AMZN	Stock	1.652	1.6735	1.646	1.6641	29346720.0
2006-07-14 11:00:00	AMZN	Stock	1.6645	1.665	1.641	1.6635	19645320.0
2006-07-14 12:00:00	AMZN	Stock	1.663	1.67	1.6525	1.653	13621640.0
2006-07-14 13:00:00	AMZN	Stock	1.6525	1.6555	1.647	1.65	15050100.0
2006-07-14 14:00:00	AMZN	Stock	1.65	1.6505	1.64	1.6445	24891580.0
2006-07-14 15:00:00	AMZN	Stock	1.644	1.65	1.64	1.648	40823220.0
2006-07-14 16:00:00	AMZN	Stock	1.6465	1.65	1.635	1.638	1604460.0
2006-07-14 17:00:00	AMZN	Stock	1.639	1.639	1.639	1.639	8000.0
2006-07-14 18:00:00	AMZN	Stock	1.646	1.646	1.64	1.64	11340.0
2006-07-14 09:00:00	CL	Stock	30.66	30.66	30.525	30.575	245000.0
2006-07-14 10:00:00	CL	Stock	30.565	30.635	30.53	30.56	472800.0
2006-07-14 11:00:00	CL	Stock	30.56	30.56	30.355	30.485	468400.0

> showing 50 of 29,977 rows — these rows as CSV

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