PREVIEW / stock_1hour / 2006-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-12.parquet
  size:    620 KB
  rows:    29,559
  symbols: 2,292

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-06-12 07:00:00	AAPL	Stock	2.115	2.1179	2.115	2.1179	47600.0
2006-06-12 08:00:00	AAPL	Stock	2.1214	2.1268	2.1179	2.1221	866320.0
2006-06-12 09:00:00	AAPL	Stock	2.1221	2.1332	2.0936	2.1169	99324176.0
2006-06-12 10:00:00	AAPL	Stock	2.1164	2.1168	2.0832	2.0937	117323220.0
2006-06-12 11:00:00	AAPL	Stock	2.0936	2.0996	2.0789	2.0979	84707840.0
2006-06-12 12:00:00	AAPL	Stock	2.0982	2.0993	2.0818	2.0864	44069760.0
2006-06-12 13:00:00	AAPL	Stock	2.0864	2.0964	2.0761	2.0814	46230436.0
2006-06-12 14:00:00	AAPL	Stock	2.0814	2.0836	2.0454	2.0511	144280360.0
2006-06-12 15:00:00	AAPL	Stock	2.0511	2.0564	2.0343	2.0346	169333780.0
2006-06-12 16:00:00	AAPL	Stock	2.0357	2.0479	2.0325	2.0375	4539780.0
2006-06-12 17:00:00	AAPL	Stock	2.0361	2.0393	2.0343	2.0357	424788.0
2006-06-12 18:00:00	AAPL	Stock	2.0368	2.0379	2.0357	2.0379	190288.0
2006-06-12 07:00:00	MSFT	Stock	21.95	21.95	21.95	21.95	300.0
2006-06-12 08:00:00	MSFT	Stock	21.99	21.99	21.96	21.99	37659.0
2006-06-12 09:00:00	MSFT	Stock	21.98	22.0	21.8	21.95	6299001.0
2006-06-12 10:00:00	MSFT	Stock	21.948	22.1	21.9	21.99	8869031.0
2006-06-12 11:00:00	MSFT	Stock	21.99	22.05	21.88	22.038	9428095.0
2006-06-12 12:00:00	MSFT	Stock	22.04	22.04	21.86	21.96	18827896.0
2006-06-12 13:00:00	MSFT	Stock	21.97	22.03	21.94	22.0	5112193.0
2006-06-12 14:00:00	MSFT	Stock	22.01	22.02	21.86	21.93	7123230.0
2006-06-12 15:00:00	MSFT	Stock	21.939	21.98	21.7	21.71	16043602.0
2006-06-12 16:00:00	MSFT	Stock	21.73	21.87	21.621	21.71	1395853.0
2006-06-12 17:00:00	MSFT	Stock	21.71	21.73	21.71	21.73	19818.0
2006-06-12 18:00:00	MSFT	Stock	21.73	21.74	21.7	21.72	25026.0
2006-06-12 07:00:00	NVDA	Stock	0.355	0.355	0.3517	0.3517	114000.0
2006-06-12 08:00:00	NVDA	Stock	0.3515	0.3515	0.3443	0.3465	899700.0
2006-06-12 09:00:00	NVDA	Stock	0.3457	0.3543	0.3438	0.352	64638000.0
2006-06-12 10:00:00	NVDA	Stock	0.3518	0.3527	0.3465	0.348	57911580.0
2006-06-12 11:00:00	NVDA	Stock	0.3482	0.3487	0.3443	0.3483	50109960.0
2006-06-12 12:00:00	NVDA	Stock	0.3482	0.3487	0.3445	0.3452	30081540.0
2006-06-12 13:00:00	NVDA	Stock	0.345	0.346	0.3425	0.3432	38551020.0
2006-06-12 14:00:00	NVDA	Stock	0.3433	0.3433	0.3377	0.3385	73137420.0
2006-06-12 15:00:00	NVDA	Stock	0.3385	0.3399	0.3342	0.3358	129061260.0
2006-06-12 16:00:00	NVDA	Stock	0.3363	0.3383	0.3358	0.3383	346740.0
2006-06-12 17:00:00	NVDA	Stock	0.3372	0.3375	0.3365	0.337	82800.0
2006-06-12 18:00:00	NVDA	Stock	0.3367	0.3382	0.3362	0.3382	205800.0
2006-06-12 09:00:00	AMZN	Stock	1.6885	1.7225	1.6885	1.711	12319920.0
2006-06-12 10:00:00	AMZN	Stock	1.7105	1.713	1.6985	1.703	12314800.0
2006-06-12 11:00:00	AMZN	Stock	1.7025	1.7055	1.6875	1.7035	11391560.0
2006-06-12 12:00:00	AMZN	Stock	1.703	1.704	1.689	1.691	6722800.0
2006-06-12 13:00:00	AMZN	Stock	1.6906	1.695	1.683	1.6865	6089000.0
2006-06-12 14:00:00	AMZN	Stock	1.687	1.693	1.678	1.6835	9100560.0
2006-06-12 15:00:00	AMZN	Stock	1.6835	1.686	1.6745	1.6795	22685400.0
2006-06-12 16:00:00	AMZN	Stock	1.6805	1.6805	1.676	1.68	760540.0
2006-06-12 18:00:00	AMZN	Stock	1.6803	1.6803	1.6803	1.6803	16140.0
2006-06-12 09:00:00	CL	Stock	30.8	31.0	30.75	30.995	759000.0
2006-06-12 10:00:00	CL	Stock	30.975	31.16	30.95	31.075	1327200.0
2006-06-12 11:00:00	CL	Stock	31.075	31.075	30.9	31.035	1156000.0
2006-06-12 12:00:00	CL	Stock	31.035	31.04	30.775	30.82	689400.0
2006-06-12 13:00:00	CL	Stock	30.82	30.93	30.77	30.905	394800.0

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

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