PREVIEW / stock_1hour / 2006-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-12.parquet
  size:    622 KB
  rows:    29,814
  symbols: 2,389

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-10-12 07:00:00	AAPL	Stock	2.6204	2.6204	2.6204	2.6204	33600.0
2006-10-12 08:00:00	AAPL	Stock	2.6196	2.6354	2.6164	2.635	1182720.0
2006-10-12 09:00:00	AAPL	Stock	2.6339	2.67	2.6279	2.6661	105454328.0
2006-10-12 10:00:00	AAPL	Stock	2.6668	2.6807	2.6554	2.6582	138452356.0
2006-10-12 11:00:00	AAPL	Stock	2.6582	2.6679	2.6536	2.6621	55779640.0
2006-10-12 12:00:00	AAPL	Stock	2.6621	2.6707	2.6604	2.6647	36355732.0
2006-10-12 13:00:00	AAPL	Stock	2.665	2.6671	2.6571	2.6589	28010332.0
2006-10-12 14:00:00	AAPL	Stock	2.6593	2.6857	2.6586	2.6821	81740876.0
2006-10-12 15:00:00	AAPL	Stock	2.6823	2.6925	2.6768	2.6807	132355020.0
2006-10-12 16:00:00	AAPL	Stock	2.6807	2.6914	2.6804	2.6893	1689884.0
2006-10-12 17:00:00	AAPL	Stock	2.6893	2.6911	2.6893	2.6911	160580.0
2006-10-12 18:00:00	AAPL	Stock	2.6904	2.6946	2.69	2.6946	272244.0
2006-10-12 19:00:00	AAPL	Stock	2.6946	2.6946	2.6921	2.6921	39704.0
2006-10-12 07:00:00	MSFT	Stock	27.49	27.54	27.49	27.54	550.0
2006-10-12 08:00:00	MSFT	Stock	27.51	27.55	27.51	27.52	6250.0
2006-10-12 09:00:00	MSFT	Stock	27.55	27.89	27.53	27.86	8774722.0
2006-10-12 10:00:00	MSFT	Stock	27.86	28.05	27.85	28.003	18505585.0
2006-10-12 11:00:00	MSFT	Stock	28.01	28.08	28.0	28.07	15529037.0
2006-10-12 12:00:00	MSFT	Stock	28.07	28.13	28.03	28.05	15648442.0
2006-10-12 13:00:00	MSFT	Stock	28.05	28.09	28.01	28.06	6969477.0
2006-10-12 14:00:00	MSFT	Stock	28.07	28.13	28.04	28.05	15364343.0
2006-10-12 15:00:00	MSFT	Stock	28.05	28.29	28.04	28.28	36293626.0
2006-10-12 16:00:00	MSFT	Stock	28.27	28.29	28.133	28.27	579088.0
2006-10-12 17:00:00	MSFT	Stock	28.27	28.29	28.27	28.29	28259.0
2006-10-12 18:00:00	MSFT	Stock	28.29	28.34	28.29	28.34	19935.0
2006-10-12 19:00:00	MSFT	Stock	28.35	28.35	28.3	28.3	330.0
2006-10-12 08:00:00	NVDA	Stock	0.536	0.5417	0.536	0.5417	282000.0
2006-10-12 09:00:00	NVDA	Stock	0.5442	0.5525	0.5387	0.5407	67132380.0
2006-10-12 10:00:00	NVDA	Stock	0.5407	0.546	0.5388	0.542	66802200.0
2006-10-12 11:00:00	NVDA	Stock	0.5418	0.5445	0.54	0.5403	45817200.0
2006-10-12 12:00:00	NVDA	Stock	0.5403	0.5412	0.5335	0.5355	64052280.0
2006-10-12 13:00:00	NVDA	Stock	0.5353	0.5412	0.5342	0.541	38487300.0
2006-10-12 14:00:00	NVDA	Stock	0.5408	0.5437	0.5383	0.54	37736280.0
2006-10-12 15:00:00	NVDA	Stock	0.54	0.5438	0.5392	0.5413	86269080.0
2006-10-12 16:00:00	NVDA	Stock	0.5415	0.543	0.5415	0.5415	687240.0
2006-10-12 18:00:00	NVDA	Stock	0.5417	0.5417	0.5405	0.5405	321180.0
2006-10-12 19:00:00	NVDA	Stock	0.5412	0.5412	0.5412	0.5412	24000.0
2006-10-12 09:00:00	AMZN	Stock	1.6545	1.66	1.6315	1.655	12651860.0
2006-10-12 10:00:00	AMZN	Stock	1.655	1.6715	1.6515	1.665	15689120.0
2006-10-12 11:00:00	AMZN	Stock	1.665	1.675	1.6625	1.668	10633540.0
2006-10-12 12:00:00	AMZN	Stock	1.6675	1.6745	1.6605	1.673	17727920.0
2006-10-12 13:00:00	AMZN	Stock	1.6735	1.679	1.673	1.675	9960240.0
2006-10-12 14:00:00	AMZN	Stock	1.675	1.6775	1.67	1.673	13006360.0
2006-10-12 15:00:00	AMZN	Stock	1.673	1.6855	1.673	1.6775	33185040.0
2006-10-12 16:00:00	AMZN	Stock	1.6775	1.681	1.677	1.6775	488160.0
2006-10-12 17:00:00	AMZN	Stock	1.6805	1.6805	1.6695	1.675	167560.0
2006-10-12 18:00:00	AMZN	Stock	1.6775	1.6775	1.675	1.675	21040.0
2006-10-12 19:00:00	AMZN	Stock	1.675	1.6835	1.675	1.6835	20000.0
2006-10-12 09:00:00	CL	Stock	31.1	31.1	30.89	30.895	202600.0
2006-10-12 10:00:00	CL	Stock	30.895	30.91	30.75	30.775	563400.0

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

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