PREVIEW / stock_1hour / 2005-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-24.parquet
  size:    547 KB
  rows:    26,204
  symbols: 1,985

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
2005-05-24 08:00:00	AAPL	Stock	1.4143	1.4161	1.4064	1.41	1800008.0
2005-05-24 09:00:00	AAPL	Stock	1.4082	1.4154	1.3939	1.4107	135980068.0
2005-05-24 10:00:00	AAPL	Stock	1.4104	1.4246	1.4004	1.4179	132355160.0
2005-05-24 11:00:00	AAPL	Stock	1.4182	1.4268	1.4086	1.4111	85253364.0
2005-05-24 12:00:00	AAPL	Stock	1.4111	1.4179	1.4089	1.4111	40793984.0
2005-05-24 13:00:00	AAPL	Stock	1.4111	1.4139	1.4054	1.4111	39941832.0
2005-05-24 14:00:00	AAPL	Stock	1.4111	1.4171	1.4093	1.4129	67102000.0
2005-05-24 15:00:00	AAPL	Stock	1.4131	1.4282	1.4114	1.4179	78404508.0
2005-05-24 16:00:00	AAPL	Stock	1.4179	1.4204	1.4131	1.4175	2088492.0
2005-05-24 17:00:00	AAPL	Stock	1.4171	1.4171	1.4143	1.4143	122108.0
2005-05-24 18:00:00	AAPL	Stock	1.4161	1.4171	1.4161	1.4171	333004.0
2005-05-24 08:00:00	MSFT	Stock	25.85	25.85	25.78	25.8	44325.0
2005-05-24 09:00:00	MSFT	Stock	25.8	25.83	25.72	25.78	4853321.0
2005-05-24 10:00:00	MSFT	Stock	25.78	25.79	25.72	25.761	5709950.0
2005-05-24 11:00:00	MSFT	Stock	25.76	25.88	25.72	25.78	10763260.0
2005-05-24 12:00:00	MSFT	Stock	25.77	25.85	25.74	25.78	7098725.0
2005-05-24 13:00:00	MSFT	Stock	25.78	25.82	25.74	25.78	5771297.0
2005-05-24 14:00:00	MSFT	Stock	25.78	25.85	25.74	25.76	10508470.0
2005-05-24 15:00:00	MSFT	Stock	25.77	25.85	25.72	25.76	13727089.0
2005-05-24 16:00:00	MSFT	Stock	25.75	25.8	25.73	25.78	2331559.0
2005-05-24 17:00:00	MSFT	Stock	25.75	25.78	25.75	25.75	154900.0
2005-05-24 09:00:00	NVDA	Stock	0.2237	0.2246	0.2221	0.2245	51796920.0
2005-05-24 10:00:00	NVDA	Stock	0.2244	0.2259	0.2229	0.224	68945640.0
2005-05-24 11:00:00	NVDA	Stock	0.224	0.2252	0.2239	0.2247	69000480.0
2005-05-24 12:00:00	NVDA	Stock	0.2247	0.2258	0.224	0.2247	72368520.0
2005-05-24 13:00:00	NVDA	Stock	0.2247	0.2255	0.2235	0.2249	68421000.0
2005-05-24 14:00:00	NVDA	Stock	0.2249	0.2255	0.2242	0.2252	48919080.0
2005-05-24 15:00:00	NVDA	Stock	0.2252	0.2282	0.2242	0.2276	132248160.0
2005-05-24 16:00:00	NVDA	Stock	0.2274	0.2279	0.2274	0.2276	803520.0
2005-05-24 17:00:00	NVDA	Stock	0.2274	0.2274	0.2274	0.2274	112800.0
2005-05-24 18:00:00	NVDA	Stock	0.2271	0.2275	0.2271	0.2275	28080.0
2005-05-24 08:00:00	AMZN	Stock	1.78	1.78	1.78	1.78	20000.0
2005-05-24 09:00:00	AMZN	Stock	1.78	1.781	1.768	1.7705	12258760.0
2005-05-24 10:00:00	AMZN	Stock	1.7705	1.7785	1.768	1.7715	17387660.0
2005-05-24 11:00:00	AMZN	Stock	1.7715	1.7765	1.769	1.7695	13493640.0
2005-05-24 12:00:00	AMZN	Stock	1.769	1.7715	1.7565	1.757	19039700.0
2005-05-24 13:00:00	AMZN	Stock	1.757	1.7635	1.7565	1.76	8609420.0
2005-05-24 14:00:00	AMZN	Stock	1.76	1.768	1.7595	1.7615	20401060.0
2005-05-24 15:00:00	AMZN	Stock	1.762	1.777	1.7595	1.777	25674780.0
2005-05-24 16:00:00	AMZN	Stock	1.7755	1.7785	1.7755	1.777	373600.0
2005-05-24 17:00:00	AMZN	Stock	1.7775	1.778	1.777	1.778	36000.0
2005-05-24 18:00:00	AMZN	Stock	1.78	1.78	1.78	1.78	8000.0
2005-05-24 09:00:00	CL	Stock	25.45	25.45	25.22	25.32	341400.0
2005-05-24 10:00:00	CL	Stock	25.32	25.32	25.2	25.285	436600.0
2005-05-24 11:00:00	CL	Stock	25.29	25.35	25.255	25.32	346800.0
2005-05-24 12:00:00	CL	Stock	25.32	25.39	25.275	25.28	211400.0
2005-05-24 13:00:00	CL	Stock	25.28	25.315	25.265	25.305	128600.0
2005-05-24 14:00:00	CL	Stock	25.315	25.385	25.3	25.365	411000.0
2005-05-24 15:00:00	CL	Stock	25.365	25.475	25.365	25.425	1012800.0
2005-05-24 16:00:00	CL	Stock	25.405	25.405	25.405	25.405	600.0

> showing 50 of 26,204 rows — these rows as CSV

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