PREVIEW / stock_1hour / 2001-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-27.parquet
  size:    358 KB
  rows:    16,722
  symbols: 1,277

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
2001-03-27 08:00:00	AAPL	Stock	0.3889	0.3929	0.3889	0.3929	627200.0
2001-03-27 09:00:00	AAPL	Stock	0.3929	0.3964	0.3902	0.3946	56190400.0
2001-03-27 10:00:00	AAPL	Stock	0.3955	0.4116	0.3946	0.4104	129802400.0
2001-03-27 11:00:00	AAPL	Stock	0.4105	0.4116	0.4054	0.407	80830400.0
2001-03-27 12:00:00	AAPL	Stock	0.4066	0.408	0.4039	0.4055	48451200.0
2001-03-27 13:00:00	AAPL	Stock	0.4054	0.4055	0.3973	0.3998	52561600.0
2001-03-27 14:00:00	AAPL	Stock	0.3998	0.4066	0.3991	0.4048	48675200.0
2001-03-27 15:00:00	AAPL	Stock	0.4048	0.4089	0.4032	0.4082	77459200.0
2001-03-27 16:00:00	AAPL	Stock	0.4084	0.4088	0.4018	0.4084	20899200.0
2001-03-27 17:00:00	AAPL	Stock	0.4018	0.4084	0.3784	0.4084	935200.0
2001-03-27 18:00:00	AAPL	Stock	0.393	0.393	0.393	0.393	5600.0
2001-03-27 08:00:00	MSFT	Stock	28.0469	28.1875	28.0469	28.0625	193400.0
2001-03-27 09:00:00	MSFT	Stock	28.0625	28.3125	27.9375	28.25	11876600.0
2001-03-27 10:00:00	MSFT	Stock	28.25	29.0625	28.1406	28.9375	22248000.0
2001-03-27 11:00:00	MSFT	Stock	28.9375	29.0312	28.7031	28.875	11315000.0
2001-03-27 12:00:00	MSFT	Stock	28.8438	29.0938	28.6875	28.9375	7944600.0
2001-03-27 13:00:00	MSFT	Stock	28.9375	29.0625	28.7812	28.8438	8140400.0
2001-03-27 14:00:00	MSFT	Stock	28.8125	29.2812	28.7812	28.9062	10295000.0
2001-03-27 15:00:00	MSFT	Stock	28.9219	29.25	28.8438	29.1406	14564000.0
2001-03-27 16:00:00	MSFT	Stock	29.1406	29.2188	28.7969	29.1406	5752400.0
2001-03-27 17:00:00	MSFT	Stock	29.125	29.125	28.875	28.875	334600.0
2001-03-27 18:00:00	MSFT	Stock	28.875	28.9375	28.8438	28.875	7000.0
2001-03-27 08:00:00	NVDA	Stock	0.2956	0.2979	0.2917	0.2917	936000.0
2001-03-27 09:00:00	NVDA	Stock	0.2911	0.2917	0.2854	0.2867	144912000.0
2001-03-27 10:00:00	NVDA	Stock	0.2867	0.2987	0.2841	0.2966	326592000.0
2001-03-27 11:00:00	NVDA	Stock	0.2966	0.2969	0.2893	0.2904	116952000.0
2001-03-27 12:00:00	NVDA	Stock	0.2904	0.2935	0.287	0.2888	120480000.0
2001-03-27 13:00:00	NVDA	Stock	0.2888	0.2891	0.2828	0.2828	115272000.0
2001-03-27 14:00:00	NVDA	Stock	0.2831	0.2854	0.2714	0.2734	307800000.0
2001-03-27 15:00:00	NVDA	Stock	0.2734	0.2885	0.2714	0.2839	469752000.0
2001-03-27 16:00:00	NVDA	Stock	0.2839	0.2875	0.275	0.2831	34680000.0
2001-03-27 17:00:00	NVDA	Stock	0.2818	0.2836	0.2783	0.2792	1248000.0
2001-03-27 18:00:00	NVDA	Stock	0.2805	0.2805	0.2805	0.2805	240000.0
2001-03-27 08:00:00	AMZN	Stock	0.549	0.553	0.549	0.55	120000.0
2001-03-27 09:00:00	AMZN	Stock	0.55	0.555	0.5255	0.5325	13644000.0
2001-03-27 10:00:00	AMZN	Stock	0.5315	0.5375	0.5255	0.534	18028000.0
2001-03-27 11:00:00	AMZN	Stock	0.5335	0.5405	0.533	0.5385	8970000.0
2001-03-27 12:00:00	AMZN	Stock	0.5385	0.5595	0.538	0.555	12680000.0
2001-03-27 13:00:00	AMZN	Stock	0.5555	0.5575	0.5485	0.55	7554000.0
2001-03-27 14:00:00	AMZN	Stock	0.55	0.5595	0.549	0.557	18990000.0
2001-03-27 15:00:00	AMZN	Stock	0.557	0.59	0.5555	0.582	26176000.0
2001-03-27 16:00:00	AMZN	Stock	0.5815	0.5875	0.576	0.5825	2752000.0
2001-03-27 17:00:00	AMZN	Stock	0.5825	0.5825	0.582	0.5825	50000.0
2001-03-27 18:00:00	AMZN	Stock	0.582	0.5845	0.582	0.5845	34000.0
2001-03-27 09:00:00	CL	Stock	26.525	26.75	26.425	26.75	266200.0
2001-03-27 10:00:00	CL	Stock	26.77	27.005	26.74	26.905	811400.0
2001-03-27 11:00:00	CL	Stock	26.905	27.45	26.875	27.33	945400.0
2001-03-27 12:00:00	CL	Stock	27.33	27.475	27.265	27.475	433600.0
2001-03-27 13:00:00	CL	Stock	27.475	27.8	27.4	27.71	812000.0
2001-03-27 14:00:00	CL	Stock	27.715	27.85	27.5	27.625	760000.0

> showing 50 of 16,722 rows — these rows as CSV

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