PREVIEW / stock_1hour / 2000-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-28.parquet
  size:    306 KB
  rows:    15,661
  symbols: 1,187

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-06-28 08:00:00	AAPL	Stock	0.9286	0.9342	0.9286	0.933	89600.0
2000-06-28 09:00:00	AAPL	Stock	0.9336	0.9554	0.9196	0.9319	34988800.0
2000-06-28 10:00:00	AAPL	Stock	0.933	0.952	0.9308	0.9358	34473600.0
2000-06-28 11:00:00	AAPL	Stock	0.9364	0.9542	0.9342	0.9531	22512000.0
2000-06-28 12:00:00	AAPL	Stock	0.952	0.9554	0.9475	0.9554	19180000.0
2000-06-28 13:00:00	AAPL	Stock	0.9542	0.9732	0.9542	0.9721	30452800.0
2000-06-28 14:00:00	AAPL	Stock	0.971	0.9821	0.9464	0.9788	56851200.0
2000-06-28 15:00:00	AAPL	Stock	0.9799	0.9888	0.9676	0.9721	78472800.0
2000-06-28 16:00:00	AAPL	Stock	0.9721	0.9754	0.9688	0.9721	5174400.0
2000-06-28 17:00:00	AAPL	Stock	0.9721	0.9721	0.9721	0.9721	100800.0
2000-06-28 08:00:00	MSFT	Stock	39.0625	39.8125	39.0312	39.75	100200.0
2000-06-28 09:00:00	MSFT	Stock	39.75	39.8125	39.3125	39.5938	5615800.0
2000-06-28 10:00:00	MSFT	Stock	39.5938	39.8438	39.375	39.375	5939800.0
2000-06-28 11:00:00	MSFT	Stock	39.375	39.9688	39.3125	39.9219	2938800.0
2000-06-28 12:00:00	MSFT	Stock	39.9062	40.0	39.7188	39.8125	5155200.0
2000-06-28 13:00:00	MSFT	Stock	39.8125	39.8438	39.5625	39.625	3230600.0
2000-06-28 14:00:00	MSFT	Stock	39.5938	39.9688	39.4688	39.9375	5863000.0
2000-06-28 15:00:00	MSFT	Stock	39.875	40.0312	39.3125	39.4688	6726800.0
2000-06-28 16:00:00	MSFT	Stock	39.4688	39.75	39.4062	39.4688	1439600.0
2000-06-28 17:00:00	MSFT	Stock	39.4688	39.625	39.4688	39.625	66400.0
2000-06-28 18:00:00	MSFT	Stock	39.625	39.625	39.5938	39.5938	1600.0
2000-06-28 08:00:00	NVDA	Stock	0.2969	0.3021	0.2969	0.3	8520000.0
2000-06-28 09:00:00	NVDA	Stock	0.3	0.3146	0.3	0.301	70368000.0
2000-06-28 10:00:00	NVDA	Stock	0.301	0.3031	0.2833	0.2938	134448000.0
2000-06-28 11:00:00	NVDA	Stock	0.2935	0.2956	0.2813	0.2818	58752000.0
2000-06-28 12:00:00	NVDA	Stock	0.2818	0.2852	0.2771	0.2839	73344000.0
2000-06-28 13:00:00	NVDA	Stock	0.2839	0.2875	0.2823	0.2865	35832000.0
2000-06-28 14:00:00	NVDA	Stock	0.2865	0.2896	0.2823	0.2875	75048000.0
2000-06-28 15:00:00	NVDA	Stock	0.2875	0.2901	0.2818	0.2844	111792000.0
2000-06-28 16:00:00	NVDA	Stock	0.2859	0.2896	0.2766	0.2854	8304000.0
2000-06-28 17:00:00	NVDA	Stock	0.2862	0.2917	0.2862	0.2896	1152000.0
2000-06-28 18:00:00	NVDA	Stock	0.2896	0.2953	0.2896	0.2953	240000.0
2000-06-28 08:00:00	AMZN	Stock	1.825	1.8688	1.825	1.85	422200.0
2000-06-28 09:00:00	AMZN	Stock	1.8469	1.875	1.8062	1.8375	27400000.0
2000-06-28 10:00:00	AMZN	Stock	1.8344	1.8688	1.825	1.8281	25444000.0
2000-06-28 11:00:00	AMZN	Stock	1.8281	1.9938	1.8125	1.9812	54936000.0
2000-06-28 12:00:00	AMZN	Stock	1.9875	1.9969	1.9125	1.9219	69566000.0
2000-06-28 13:00:00	AMZN	Stock	1.9219	1.9375	1.8859	1.9062	29126000.0
2000-06-28 14:00:00	AMZN	Stock	1.9062	1.925	1.8688	1.9094	52768000.0
2000-06-28 15:00:00	AMZN	Stock	1.9094	1.9312	1.875	1.8969	31694000.0
2000-06-28 16:00:00	AMZN	Stock	1.8969	1.9062	1.8656	1.875	3210000.0
2000-06-28 17:00:00	AMZN	Stock	1.8781	1.8938	1.8625	1.8625	788000.0
2000-06-28 18:00:00	AMZN	Stock	1.8656	1.8906	1.8656	1.8688	58000.0
2000-06-28 09:00:00	CL	Stock	28.5	28.5	28.1562	28.1875	248200.0
2000-06-28 10:00:00	CL	Stock	28.1562	28.1875	27.75	27.9062	622600.0
2000-06-28 11:00:00	CL	Stock	27.9375	28.0	27.875	27.9062	95800.0
2000-06-28 12:00:00	CL	Stock	27.9375	28.0312	27.9062	28.0	170000.0
2000-06-28 13:00:00	CL	Stock	28.0312	28.2188	28.0	28.1875	194600.0
2000-06-28 14:00:00	CL	Stock	28.2188	28.5	28.1562	28.4375	266800.0
2000-06-28 15:00:00	CL	Stock	28.4375	28.75	28.25	28.3125	785000.0

> showing 50 of 15,661 rows — these rows as CSV

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