PREVIEW / stock_1hour / 2001-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-27.parquet
  size:    355 KB
  rows:    17,229
  symbols: 1,338

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-09-27 08:00:00	AAPL	Stock	0.2695	0.2713	0.2695	0.2705	408800.0
2001-09-27 09:00:00	AAPL	Stock	0.2732	0.278	0.2703	0.2771	40919200.0
2001-09-27 10:00:00	AAPL	Stock	0.2771	0.2804	0.2759	0.2784	48938400.0
2001-09-27 11:00:00	AAPL	Stock	0.2784	0.2803	0.2768	0.2782	34333600.0
2001-09-27 12:00:00	AAPL	Stock	0.2782	0.2804	0.2768	0.2771	36288000.0
2001-09-27 13:00:00	AAPL	Stock	0.277	0.2784	0.2764	0.277	26068000.0
2001-09-27 14:00:00	AAPL	Stock	0.277	0.2813	0.2768	0.2777	34434400.0
2001-09-27 15:00:00	AAPL	Stock	0.2775	0.2809	0.2759	0.2768	61258400.0
2001-09-27 16:00:00	AAPL	Stock	0.2768	0.2812	0.2759	0.277	12650400.0
2001-09-27 17:00:00	AAPL	Stock	0.277	0.277	0.277	0.277	912800.0
2001-09-27 18:00:00	AAPL	Stock	0.2761	0.2761	0.2761	0.2761	11200.0
2001-09-27 08:00:00	MSFT	Stock	25.175	25.185	24.95	24.95	88400.0
2001-09-27 09:00:00	MSFT	Stock	24.96	25.34	24.695	24.885	7378800.0
2001-09-27 10:00:00	MSFT	Stock	24.89	25.035	24.375	24.5045	13523400.0
2001-09-27 11:00:00	MSFT	Stock	24.505	24.53	24.23	24.3	8315400.0
2001-09-27 12:00:00	MSFT	Stock	24.305	24.33	24.0	24.155	14907000.0
2001-09-27 13:00:00	MSFT	Stock	24.16	24.25	24.06	24.22	4302400.0
2001-09-27 14:00:00	MSFT	Stock	24.22	24.74	24.11	24.665	10036000.0
2001-09-27 15:00:00	MSFT	Stock	24.685	25.125	24.595	24.985	14485400.0
2001-09-27 16:00:00	MSFT	Stock	24.98	24.995	24.5092	24.995	2057400.0
2001-09-27 17:00:00	MSFT	Stock	24.98	24.98	24.445	24.975	493400.0
2001-09-27 18:00:00	MSFT	Stock	25.0	25.05	25.0	25.05	3200.0
2001-09-27 08:00:00	NVDA	Stock	0.2304	0.2313	0.2271	0.2279	204000.0
2001-09-27 09:00:00	NVDA	Stock	0.2303	0.2333	0.2276	0.228	43092000.0
2001-09-27 10:00:00	NVDA	Stock	0.2279	0.2282	0.2126	0.2178	145800000.0
2001-09-27 11:00:00	NVDA	Stock	0.2179	0.22	0.2152	0.2172	115620000.0
2001-09-27 12:00:00	NVDA	Stock	0.2174	0.2195	0.2157	0.2167	51180000.0
2001-09-27 13:00:00	NVDA	Stock	0.2162	0.2182	0.214	0.217	85296000.0
2001-09-27 14:00:00	NVDA	Stock	0.2167	0.2227	0.2158	0.2224	199776000.0
2001-09-27 15:00:00	NVDA	Stock	0.2222	0.2307	0.2159	0.2186	201192000.0
2001-09-27 16:00:00	NVDA	Stock	0.2191	0.2197	0.2178	0.2192	10260000.0
2001-09-27 17:00:00	NVDA	Stock	0.2187	0.2187	0.2175	0.2175	684000.0
2001-09-27 18:00:00	NVDA	Stock	0.2196	0.2229	0.2196	0.2229	120000.0
2001-09-27 08:00:00	AMZN	Stock	0.318	0.318	0.315	0.3175	26000.0
2001-09-27 09:00:00	AMZN	Stock	0.3175	0.332	0.3065	0.312	18780000.0
2001-09-27 10:00:00	AMZN	Stock	0.3115	0.3125	0.3015	0.303	27512000.0
2001-09-27 11:00:00	AMZN	Stock	0.302	0.303	0.284	0.2935	20768000.0
2001-09-27 12:00:00	AMZN	Stock	0.295	0.298	0.2855	0.293	12304000.0
2001-09-27 13:00:00	AMZN	Stock	0.293	0.297	0.289	0.295	13076000.0
2001-09-27 14:00:00	AMZN	Stock	0.295	0.3215	0.29	0.3055	24480000.0
2001-09-27 15:00:00	AMZN	Stock	0.3058	0.32	0.302	0.31	30210000.0
2001-09-27 16:00:00	AMZN	Stock	0.3095	0.3125	0.3065	0.309	5314000.0
2001-09-27 17:00:00	AMZN	Stock	0.31	0.31	0.3075	0.3075	162000.0
2001-09-27 18:00:00	AMZN	Stock	0.3075	0.3075	0.3075	0.3075	6000.0
2001-09-27 09:00:00	CL	Stock	28.35	28.5	28.305	28.475	324400.0
2001-09-27 10:00:00	CL	Stock	28.475	28.825	28.41	28.775	659600.0
2001-09-27 11:00:00	CL	Stock	28.75	28.765	28.4	28.4	531000.0
2001-09-27 12:00:00	CL	Stock	28.405	28.57	28.25	28.5	737200.0
2001-09-27 13:00:00	CL	Stock	28.5	28.6	28.385	28.585	320200.0
2001-09-27 14:00:00	CL	Stock	28.585	28.785	28.585	28.705	433400.0

> showing 50 of 17,229 rows — these rows as CSV

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