PREVIEW / stock_1hour / 2000-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-18.parquet
  size:    286 KB
  rows:    15,076
  symbols: 1,211

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-08-18 08:00:00	AAPL	Stock	0.918	0.9286	0.918	0.9286	235200.0
2000-08-18 09:00:00	AAPL	Stock	0.9219	0.9241	0.8906	0.9007	44004800.0
2000-08-18 10:00:00	AAPL	Stock	0.9018	0.9252	0.8917	0.9185	35728000.0
2000-08-18 11:00:00	AAPL	Stock	0.9185	0.9196	0.8929	0.8984	28453600.0
2000-08-18 12:00:00	AAPL	Stock	0.8984	0.904	0.8962	0.9029	10102400.0
2000-08-18 13:00:00	AAPL	Stock	0.9018	0.9096	0.8984	0.904	21145600.0
2000-08-18 14:00:00	AAPL	Stock	0.904	0.9063	0.8996	0.9018	7985600.0
2000-08-18 15:00:00	AAPL	Stock	0.9029	0.9118	0.8929	0.894	28851200.0
2000-08-18 16:00:00	AAPL	Stock	0.8929	0.8962	0.8929	0.8929	3852800.0
2000-08-18 17:00:00	AAPL	Stock	0.8973	0.8973	0.8973	0.8973	28000.0
2000-08-18 18:00:00	AAPL	Stock	0.8929	0.8929	0.8929	0.8929	5600.0
2000-08-18 08:00:00	MSFT	Stock	35.75	35.8125	35.6562	35.6875	25200.0
2000-08-18 09:00:00	MSFT	Stock	35.75	35.75	35.1875	35.25	10193800.0
2000-08-18 10:00:00	MSFT	Stock	35.25	35.625	35.2188	35.4062	6155000.0
2000-08-18 11:00:00	MSFT	Stock	35.4375	35.5	35.25	35.2812	8170800.0
2000-08-18 12:00:00	MSFT	Stock	35.2812	35.5938	35.2812	35.4375	4666000.0
2000-08-18 13:00:00	MSFT	Stock	35.4688	35.5	35.3125	35.4375	5688400.0
2000-08-18 14:00:00	MSFT	Stock	35.4375	35.5	35.2812	35.375	5214200.0
2000-08-18 15:00:00	MSFT	Stock	35.3438	35.5625	35.3438	35.5	6210000.0
2000-08-18 16:00:00	MSFT	Stock	35.4688	35.5938	35.4219	35.5	4255000.0
2000-08-18 17:00:00	MSFT	Stock	35.5312	35.5312	35.5	35.5	703600.0
2000-08-18 08:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	24000.0
2000-08-18 09:00:00	NVDA	Stock	0.3125	0.3195	0.3081	0.3135	39408000.0
2000-08-18 10:00:00	NVDA	Stock	0.3135	0.3245	0.3125	0.3208	53400000.0
2000-08-18 11:00:00	NVDA	Stock	0.3208	0.3224	0.3167	0.3193	24096000.0
2000-08-18 12:00:00	NVDA	Stock	0.3206	0.3234	0.3193	0.3229	11040000.0
2000-08-18 13:00:00	NVDA	Stock	0.3219	0.3229	0.3135	0.3146	16512000.0
2000-08-18 14:00:00	NVDA	Stock	0.3159	0.3177	0.3148	0.3177	10344000.0
2000-08-18 15:00:00	NVDA	Stock	0.3172	0.324	0.3172	0.3206	47928000.0
2000-08-18 16:00:00	NVDA	Stock	0.3208	0.3229	0.3208	0.3208	1200000.0
2000-08-18 17:00:00	NVDA	Stock	0.3206	0.3206	0.3206	0.3206	24000.0
2000-08-18 08:00:00	AMZN	Stock	1.9156	1.975	1.9156	1.9438	142000.0
2000-08-18 09:00:00	AMZN	Stock	1.9438	2.0031	1.9438	1.9812	36238000.0
2000-08-18 10:00:00	AMZN	Stock	1.9812	2.0	1.975	1.9938	24604000.0
2000-08-18 11:00:00	AMZN	Stock	1.9906	2.0	1.9531	1.975	15344000.0
2000-08-18 12:00:00	AMZN	Stock	1.9734	2.0062	1.9719	1.9938	21154000.0
2000-08-18 13:00:00	AMZN	Stock	1.9938	2.0	1.975	1.975	8730000.0
2000-08-18 14:00:00	AMZN	Stock	1.9781	1.9844	1.95	1.9562	9894000.0
2000-08-18 15:00:00	AMZN	Stock	1.9562	1.975	1.9469	1.95	25878000.0
2000-08-18 16:00:00	AMZN	Stock	1.95	1.9531	1.9375	1.9469	3206000.0
2000-08-18 17:00:00	AMZN	Stock	1.9469	1.9469	1.9438	1.9438	28000.0
2000-08-18 18:00:00	AMZN	Stock	1.9453	1.9469	1.9438	1.9469	66000.0
2000-08-18 09:00:00	CL	Stock	26.4375	26.4688	26.2188	26.2188	435800.0
2000-08-18 10:00:00	CL	Stock	26.2188	26.3438	26.1562	26.1875	337600.0
2000-08-18 11:00:00	CL	Stock	26.1875	26.1875	25.875	26.0938	494200.0
2000-08-18 12:00:00	CL	Stock	26.0938	26.1562	25.875	25.9375	243800.0
2000-08-18 13:00:00	CL	Stock	25.9375	25.9688	25.8438	25.9688	239000.0
2000-08-18 14:00:00	CL	Stock	26.0	26.2812	25.9688	26.25	240400.0
2000-08-18 15:00:00	CL	Stock	26.2812	26.3125	25.9375	26.1562	602000.0
2000-08-18 16:00:00	CL	Stock	26.1562	26.1875	26.1562	26.1875	935200.0

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

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