PREVIEW / stock_1hour / 2000-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-30.parquet
  size:    346 KB
  rows:    17,370
  symbols: 1,204

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-30 08:00:00	AAPL	Stock	0.9157	0.9157	0.9157	0.9157	504000.0
2000-06-30 09:00:00	AAPL	Stock	0.9196	0.9464	0.9163	0.9353	29136800.0
2000-06-30 10:00:00	AAPL	Stock	0.9308	0.9375	0.923	0.9275	25295200.0
2000-06-30 11:00:00	AAPL	Stock	0.9275	0.9665	0.9241	0.9498	49459200.0
2000-06-30 12:00:00	AAPL	Stock	0.9498	0.9699	0.9442	0.9671	25771200.0
2000-06-30 13:00:00	AAPL	Stock	0.9665	0.981	0.9621	0.9637	29355200.0
2000-06-30 14:00:00	AAPL	Stock	0.9632	0.9643	0.9565	0.9598	29926400.0
2000-06-30 15:00:00	AAPL	Stock	0.9598	0.9598	0.9308	0.9353	68740000.0
2000-06-30 16:00:00	AAPL	Stock	0.9375	0.9503	0.9219	0.9275	26947200.0
2000-06-30 17:00:00	AAPL	Stock	0.9275	0.9358	0.9252	0.9347	5000800.0
2000-06-30 18:00:00	AAPL	Stock	0.9353	0.9353	0.9308	0.9353	190400.0
2000-06-30 08:00:00	MSFT	Stock	38.75	38.7812	38.625	38.625	24400.0
2000-06-30 09:00:00	MSFT	Stock	38.75	38.875	38.3438	38.75	5161200.0
2000-06-30 10:00:00	MSFT	Stock	38.75	39.0625	38.7188	38.75	5871000.0
2000-06-30 11:00:00	MSFT	Stock	38.75	39.0938	38.75	38.9375	4558600.0
2000-06-30 12:00:00	MSFT	Stock	38.9062	39.3125	38.875	39.1562	3783800.0
2000-06-30 13:00:00	MSFT	Stock	39.1562	39.4375	39.0312	39.2188	4830400.0
2000-06-30 14:00:00	MSFT	Stock	39.25	39.4688	39.0	39.4062	3850800.0
2000-06-30 15:00:00	MSFT	Stock	39.375	40.0	39.2812	39.9688	10533600.0
2000-06-30 16:00:00	MSFT	Stock	40.0	40.0	39.1719	39.9688	8420600.0
2000-06-30 17:00:00	MSFT	Stock	40.0	40.0469	39.875	39.9844	4220000.0
2000-06-30 18:00:00	MSFT	Stock	39.9375	40.0	39.9219	39.9375	109200.0
2000-06-30 08:00:00	NVDA	Stock	0.2474	0.2505	0.2474	0.2505	288000.0
2000-06-30 09:00:00	NVDA	Stock	0.2542	0.2583	0.2432	0.2518	117624000.0
2000-06-30 10:00:00	NVDA	Stock	0.2516	0.2693	0.2516	0.262	234768000.0
2000-06-30 11:00:00	NVDA	Stock	0.2617	0.262	0.2563	0.257	104592000.0
2000-06-30 12:00:00	NVDA	Stock	0.257	0.2573	0.2479	0.2482	107448000.0
2000-06-30 13:00:00	NVDA	Stock	0.2479	0.2526	0.2479	0.2495	138528000.0
2000-06-30 14:00:00	NVDA	Stock	0.25	0.25	0.2438	0.2474	165408000.0
2000-06-30 15:00:00	NVDA	Stock	0.2474	0.2661	0.2432	0.2648	195888000.0
2000-06-30 16:00:00	NVDA	Stock	0.2646	0.2667	0.262	0.2648	91128000.0
2000-06-30 17:00:00	NVDA	Stock	0.2648	0.2648	0.2628	0.2646	42528000.0
2000-06-30 18:00:00	NVDA	Stock	0.2625	0.2625	0.2625	0.2625	72000.0
2000-06-30 08:00:00	AMZN	Stock	1.8625	1.9	1.8562	1.8562	200000.0
2000-06-30 09:00:00	AMZN	Stock	1.8719	1.8719	1.775	1.7906	22246000.0
2000-06-30 10:00:00	AMZN	Stock	1.7906	1.8531	1.7844	1.8438	28242000.0
2000-06-30 11:00:00	AMZN	Stock	1.8469	1.85	1.8062	1.8125	10512000.0
2000-06-30 12:00:00	AMZN	Stock	1.8125	1.8188	1.8062	1.8125	10652000.0
2000-06-30 13:00:00	AMZN	Stock	1.8188	1.8219	1.8125	1.8156	16156000.0
2000-06-30 14:00:00	AMZN	Stock	1.8156	1.8219	1.8	1.8125	11544000.0
2000-06-30 15:00:00	AMZN	Stock	1.8125	1.825	1.8	1.8156	19166000.0
2000-06-30 16:00:00	AMZN	Stock	1.8156	1.9	1.7969	1.8438	5288000.0
2000-06-30 17:00:00	AMZN	Stock	1.85	1.8625	1.8125	1.8141	2402000.0
2000-06-30 18:00:00	AMZN	Stock	1.8484	1.8484	1.8484	1.8484	4000.0
2000-06-30 09:00:00	CL	Stock	28.3125	28.375	28.3125	28.375	145600.0
2000-06-30 10:00:00	CL	Stock	28.375	28.5625	28.3438	28.5625	242800.0
2000-06-30 11:00:00	CL	Stock	28.5312	28.6562	28.5	28.625	369400.0
2000-06-30 12:00:00	CL	Stock	28.6562	29.0	28.625	28.8125	581000.0
2000-06-30 13:00:00	CL	Stock	28.8125	29.0625	28.7812	29.0625	545400.0
2000-06-30 14:00:00	CL	Stock	29.0625	29.6562	29.0	29.625	578000.0

> showing 50 of 17,370 rows — these rows as CSV

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