PREVIEW / stock_1hour / 2000-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-27.parquet
  size:    303 KB
  rows:    15,544
  symbols: 1,189

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-27 08:00:00	AAPL	Stock	0.966	0.966	0.9643	0.9643	716800.0
2000-06-27 09:00:00	AAPL	Stock	0.9643	0.9911	0.952	0.9861	46821600.0
2000-06-27 10:00:00	AAPL	Stock	0.9861	0.9877	0.9442	0.9531	32916800.0
2000-06-27 11:00:00	AAPL	Stock	0.9542	0.9554	0.9297	0.9431	25530400.0
2000-06-27 12:00:00	AAPL	Stock	0.9431	0.9509	0.9375	0.9386	19124000.0
2000-06-27 13:00:00	AAPL	Stock	0.9397	0.9554	0.9375	0.942	14526400.0
2000-06-27 14:00:00	AAPL	Stock	0.9431	0.9464	0.9286	0.9386	17858400.0
2000-06-27 15:00:00	AAPL	Stock	0.9364	0.9408	0.9219	0.9252	34966400.0
2000-06-27 16:00:00	AAPL	Stock	0.9241	0.933	0.9196	0.9241	7274400.0
2000-06-27 17:00:00	AAPL	Stock	0.9241	0.9263	0.9241	0.9263	28000.0
2000-06-27 18:00:00	AAPL	Stock	0.9263	0.9263	0.9263	0.9263	11200.0
2000-06-27 08:00:00	MSFT	Stock	39.7344	40.1094	39.7344	39.8125	251800.0
2000-06-27 09:00:00	MSFT	Stock	39.75	40.0625	39.5	39.8125	5005800.0
2000-06-27 10:00:00	MSFT	Stock	39.8125	39.8438	39.4375	39.5625	5516400.0
2000-06-27 11:00:00	MSFT	Stock	39.5625	39.5938	39.1875	39.5	3479200.0
2000-06-27 12:00:00	MSFT	Stock	39.5312	39.6562	39.4375	39.4688	1938600.0
2000-06-27 13:00:00	MSFT	Stock	39.5	39.6875	39.3438	39.6719	2577200.0
2000-06-27 14:00:00	MSFT	Stock	39.6875	39.7969	39.4375	39.5312	3607000.0
2000-06-27 15:00:00	MSFT	Stock	39.5312	39.8125	39.3125	39.375	5433400.0
2000-06-27 16:00:00	MSFT	Stock	39.375	39.5781	39.25	39.5781	2575000.0
2000-06-27 17:00:00	MSFT	Stock	39.4062	39.5781	39.3438	39.5781	113800.0
2000-06-27 18:00:00	MSFT	Stock	39.5	39.5781	39.3438	39.5312	97800.0
2000-06-27 08:00:00	NVDA	Stock	0.3488	0.3568	0.3438	0.3458	408000.0
2000-06-27 09:00:00	NVDA	Stock	0.3458	0.3484	0.3271	0.338	76800000.0
2000-06-27 10:00:00	NVDA	Stock	0.338	0.3383	0.3188	0.3206	66744000.0
2000-06-27 11:00:00	NVDA	Stock	0.3208	0.325	0.3182	0.3237	39816000.0
2000-06-27 12:00:00	NVDA	Stock	0.3234	0.324	0.3208	0.3211	19176000.0
2000-06-27 13:00:00	NVDA	Stock	0.3211	0.324	0.3128	0.3185	36744000.0
2000-06-27 14:00:00	NVDA	Stock	0.3221	0.3221	0.2878	0.3083	209376000.0
2000-06-27 15:00:00	NVDA	Stock	0.3068	0.3125	0.2958	0.2966	110232000.0
2000-06-27 16:00:00	NVDA	Stock	0.2969	0.3021	0.2938	0.2969	19368000.0
2000-06-27 17:00:00	NVDA	Stock	0.3021	0.3042	0.3017	0.3021	384000.0
2000-06-27 18:00:00	NVDA	Stock	0.3021	0.3042	0.3021	0.3042	144000.0
2000-06-27 08:00:00	AMZN	Stock	1.6812	1.6891	1.6625	1.6625	306000.0
2000-06-27 09:00:00	AMZN	Stock	1.6781	1.7438	1.675	1.7312	46556000.0
2000-06-27 10:00:00	AMZN	Stock	1.7312	1.7719	1.7188	1.7625	63576000.0
2000-06-27 11:00:00	AMZN	Stock	1.7594	1.7625	1.675	1.7156	25688000.0
2000-06-27 12:00:00	AMZN	Stock	1.7156	1.7438	1.7	1.7094	21852000.0
2000-06-27 13:00:00	AMZN	Stock	1.7062	1.75	1.7031	1.7375	25172000.0
2000-06-27 14:00:00	AMZN	Stock	1.7406	1.7625	1.7281	1.7562	25412000.0
2000-06-27 15:00:00	AMZN	Stock	1.7562	1.925	1.7562	1.8281	138034000.0
2000-06-27 16:00:00	AMZN	Stock	1.825	1.8625	1.825	1.8375	4040000.0
2000-06-27 17:00:00	AMZN	Stock	1.8375	1.85	1.825	1.8375	138000.0
2000-06-27 18:00:00	AMZN	Stock	1.8375	1.8438	1.8312	1.8438	72000.0
2000-06-27 09:00:00	CL	Stock	28.25	28.2812	28.125	28.25	202800.0
2000-06-27 10:00:00	CL	Stock	28.2812	28.6875	28.25	28.5625	501000.0
2000-06-27 11:00:00	CL	Stock	28.5625	28.5938	28.375	28.4062	691600.0
2000-06-27 12:00:00	CL	Stock	28.4062	28.4688	28.375	28.4375	393000.0
2000-06-27 13:00:00	CL	Stock	28.4688	28.625	28.4375	28.625	216600.0
2000-06-27 14:00:00	CL	Stock	28.5938	28.625	28.5312	28.5938	510000.0

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

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