PREVIEW / stock_1hour / 2006-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-30.parquet
  size:    643 KB
  rows:    30,624
  symbols: 2,457

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-30 06:00:00	AAPL	Stock	3.2914	3.2914	3.2914	3.2914	2800.0
2006-11-30 07:00:00	AAPL	Stock	3.3014	3.3271	3.29	3.3161	1347080.0
2006-11-30 08:00:00	AAPL	Stock	3.3168	3.3214	3.2871	3.2946	7397376.0
2006-11-30 09:00:00	AAPL	Stock	3.2946	3.31	3.275	3.2939	169838760.0
2006-11-30 10:00:00	AAPL	Stock	3.2939	3.2982	3.2521	3.2825	197298836.0
2006-11-30 11:00:00	AAPL	Stock	3.2821	3.2907	3.2682	3.2793	91170912.0
2006-11-30 12:00:00	AAPL	Stock	3.2795	3.3086	3.275	3.2964	122068940.0
2006-11-30 13:00:00	AAPL	Stock	3.2964	3.3071	3.2857	3.2875	93445072.0
2006-11-30 14:00:00	AAPL	Stock	3.2868	3.3007	3.2846	3.2975	66332532.0
2006-11-30 15:00:00	AAPL	Stock	3.2975	3.2989	3.2671	3.2739	103050164.0
2006-11-30 16:00:00	AAPL	Stock	3.2743	3.2761	3.2704	3.2743	3380328.0
2006-11-30 17:00:00	AAPL	Stock	3.2729	3.2757	3.2729	3.2757	252700.0
2006-11-30 18:00:00	AAPL	Stock	3.2775	3.2786	3.275	3.2786	195720.0
2006-11-30 19:00:00	AAPL	Stock	3.2775	3.2782	3.2732	3.2779	381192.0
2006-11-30 07:00:00	MSFT	Stock	29.61	29.61	29.61	29.61	100.0
2006-11-30 08:00:00	MSFT	Stock	29.61	29.67	29.52	29.53	56307.0
2006-11-30 09:00:00	MSFT	Stock	29.53	29.57	29.41	29.53	7054902.0
2006-11-30 10:00:00	MSFT	Stock	29.52	29.57	29.43	29.5	8045329.0
2006-11-30 11:00:00	MSFT	Stock	29.51	29.53	29.38	29.43	5574313.0
2006-11-30 12:00:00	MSFT	Stock	29.43	29.46	29.38	29.4	4088854.0
2006-11-30 13:00:00	MSFT	Stock	29.4	29.51	29.37	29.4	5036887.0
2006-11-30 14:00:00	MSFT	Stock	29.39	29.5	29.39	29.47	4287427.0
2006-11-30 15:00:00	MSFT	Stock	29.46	29.51	29.34	29.35	10187849.0
2006-11-30 16:00:00	MSFT	Stock	29.36	29.38	29.32	29.33	631754.0
2006-11-30 17:00:00	MSFT	Stock	29.33	29.35	29.33	29.33	4050.0
2006-11-30 18:00:00	MSFT	Stock	29.34	29.35	29.33	29.35	3565.0
2006-11-30 19:00:00	MSFT	Stock	29.35	29.35	29.32	29.35	6496.0
2006-11-30 08:00:00	NVDA	Stock	0.6083	0.6083	0.6067	0.6068	210000.0
2006-11-30 09:00:00	NVDA	Stock	0.6067	0.6117	0.6035	0.6067	47901540.0
2006-11-30 10:00:00	NVDA	Stock	0.6065	0.6088	0.601	0.605	77155440.0
2006-11-30 11:00:00	NVDA	Stock	0.6047	0.6087	0.603	0.6075	49907160.0
2006-11-30 12:00:00	NVDA	Stock	0.6075	0.6185	0.6075	0.613	68896200.0
2006-11-30 13:00:00	NVDA	Stock	0.613	0.6208	0.6128	0.615	60794820.0
2006-11-30 14:00:00	NVDA	Stock	0.615	0.6215	0.6135	0.6195	90936540.0
2006-11-30 15:00:00	NVDA	Stock	0.6195	0.6198	0.616	0.6167	110678760.0
2006-11-30 16:00:00	NVDA	Stock	0.6165	0.6188	0.616	0.6175	6255000.0
2006-11-30 18:00:00	NVDA	Stock	0.6153	0.6153	0.6153	0.6153	7500.0
2006-11-30 08:00:00	AMZN	Stock	2.0325	2.0325	2.0325	2.0325	9620.0
2006-11-30 09:00:00	AMZN	Stock	2.018	2.032	2.0115	2.0285	12690340.0
2006-11-30 10:00:00	AMZN	Stock	2.028	2.031	1.9925	2.004	25427280.0
2006-11-30 11:00:00	AMZN	Stock	2.004	2.014	1.9965	2.001	19815040.0
2006-11-30 12:00:00	AMZN	Stock	2.001	2.01	1.999	2.0035	11488860.0
2006-11-30 13:00:00	AMZN	Stock	2.0035	2.0225	2.0	2.013	14199580.0
2006-11-30 14:00:00	AMZN	Stock	2.0125	2.0235	2.012	2.0225	10996720.0
2006-11-30 15:00:00	AMZN	Stock	2.023	2.0265	2.0135	2.0175	25472980.0
2006-11-30 16:00:00	AMZN	Stock	2.017	2.0185	2.0105	2.0185	268460.0
2006-11-30 09:00:00	CL	Stock	32.675	32.735	32.55	32.655	206200.0
2006-11-30 10:00:00	CL	Stock	32.645	32.67	32.5	32.5	377000.0
2006-11-30 11:00:00	CL	Stock	32.51	32.515	32.415	32.49	269400.0
2006-11-30 12:00:00	CL	Stock	32.485	32.545	32.485	32.5	152000.0

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

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