PREVIEW / stock_1hour / 2003-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-18.parquet
  size:    457 KB
  rows:    21,896
  symbols: 1,588

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
2003-06-18 08:00:00	AAPL	Stock	0.3247	0.3348	0.3247	0.3284	5098800.0
2003-06-18 09:00:00	AAPL	Stock	0.3279	0.3339	0.3264	0.3338	48752144.0
2003-06-18 10:00:00	AAPL	Stock	0.3339	0.3376	0.333	0.3375	70087808.0
2003-06-18 11:00:00	AAPL	Stock	0.3375	0.3421	0.337	0.342	60938640.0
2003-06-18 12:00:00	AAPL	Stock	0.342	0.3479	0.3416	0.3445	79367232.0
2003-06-18 13:00:00	AAPL	Stock	0.3443	0.3466	0.3427	0.3455	29348592.0
2003-06-18 14:00:00	AAPL	Stock	0.3454	0.3455	0.3388	0.3402	38446520.0
2003-06-18 15:00:00	AAPL	Stock	0.3404	0.342	0.3389	0.3409	41004936.0
2003-06-18 16:00:00	AAPL	Stock	0.3407	0.3432	0.3395	0.3414	19540192.0
2003-06-18 17:00:00	AAPL	Stock	0.3418	0.3418	0.3396	0.3418	957600.0
2003-06-18 08:00:00	MSFT	Stock	25.98	26.1	25.85	25.89	153925.0
2003-06-18 09:00:00	MSFT	Stock	25.88	26.02	25.71	25.9	9988232.0
2003-06-18 10:00:00	MSFT	Stock	25.903	26.27	25.86	26.23	15762447.0
2003-06-18 11:00:00	MSFT	Stock	26.22	26.4	26.16	26.34	12713808.0
2003-06-18 12:00:00	MSFT	Stock	26.34	26.39	26.1	26.22	8270580.0
2003-06-18 13:00:00	MSFT	Stock	26.21	26.3	25.98	26.11	9682340.0
2003-06-18 14:00:00	MSFT	Stock	26.11	26.12	25.841	25.96	10415434.0
2003-06-18 15:00:00	MSFT	Stock	25.96	26.09	25.9	26.04	11881277.0
2003-06-18 16:00:00	MSFT	Stock	26.04	26.11	25.9619	26.06	1384110.0
2003-06-18 17:00:00	MSFT	Stock	26.08	26.0943	26.01	26.06	239823.0
2003-06-18 18:00:00	MSFT	Stock	26.05	26.07	26.04	26.04	6791.0
2003-06-18 08:00:00	NVDA	Stock	0.205	0.205	0.2018	0.2025	336000.0
2003-06-18 09:00:00	NVDA	Stock	0.2025	0.204	0.2008	0.2031	101850600.0
2003-06-18 10:00:00	NVDA	Stock	0.2032	0.2083	0.2027	0.2078	161013720.0
2003-06-18 11:00:00	NVDA	Stock	0.2079	0.2164	0.2071	0.2117	331853760.0
2003-06-18 12:00:00	NVDA	Stock	0.2118	0.213	0.2108	0.2122	116450520.0
2003-06-18 13:00:00	NVDA	Stock	0.2122	0.2146	0.2121	0.2132	70170600.0
2003-06-18 14:00:00	NVDA	Stock	0.2132	0.2137	0.2086	0.2107	112231440.0
2003-06-18 15:00:00	NVDA	Stock	0.2108	0.2131	0.2101	0.2117	128578200.0
2003-06-18 16:00:00	NVDA	Stock	0.2118	0.2133	0.2118	0.2132	11612400.0
2003-06-18 17:00:00	NVDA	Stock	0.2123	0.2137	0.2123	0.2136	1317000.0
2003-06-18 18:00:00	NVDA	Stock	0.2135	0.2137	0.2135	0.2137	360000.0
2003-06-18 08:00:00	AMZN	Stock	1.79	1.7925	1.781	1.781	154000.0
2003-06-18 09:00:00	AMZN	Stock	1.78	1.7975	1.7675	1.7926	14545820.0
2003-06-18 10:00:00	AMZN	Stock	1.7926	1.8184	1.778	1.813	31365160.0
2003-06-18 11:00:00	AMZN	Stock	1.812	1.8495	1.811	1.8405	35102920.0
2003-06-18 12:00:00	AMZN	Stock	1.8405	1.862	1.8275	1.8425	35466520.0
2003-06-18 13:00:00	AMZN	Stock	1.843	1.8555	1.8335	1.84	19710980.0
2003-06-18 14:00:00	AMZN	Stock	1.84	1.8405	1.8005	1.806	22336560.0
2003-06-18 15:00:00	AMZN	Stock	1.8056	1.811	1.7795	1.791	42970120.0
2003-06-18 16:00:00	AMZN	Stock	1.791	1.8125	1.78	1.79	3833080.0
2003-06-18 17:00:00	AMZN	Stock	1.79	1.7945	1.79	1.7945	182960.0
2003-06-18 18:00:00	AMZN	Stock	1.795	1.8	1.794	1.8	34000.0
2003-06-18 09:00:00	CL	Stock	30.25	30.255	30.115	30.18	598800.0
2003-06-18 10:00:00	CL	Stock	30.185	30.35	30.105	30.305	490600.0
2003-06-18 11:00:00	CL	Stock	30.28	30.38	30.28	30.365	239400.0
2003-06-18 12:00:00	CL	Stock	30.365	30.385	30.25	30.37	223800.0
2003-06-18 13:00:00	CL	Stock	30.365	30.37	30.285	30.345	147000.0
2003-06-18 14:00:00	CL	Stock	30.345	30.39	30.275	30.315	321200.0
2003-06-18 15:00:00	CL	Stock	30.305	30.425	30.255	30.41	640800.0

> showing 50 of 21,896 rows — these rows as CSV

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