PREVIEW / stock_1hour / 2003-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-16.parquet
  size:    462 KB
  rows:    22,343
  symbols: 1,586

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-16 09:00:00	AAPL	Stock	0.3125	0.3161	0.3109	0.3127	18558232.0
2003-06-16 10:00:00	AAPL	Stock	0.3127	0.3198	0.3123	0.3191	25211648.0
2003-06-16 11:00:00	AAPL	Stock	0.3191	0.3207	0.317	0.3188	29186136.0
2003-06-16 12:00:00	AAPL	Stock	0.3189	0.3195	0.3173	0.3179	16862328.0
2003-06-16 13:00:00	AAPL	Stock	0.3179	0.3196	0.3168	0.3188	10598168.0
2003-06-16 14:00:00	AAPL	Stock	0.3191	0.3223	0.3186	0.3211	45109960.0
2003-06-16 15:00:00	AAPL	Stock	0.3209	0.325	0.3196	0.3243	56072408.0
2003-06-16 16:00:00	AAPL	Stock	0.3243	0.33	0.3198	0.3263	11555656.0
2003-06-16 17:00:00	AAPL	Stock	0.3263	0.3263	0.3263	0.3263	525000.0
2003-06-16 18:00:00	AAPL	Stock	0.3263	0.3263	0.3263	0.3263	5600.0
2003-06-16 08:00:00	MSFT	Stock	24.65	24.84	24.62	24.81	55740.0
2003-06-16 09:00:00	MSFT	Stock	24.734	24.85	24.669	24.83	7250855.0
2003-06-16 10:00:00	MSFT	Stock	24.83	25.02	24.78	24.9831	10471039.0
2003-06-16 11:00:00	MSFT	Stock	24.989	25.12	24.98	25.04	8191428.0
2003-06-16 12:00:00	MSFT	Stock	25.04	25.1	24.97	24.99	5556553.0
2003-06-16 13:00:00	MSFT	Stock	24.98	25.06	24.93	25.04	3524626.0
2003-06-16 14:00:00	MSFT	Stock	25.04	25.09	25.0	25.05	6036636.0
2003-06-16 15:00:00	MSFT	Stock	25.05	25.412	24.99	25.34	19101029.0
2003-06-16 16:00:00	MSFT	Stock	25.34	25.42	24.96	25.39	2287699.0
2003-06-16 17:00:00	MSFT	Stock	25.399	25.4	24.95	25.39	519469.0
2003-06-16 18:00:00	MSFT	Stock	25.39	25.39	25.35	25.37	16046.0
2003-06-16 08:00:00	NVDA	Stock	0.1956	0.1977	0.195	0.1977	1502400.0
2003-06-16 09:00:00	NVDA	Stock	0.1978	0.1986	0.1891	0.1911	362660640.0
2003-06-16 10:00:00	NVDA	Stock	0.1913	0.1928	0.1848	0.1928	471346200.0
2003-06-16 11:00:00	NVDA	Stock	0.1928	0.1978	0.1919	0.1973	228117480.0
2003-06-16 12:00:00	NVDA	Stock	0.1973	0.1995	0.1972	0.1981	137142240.0
2003-06-16 13:00:00	NVDA	Stock	0.1981	0.2008	0.1977	0.1997	129445800.0
2003-06-16 14:00:00	NVDA	Stock	0.1998	0.2022	0.1993	0.2	172432200.0
2003-06-16 15:00:00	NVDA	Stock	0.1999	0.2005	0.198	0.1999	164649720.0
2003-06-16 16:00:00	NVDA	Stock	0.1998	0.2002	0.1931	0.2	6966480.0
2003-06-16 17:00:00	NVDA	Stock	0.1999	0.1999	0.1992	0.1997	972000.0
2003-06-16 18:00:00	NVDA	Stock	0.1992	0.1992	0.1985	0.1985	624720.0
2003-06-16 08:00:00	AMZN	Stock	1.7125	1.72	1.7125	1.72	58000.0
2003-06-16 09:00:00	AMZN	Stock	1.7185	1.7305	1.704	1.723	15352900.0
2003-06-16 10:00:00	AMZN	Stock	1.723	1.754	1.718	1.752	23484920.0
2003-06-16 11:00:00	AMZN	Stock	1.7525	1.7645	1.748	1.7554	22032160.0
2003-06-16 12:00:00	AMZN	Stock	1.7555	1.765	1.7545	1.7555	13286420.0
2003-06-16 13:00:00	AMZN	Stock	1.755	1.7745	1.755	1.773	12289320.0
2003-06-16 14:00:00	AMZN	Stock	1.773	1.789	1.771	1.782	18002280.0
2003-06-16 15:00:00	AMZN	Stock	1.7825	1.7925	1.7755	1.792	24087380.0
2003-06-16 16:00:00	AMZN	Stock	1.792	1.7955	1.7592	1.795	1841820.0
2003-06-16 17:00:00	AMZN	Stock	1.792	1.792	1.7586	1.7586	836000.0
2003-06-16 18:00:00	AMZN	Stock	1.795	1.795	1.7925	1.7925	21060.0
2003-06-16 09:00:00	CL	Stock	29.96	30.335	29.955	30.28	545400.0
2003-06-16 10:00:00	CL	Stock	30.285	30.3	30.175	30.205	694800.0
2003-06-16 11:00:00	CL	Stock	30.21	30.32	30.205	30.315	656000.0
2003-06-16 12:00:00	CL	Stock	30.315	30.365	30.25	30.265	396000.0
2003-06-16 13:00:00	CL	Stock	30.265	30.315	30.225	30.255	238400.0
2003-06-16 14:00:00	CL	Stock	30.26	30.3	30.205	30.265	450400.0
2003-06-16 15:00:00	CL	Stock	30.26	30.41	30.25	30.405	480200.0

> showing 50 of 22,343 rows — these rows as CSV

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