PREVIEW / stock_1hour / 2006-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-09.parquet
  size:    618 KB
  rows:    29,498
  symbols: 2,316

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-08-09 07:00:00	AAPL	Stock	2.3214	2.3214	2.3214	2.3214	16800.0
2006-08-09 08:00:00	AAPL	Stock	2.3232	2.3429	2.3214	2.3339	1929816.0
2006-08-09 09:00:00	AAPL	Stock	2.3339	2.3432	2.2861	2.3079	156225104.0
2006-08-09 10:00:00	AAPL	Stock	2.3079	2.3104	2.2764	2.2918	198743832.0
2006-08-09 11:00:00	AAPL	Stock	2.2914	2.3361	2.2904	2.3307	178977260.0
2006-08-09 12:00:00	AAPL	Stock	2.3304	2.3306	2.3086	2.3143	78537256.0
2006-08-09 13:00:00	AAPL	Stock	2.314	2.3271	2.3	2.3018	80754184.0
2006-08-09 14:00:00	AAPL	Stock	2.3011	2.3082	2.2818	2.2879	89586168.0
2006-08-09 15:00:00	AAPL	Stock	2.2875	2.2893	2.2643	2.2707	158823252.0
2006-08-09 16:00:00	AAPL	Stock	2.2711	2.2732	2.2679	2.2711	5926200.0
2006-08-09 17:00:00	AAPL	Stock	2.2718	2.2729	2.2686	2.2696	297780.0
2006-08-09 18:00:00	AAPL	Stock	2.2686	2.2696	2.2686	2.2689	195664.0
2006-08-09 08:00:00	MSFT	Stock	24.48	24.49	24.46	24.46	36208.0
2006-08-09 09:00:00	MSFT	Stock	24.49	24.5	24.41	24.48	4486941.0
2006-08-09 10:00:00	MSFT	Stock	24.47	24.58	24.44	24.55	8048649.0
2006-08-09 11:00:00	MSFT	Stock	24.55	24.62	24.55	24.58	7211321.0
2006-08-09 12:00:00	MSFT	Stock	24.58	24.6	24.51	24.54	3727715.0
2006-08-09 13:00:00	MSFT	Stock	24.543	24.6	24.5	24.57	3931197.0
2006-08-09 14:00:00	MSFT	Stock	24.56	24.64	24.46	24.47	5615943.0
2006-08-09 15:00:00	MSFT	Stock	24.47	24.51	24.34	24.43	9753453.0
2006-08-09 16:00:00	MSFT	Stock	24.44	24.54	24.35	24.44	344152.0
2006-08-09 17:00:00	MSFT	Stock	24.44	24.48	24.418	24.44	10134.0
2006-08-09 18:00:00	MSFT	Stock	24.45	24.45	24.45	24.45	1750.0
2006-08-09 08:00:00	NVDA	Stock	0.4183	0.4183	0.4125	0.4167	1278000.0
2006-08-09 09:00:00	NVDA	Stock	0.4167	0.425	0.4107	0.4163	131899560.0
2006-08-09 10:00:00	NVDA	Stock	0.416	0.4163	0.4043	0.4108	121604040.0
2006-08-09 11:00:00	NVDA	Stock	0.4108	0.416	0.4098	0.4103	77919540.0
2006-08-09 12:00:00	NVDA	Stock	0.4105	0.4127	0.4083	0.4107	37403760.0
2006-08-09 13:00:00	NVDA	Stock	0.4105	0.4117	0.4075	0.4098	40459980.0
2006-08-09 14:00:00	NVDA	Stock	0.4098	0.4132	0.4093	0.4093	66128100.0
2006-08-09 15:00:00	NVDA	Stock	0.4093	0.4098	0.4025	0.4057	90087840.0
2006-08-09 16:00:00	NVDA	Stock	0.4052	0.4083	0.404	0.4055	4328640.0
2006-08-09 17:00:00	NVDA	Stock	0.4083	0.4083	0.4083	0.4083	42000.0
2006-08-09 08:00:00	AMZN	Stock	1.3295	1.3295	1.321	1.325	78320.0
2006-08-09 09:00:00	AMZN	Stock	1.325	1.335	1.311	1.3195	15346840.0
2006-08-09 10:00:00	AMZN	Stock	1.3195	1.326	1.3	1.307	28391280.0
2006-08-09 11:00:00	AMZN	Stock	1.3075	1.332	1.306	1.329	16350480.0
2006-08-09 12:00:00	AMZN	Stock	1.3295	1.33	1.316	1.316	6391960.0
2006-08-09 13:00:00	AMZN	Stock	1.3165	1.3175	1.308	1.3135	11499500.0
2006-08-09 14:00:00	AMZN	Stock	1.313	1.33	1.313	1.3235	27291140.0
2006-08-09 15:00:00	AMZN	Stock	1.3235	1.33	1.3075	1.311	30628600.0
2006-08-09 16:00:00	AMZN	Stock	1.311	1.3125	1.3105	1.3125	244060.0
2006-08-09 09:00:00	CL	Stock	29.525	29.655	29.5	29.63	274200.0
2006-08-09 10:00:00	CL	Stock	29.63	29.825	29.62	29.715	535200.0
2006-08-09 11:00:00	CL	Stock	29.715	29.75	29.6	29.62	313200.0
2006-08-09 12:00:00	CL	Stock	29.625	29.735	29.6	29.655	323200.0
2006-08-09 13:00:00	CL	Stock	29.655	29.695	29.555	29.57	296400.0
2006-08-09 14:00:00	CL	Stock	29.56	29.64	29.5	29.51	446200.0
2006-08-09 15:00:00	CL	Stock	29.515	29.6	29.43	29.5	716200.0
2006-08-09 16:00:00	CL	Stock	29.495	29.495	29.495	29.495	182000.0

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

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