PREVIEW / stock_1hour / 2000-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-18.parquet
  size:    300 KB
  rows:    15,435
  symbols: 1,199

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-18 08:00:00	AAPL	Stock	1.0458	1.0536	1.0357	1.0424	207200.0
2000-07-18 09:00:00	AAPL	Stock	1.0446	1.0513	1.0357	1.0458	44346400.0
2000-07-18 10:00:00	AAPL	Stock	1.0458	1.0469	1.0156	1.0223	62160000.0
2000-07-18 11:00:00	AAPL	Stock	1.0223	1.0413	1.0179	1.0313	22181600.0
2000-07-18 12:00:00	AAPL	Stock	1.0335	1.0402	1.0324	1.0357	23268000.0
2000-07-18 13:00:00	AAPL	Stock	1.0357	1.0357	1.0179	1.029	25642400.0
2000-07-18 14:00:00	AAPL	Stock	1.029	1.0335	1.0179	1.0268	35957600.0
2000-07-18 15:00:00	AAPL	Stock	1.0279	1.0491	1.019	1.0201	61684000.0
2000-07-18 16:00:00	AAPL	Stock	1.0234	1.1038	0.9464	0.9542	30340800.0
2000-07-18 17:00:00	AAPL	Stock	0.9542	0.9643	0.9464	0.9598	4188800.0
2000-07-18 18:00:00	AAPL	Stock	0.9598	0.9671	0.9598	0.9643	700000.0
2000-07-18 08:00:00	MSFT	Stock	39.1875	39.1875	38.9688	39.0	65600.0
2000-07-18 09:00:00	MSFT	Stock	39.0625	39.125	38.7188	39.0938	6299000.0
2000-07-18 10:00:00	MSFT	Stock	39.125	39.3438	38.875	38.9688	12576600.0
2000-07-18 11:00:00	MSFT	Stock	38.9375	39.0625	38.75	39.0	7407000.0
2000-07-18 12:00:00	MSFT	Stock	39.0	39.375	38.9688	39.25	6893400.0
2000-07-18 13:00:00	MSFT	Stock	39.2812	39.5938	39.2188	39.5312	8025400.0
2000-07-18 14:00:00	MSFT	Stock	39.5312	39.625	39.2188	39.5312	9288400.0
2000-07-18 15:00:00	MSFT	Stock	39.5312	39.5625	39.0	39.25	13094400.0
2000-07-18 16:00:00	MSFT	Stock	39.3125	40.125	38.8281	40.0	4973800.0
2000-07-18 17:00:00	MSFT	Stock	40.0625	40.1875	39.0938	40.0312	517000.0
2000-07-18 18:00:00	MSFT	Stock	40.0625	40.125	39.25	39.4375	309800.0
2000-07-18 08:00:00	NVDA	Stock	0.3042	0.3042	0.3042	0.3042	288000.0
2000-07-18 09:00:00	NVDA	Stock	0.2938	0.3	0.2854	0.2974	38784000.0
2000-07-18 10:00:00	NVDA	Stock	0.298	0.299	0.2911	0.2938	28104000.0
2000-07-18 11:00:00	NVDA	Stock	0.2932	0.2938	0.2901	0.2917	18720000.0
2000-07-18 12:00:00	NVDA	Stock	0.2911	0.293	0.2885	0.2917	13104000.0
2000-07-18 13:00:00	NVDA	Stock	0.2927	0.301	0.2927	0.2997	15048000.0
2000-07-18 14:00:00	NVDA	Stock	0.299	0.3125	0.2979	0.3104	42864000.0
2000-07-18 15:00:00	NVDA	Stock	0.3094	0.3109	0.2958	0.2974	18816000.0
2000-07-18 16:00:00	NVDA	Stock	0.2982	0.299	0.2945	0.299	2040000.0
2000-07-18 17:00:00	NVDA	Stock	0.2948	0.2948	0.2948	0.2948	168000.0
2000-07-18 18:00:00	NVDA	Stock	0.2958	0.2958	0.2958	0.2958	24000.0
2000-07-18 08:00:00	AMZN	Stock	2.0656	2.0688	2.0062	2.05	86000.0
2000-07-18 09:00:00	AMZN	Stock	2.0484	2.0594	1.975	2.0281	19466000.0
2000-07-18 10:00:00	AMZN	Stock	2.0281	2.1812	2.025	2.1562	50444000.0
2000-07-18 11:00:00	AMZN	Stock	2.1562	2.1562	2.0813	2.1188	24246000.0
2000-07-18 12:00:00	AMZN	Stock	2.1188	2.1531	2.1125	2.1219	17744000.0
2000-07-18 13:00:00	AMZN	Stock	2.1219	2.1406	2.1	2.1188	11756000.0
2000-07-18 14:00:00	AMZN	Stock	2.1234	2.1438	2.1062	2.1406	11288000.0
2000-07-18 15:00:00	AMZN	Stock	2.1375	2.1469	2.0844	2.0906	18336000.0
2000-07-18 16:00:00	AMZN	Stock	2.0906	2.1625	1.9984	2.0625	2846000.0
2000-07-18 17:00:00	AMZN	Stock	2.1	2.125	2.0766	2.125	22000.0
2000-07-18 18:00:00	AMZN	Stock	2.1234	2.125	2.1234	2.125	10000.0
2000-07-18 09:00:00	CL	Stock	27.75	27.75	27.4375	27.5625	354400.0
2000-07-18 10:00:00	CL	Stock	27.5938	27.6875	27.4062	27.4375	598400.0
2000-07-18 11:00:00	CL	Stock	27.4375	27.5	27.375	27.4375	163000.0
2000-07-18 12:00:00	CL	Stock	27.4688	27.6562	27.4375	27.5	425800.0
2000-07-18 13:00:00	CL	Stock	27.5312	27.5625	27.4375	27.4375	361000.0
2000-07-18 14:00:00	CL	Stock	27.5	27.5	27.3438	27.4062	243200.0

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

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