PREVIEW / stock_1hour / 2006-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-30.parquet
  size:    618 KB
  rows:    29,613
  symbols: 2,263

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
2006-05-30 07:00:00	AAPL	Stock	2.2614	2.2614	2.2614	2.2614	14000.0
2006-05-30 08:00:00	AAPL	Stock	2.2671	2.2671	2.25	2.2554	459284.0
2006-05-30 09:00:00	AAPL	Stock	2.2575	2.2614	2.2354	2.2368	66199980.0
2006-05-30 10:00:00	AAPL	Stock	2.2371	2.2407	2.2257	2.2275	82957364.0
2006-05-30 11:00:00	AAPL	Stock	2.2275	2.255	2.2096	2.2179	94891748.0
2006-05-30 12:00:00	AAPL	Stock	2.2179	2.2343	2.2071	2.2089	51926112.0
2006-05-30 13:00:00	AAPL	Stock	2.2089	2.21	2.2	2.2032	85219624.0
2006-05-30 14:00:00	AAPL	Stock	2.2032	2.2143	2.2021	2.2096	51199008.0
2006-05-30 15:00:00	AAPL	Stock	2.2096	2.2096	2.1868	2.1868	116825856.0
2006-05-30 16:00:00	AAPL	Stock	2.1864	2.1929	2.1857	2.1875	4288564.0
2006-05-30 17:00:00	AAPL	Stock	2.1875	2.1882	2.1839	2.1857	565264.0
2006-05-30 18:00:00	AAPL	Stock	2.1857	2.1879	2.185	2.185	398608.0
2006-05-30 08:00:00	MSFT	Stock	23.69	23.72	23.56	23.56	17064.0
2006-05-30 09:00:00	MSFT	Stock	23.58	23.76	23.44	23.53	6337853.0
2006-05-30 10:00:00	MSFT	Stock	23.54	23.57	23.43	23.44	6970955.0
2006-05-30 11:00:00	MSFT	Stock	23.44	23.555	23.33	23.42	7238245.0
2006-05-30 12:00:00	MSFT	Stock	23.42	23.43	23.35	23.36	3402537.0
2006-05-30 13:00:00	MSFT	Stock	23.36	23.39	23.28	23.31	5624883.0
2006-05-30 14:00:00	MSFT	Stock	23.31	23.36	23.3	23.31	6055273.0
2006-05-30 15:00:00	MSFT	Stock	23.31	23.43	23.14	23.15	13802392.0
2006-05-30 16:00:00	MSFT	Stock	23.14	23.31	23.14	23.19	480799.0
2006-05-30 17:00:00	MSFT	Stock	23.19	23.2	23.15	23.18	642140.0
2006-05-30 18:00:00	MSFT	Stock	23.19	23.2	23.15	23.2	10929.0
2006-05-30 08:00:00	NVDA	Stock	0.395	0.397	0.395	0.397	108000.0
2006-05-30 09:00:00	NVDA	Stock	0.3968	0.4005	0.391	0.3913	45053460.0
2006-05-30 10:00:00	NVDA	Stock	0.3915	0.3935	0.3892	0.3922	58945080.0
2006-05-30 11:00:00	NVDA	Stock	0.3923	0.3923	0.3903	0.391	64158180.0
2006-05-30 12:00:00	NVDA	Stock	0.391	0.3917	0.3882	0.389	45396300.0
2006-05-30 13:00:00	NVDA	Stock	0.389	0.3903	0.3878	0.388	53791620.0
2006-05-30 14:00:00	NVDA	Stock	0.3882	0.3897	0.3873	0.3875	49046460.0
2006-05-30 15:00:00	NVDA	Stock	0.3875	0.3895	0.3827	0.3827	105590760.0
2006-05-30 16:00:00	NVDA	Stock	0.3827	0.3833	0.3818	0.3818	523380.0
2006-05-30 17:00:00	NVDA	Stock	0.3828	0.3838	0.3828	0.3838	680400.0
2006-05-30 18:00:00	NVDA	Stock	0.3828	0.3828	0.3828	0.3828	33660.0
2006-05-30 08:00:00	AMZN	Stock	1.794	1.794	1.789	1.789	4000.0
2006-05-30 09:00:00	AMZN	Stock	1.7895	1.797	1.7555	1.7615	13932320.0
2006-05-30 10:00:00	AMZN	Stock	1.761	1.766	1.7515	1.762	13571100.0
2006-05-30 11:00:00	AMZN	Stock	1.7615	1.7845	1.7365	1.75	17529260.0
2006-05-30 12:00:00	AMZN	Stock	1.75	1.75	1.7395	1.7455	8061440.0
2006-05-30 13:00:00	AMZN	Stock	1.7455	1.746	1.731	1.7365	11300060.0
2006-05-30 14:00:00	AMZN	Stock	1.7365	1.7365	1.722	1.7295	16366520.0
2006-05-30 15:00:00	AMZN	Stock	1.7295	1.735	1.724	1.732	28814460.0
2006-05-30 16:00:00	AMZN	Stock	1.7315	1.7625	1.7275	1.735	325840.0
2006-05-30 17:00:00	AMZN	Stock	1.732	1.732	1.732	1.732	78000.0
2006-05-30 18:00:00	AMZN	Stock	1.732	1.732	1.732	1.732	9220.0
2006-05-30 09:00:00	CL	Stock	30.1	30.22	30.015	30.22	354600.0
2006-05-30 10:00:00	CL	Stock	30.215	30.23	30.13	30.2	381600.0
2006-05-30 11:00:00	CL	Stock	30.2	30.37	30.17	30.365	374600.0
2006-05-30 12:00:00	CL	Stock	30.365	30.38	30.255	30.255	310800.0
2006-05-30 13:00:00	CL	Stock	30.26	30.39	30.205	30.35	582000.0

> showing 50 of 29,613 rows — these rows as CSV

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