PREVIEW / stock_1hour / 2000-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-07.parquet
  size:    296 KB
  rows:    15,266
  symbols: 1,182

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-07 08:00:00	AAPL	Stock	0.9286	0.9369	0.9286	0.9286	50400.0
2000-07-07 09:00:00	AAPL	Stock	0.9308	0.9598	0.9308	0.9542	40874400.0
2000-07-07 10:00:00	AAPL	Stock	0.9542	0.9621	0.9487	0.9531	31544800.0
2000-07-07 11:00:00	AAPL	Stock	0.9542	0.9598	0.9487	0.9565	26129600.0
2000-07-07 12:00:00	AAPL	Stock	0.9542	0.9788	0.9542	0.9688	50243200.0
2000-07-07 13:00:00	AAPL	Stock	0.9688	0.9754	0.9565	0.9665	28358400.0
2000-07-07 14:00:00	AAPL	Stock	0.9665	0.9754	0.9643	0.971	18216800.0
2000-07-07 15:00:00	AAPL	Stock	0.9699	0.9754	0.9554	0.9732	56980000.0
2000-07-07 16:00:00	AAPL	Stock	0.9732	0.9788	0.9598	0.9621	3757600.0
2000-07-07 17:00:00	AAPL	Stock	0.9643	0.9754	0.9621	0.9621	28000.0
2000-07-07 08:00:00	MSFT	Stock	40.1875	41.0	40.1875	40.6875	578400.0
2000-07-07 09:00:00	MSFT	Stock	40.625	40.9375	40.2812	40.8438	8350600.0
2000-07-07 10:00:00	MSFT	Stock	40.875	41.4062	40.625	41.375	13282800.0
2000-07-07 11:00:00	MSFT	Stock	41.3438	41.4375	41.1875	41.3125	7550400.0
2000-07-07 12:00:00	MSFT	Stock	41.3125	41.375	41.125	41.2188	3855400.0
2000-07-07 13:00:00	MSFT	Stock	41.1875	41.3125	41.0938	41.1875	3601400.0
2000-07-07 14:00:00	MSFT	Stock	41.1875	41.4062	41.1562	41.2812	5543000.0
2000-07-07 15:00:00	MSFT	Stock	41.2812	41.4062	40.9688	41.0	10041000.0
2000-07-07 16:00:00	MSFT	Stock	41.0	41.1562	40.8125	41.0	801800.0
2000-07-07 17:00:00	MSFT	Stock	41.0	41.0	40.9375	40.9375	1200.0
2000-07-07 18:00:00	MSFT	Stock	41.0	41.0	40.9375	41.0	1600.0
2000-07-07 08:00:00	NVDA	Stock	0.2443	0.2495	0.2443	0.2469	168000.0
2000-07-07 09:00:00	NVDA	Stock	0.2458	0.2542	0.2419	0.2483	64296000.0
2000-07-07 10:00:00	NVDA	Stock	0.2483	0.2484	0.2375	0.243	84096000.0
2000-07-07 11:00:00	NVDA	Stock	0.2432	0.2456	0.2401	0.2456	26400000.0
2000-07-07 12:00:00	NVDA	Stock	0.2438	0.2495	0.2438	0.2486	32976000.0
2000-07-07 13:00:00	NVDA	Stock	0.2484	0.25	0.2443	0.2445	25944000.0
2000-07-07 14:00:00	NVDA	Stock	0.2444	0.2474	0.2427	0.2469	48840000.0
2000-07-07 15:00:00	NVDA	Stock	0.2474	0.2474	0.2417	0.2422	60120000.0
2000-07-07 16:00:00	NVDA	Stock	0.2424	0.243	0.2418	0.2418	1488000.0
2000-07-07 08:00:00	AMZN	Stock	1.8	1.85	1.7812	1.8	208000.0
2000-07-07 09:00:00	AMZN	Stock	1.8	1.825	1.7625	1.8188	13594000.0
2000-07-07 10:00:00	AMZN	Stock	1.8172	1.8406	1.7938	1.8375	14676000.0
2000-07-07 11:00:00	AMZN	Stock	1.8312	1.85	1.8188	1.8219	12848000.0
2000-07-07 12:00:00	AMZN	Stock	1.825	1.825	1.7844	1.8094	12408000.0
2000-07-07 13:00:00	AMZN	Stock	1.8062	1.8125	1.7875	1.7969	4334000.0
2000-07-07 14:00:00	AMZN	Stock	1.7969	1.8078	1.7938	1.8031	7864000.0
2000-07-07 15:00:00	AMZN	Stock	1.8094	1.8219	1.8	1.8094	10250000.0
2000-07-07 16:00:00	AMZN	Stock	1.8125	1.8156	1.7875	1.8062	672000.0
2000-07-07 17:00:00	AMZN	Stock	1.8031	1.8062	1.8	1.8062	12000.0
2000-07-07 18:00:00	AMZN	Stock	1.8	1.8	1.8	1.8	48000.0
2000-07-07 09:00:00	CL	Stock	28.75	28.9688	28.7188	28.9062	526400.0
2000-07-07 10:00:00	CL	Stock	28.9062	28.9375	28.5625	28.625	851400.0
2000-07-07 11:00:00	CL	Stock	28.625	28.6562	28.4375	28.5625	682600.0
2000-07-07 12:00:00	CL	Stock	28.5625	28.625	28.4375	28.5625	366400.0
2000-07-07 13:00:00	CL	Stock	28.5938	28.6562	28.5625	28.5938	419200.0
2000-07-07 14:00:00	CL	Stock	28.625	28.7188	28.5938	28.7188	580400.0
2000-07-07 15:00:00	CL	Stock	28.7188	28.7812	28.5938	28.625	765800.0
2000-07-07 16:00:00	CL	Stock	28.625	28.625	28.5938	28.5938	50600.0
2000-07-07 17:00:00	CL	Stock	28.5938	28.5938	28.5938	28.5938	4000.0

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

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