PREVIEW / stock_1hour / 2001-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-27.parquet
  size:    351 KB
  rows:    16,608
  symbols: 1,311

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
2001-07-27 08:00:00	AAPL	Stock	0.332	0.3323	0.3316	0.3316	263200.0
2001-07-27 09:00:00	AAPL	Stock	0.3321	0.3402	0.3304	0.3304	51004800.0
2001-07-27 10:00:00	AAPL	Stock	0.3307	0.3414	0.3305	0.3409	53099200.0
2001-07-27 11:00:00	AAPL	Stock	0.3409	0.3438	0.3382	0.3395	44822400.0
2001-07-27 12:00:00	AAPL	Stock	0.3395	0.3407	0.3368	0.3393	70050400.0
2001-07-27 13:00:00	AAPL	Stock	0.3393	0.343	0.3373	0.3375	32340000.0
2001-07-27 14:00:00	AAPL	Stock	0.3373	0.3393	0.3339	0.3382	20708800.0
2001-07-27 15:00:00	AAPL	Stock	0.3375	0.3416	0.3366	0.3375	39396000.0
2001-07-27 16:00:00	AAPL	Stock	0.3388	0.3434	0.3229	0.3434	8652000.0
2001-07-27 08:00:00	MSFT	Stock	33.42	33.42	32.875	33.0	1330200.0
2001-07-27 09:00:00	MSFT	Stock	33.0	33.32	32.745	32.87	9034200.0
2001-07-27 10:00:00	MSFT	Stock	32.87	32.895	32.525	32.65	15847800.0
2001-07-27 11:00:00	MSFT	Stock	32.665	32.9	32.605	32.665	8629000.0
2001-07-27 12:00:00	MSFT	Stock	32.655	32.865	32.625	32.795	4877200.0
2001-07-27 13:00:00	MSFT	Stock	32.79	32.975	32.7	32.73	6906400.0
2001-07-27 14:00:00	MSFT	Stock	32.735	32.825	32.625	32.7	4878200.0
2001-07-27 15:00:00	MSFT	Stock	32.7	32.865	32.67	32.735	9522400.0
2001-07-27 16:00:00	MSFT	Stock	32.735	32.975	32.655	32.805	1997200.0
2001-07-27 17:00:00	MSFT	Stock	32.75	32.775	32.75	32.77	3400.0
2001-07-27 18:00:00	MSFT	Stock	32.775	32.79	32.74	32.785	6800.0
2001-07-27 08:00:00	NVDA	Stock	0.3287	0.3321	0.325	0.3276	3696000.0
2001-07-27 09:00:00	NVDA	Stock	0.3276	0.3315	0.3188	0.3235	166176000.0
2001-07-27 10:00:00	NVDA	Stock	0.3236	0.3364	0.3233	0.329	321504000.0
2001-07-27 11:00:00	NVDA	Stock	0.329	0.3344	0.3285	0.3325	182040000.0
2001-07-27 12:00:00	NVDA	Stock	0.3324	0.3348	0.3323	0.3335	69744000.0
2001-07-27 13:00:00	NVDA	Stock	0.3337	0.3375	0.3333	0.3358	79320000.0
2001-07-27 14:00:00	NVDA	Stock	0.3358	0.3404	0.333	0.3398	114432000.0
2001-07-27 15:00:00	NVDA	Stock	0.3399	0.3411	0.3354	0.3379	98112000.0
2001-07-27 16:00:00	NVDA	Stock	0.3375	0.338	0.3334	0.3334	9432000.0
2001-07-27 17:00:00	NVDA	Stock	0.3375	0.3375	0.3375	0.3375	48000.0
2001-07-27 08:00:00	AMZN	Stock	0.617	0.617	0.615	0.615	112000.0
2001-07-27 09:00:00	AMZN	Stock	0.615	0.624	0.585	0.5925	24476000.0
2001-07-27 10:00:00	AMZN	Stock	0.5925	0.611	0.59	0.5995	27942000.0
2001-07-27 11:00:00	AMZN	Stock	0.6	0.605	0.587	0.5905	19430000.0
2001-07-27 12:00:00	AMZN	Stock	0.592	0.5975	0.59	0.5925	12636000.0
2001-07-27 13:00:00	AMZN	Stock	0.5925	0.599	0.592	0.595	15474000.0
2001-07-27 14:00:00	AMZN	Stock	0.595	0.5985	0.5895	0.5955	15742000.0
2001-07-27 15:00:00	AMZN	Stock	0.5955	0.6145	0.595	0.6125	30730000.0
2001-07-27 16:00:00	AMZN	Stock	0.6125	0.6125	0.5965	0.5965	26814000.0
2001-07-27 17:00:00	AMZN	Stock	0.605	0.605	0.605	0.605	30000.0
2001-07-27 09:00:00	CL	Stock	27.1	27.1	26.75	26.875	581800.0
2001-07-27 10:00:00	CL	Stock	26.875	26.9	26.755	26.86	498600.0
2001-07-27 11:00:00	CL	Stock	26.89	27.02	26.855	26.955	342000.0
2001-07-27 12:00:00	CL	Stock	26.905	27.0	26.875	26.975	315800.0
2001-07-27 13:00:00	CL	Stock	26.98	27.045	26.95	26.96	166600.0
2001-07-27 14:00:00	CL	Stock	26.965	27.025	26.915	26.95	398600.0
2001-07-27 15:00:00	CL	Stock	26.955	27.04	26.935	27.0	867800.0
2001-07-27 16:00:00	CL	Stock	26.995	26.995	26.995	26.995	45800.0

> showing 48 of 16,608 rows — these rows as CSV

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