PREVIEW / stock_1hour / 2000-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-03.parquet
  size:    195 KB
  rows:    9,071
  symbols: 1,161

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
2000-07-03 08:00:00	AAPL	Stock	0.9353	0.9353	0.9353	0.9353	106400.0
2000-07-03 09:00:00	AAPL	Stock	0.9353	0.9565	0.9308	0.9509	17158400.0
2000-07-03 10:00:00	AAPL	Stock	0.952	0.9699	0.9487	0.9576	14481600.0
2000-07-03 11:00:00	AAPL	Stock	0.9576	0.9643	0.952	0.9554	9805600.0
2000-07-03 12:00:00	AAPL	Stock	0.9554	0.9688	0.952	0.952	24572800.0
2000-07-03 13:00:00	AAPL	Stock	0.952	0.9565	0.952	0.952	728000.0
2000-07-03 08:00:00	MSFT	Stock	39.75	40.0	39.6875	39.7188	46000.0
2000-07-03 09:00:00	MSFT	Stock	39.875	40.0	39.6875	39.8125	2649600.0
2000-07-03 10:00:00	MSFT	Stock	39.8125	39.9688	39.6875	39.6875	4188000.0
2000-07-03 11:00:00	MSFT	Stock	39.6875	40.0	39.6875	39.875	3052800.0
2000-07-03 12:00:00	MSFT	Stock	39.875	40.0312	39.8125	39.9688	3934600.0
2000-07-03 13:00:00	MSFT	Stock	39.9688	40.0	39.9688	39.9688	51600.0
2000-07-03 08:00:00	NVDA	Stock	0.2648	0.2648	0.2648	0.2648	888000.0
2000-07-03 09:00:00	NVDA	Stock	0.2648	0.275	0.2635	0.2659	49464000.0
2000-07-03 10:00:00	NVDA	Stock	0.2659	0.2667	0.2521	0.2566	68400000.0
2000-07-03 11:00:00	NVDA	Stock	0.256	0.2604	0.2523	0.256	37536000.0
2000-07-03 12:00:00	NVDA	Stock	0.2563	0.257	0.2521	0.2547	68424000.0
2000-07-03 13:00:00	NVDA	Stock	0.2547	0.2547	0.2547	0.2547	24000.0
2000-07-03 08:00:00	AMZN	Stock	1.8719	1.8719	1.8	1.8188	276000.0
2000-07-03 09:00:00	AMZN	Stock	1.8219	1.8688	1.8219	1.8531	10528000.0
2000-07-03 10:00:00	AMZN	Stock	1.8531	1.875	1.85	1.8594	7526000.0
2000-07-03 11:00:00	AMZN	Stock	1.8562	1.8719	1.8516	1.8625	6838000.0
2000-07-03 12:00:00	AMZN	Stock	1.8656	1.8719	1.85	1.8562	7702000.0
2000-07-03 13:00:00	AMZN	Stock	1.85	1.8594	1.85	1.85	286000.0
2000-07-03 09:00:00	CL	Stock	29.8125	29.8438	29.5312	29.5312	368400.0
2000-07-03 10:00:00	CL	Stock	29.5312	29.5625	29.3125	29.4375	482600.0
2000-07-03 11:00:00	CL	Stock	29.4375	29.75	29.4062	29.75	307600.0
2000-07-03 12:00:00	CL	Stock	29.75	30.0	29.75	29.9688	515600.0
2000-07-03 13:00:00	CL	Stock	29.9688	29.9688	29.9375	29.9375	26800.0

> showing 29 of 9,071 rows — these rows as CSV

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