PREVIEW / stock_1hour / 2008-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-17.parquet
  size:    830 KB
  rows:    41,560
  symbols: 3,283

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
2008-01-17 05:00:00	AAPL	Stock	5.75	5.7718	5.75	5.7718	34524.0
2008-01-17 06:00:00	AAPL	Stock	5.775	5.775	5.75	5.7589	265720.0
2008-01-17 07:00:00	AAPL	Stock	5.7589	5.7589	5.7118	5.7389	1980860.0
2008-01-17 08:00:00	AAPL	Stock	5.7389	5.8068	5.6986	5.7939	15433544.0
2008-01-17 09:00:00	AAPL	Stock	5.7925	5.9918	5.74	5.8318	202654396.0
2008-01-17 10:00:00	AAPL	Stock	5.8318	5.9918	5.6579	5.7407	387735628.0
2008-01-17 11:00:00	AAPL	Stock	5.7396	5.8167	5.7075	5.7239	189863940.0
2008-01-17 12:00:00	AAPL	Stock	5.7239	5.8104	5.6611	5.7712	197049356.0
2008-01-17 13:00:00	AAPL	Stock	5.7714	5.8311	5.6875	5.7711	221761988.0
2008-01-17 14:00:00	AAPL	Stock	5.7711	5.7875	5.7082	5.7321	213603432.0
2008-01-17 15:00:00	AAPL	Stock	5.7321	5.7707	5.6743	5.73	296759288.0
2008-01-17 16:00:00	AAPL	Stock	5.7125	5.7964	5.7029	5.7925	26531708.0
2008-01-17 17:00:00	AAPL	Stock	5.7911	5.8143	5.7029	5.795	4147248.0
2008-01-17 18:00:00	AAPL	Stock	5.7943	5.8043	5.7857	5.7946	1274140.0
2008-01-17 19:00:00	AAPL	Stock	5.7964	5.8125	5.7946	5.8125	768908.0
2008-01-17 06:00:00	MSFT	Stock	33.51	33.51	33.51	33.51	2500.0
2008-01-17 07:00:00	MSFT	Stock	33.51	33.77	33.37	33.5	150300.0
2008-01-17 08:00:00	MSFT	Stock	33.51	33.8	33.35	33.78	234970.0
2008-01-17 09:00:00	MSFT	Stock	33.75	33.8	33.46	33.73	9654928.0
2008-01-17 10:00:00	MSFT	Stock	33.73	33.76	33.06	33.34	20364838.0
2008-01-17 11:00:00	MSFT	Stock	33.35	33.5	33.17	33.21	8308009.0
2008-01-17 12:00:00	MSFT	Stock	33.21	33.54	33.05	33.4	9862366.0
2008-01-17 13:00:00	MSFT	Stock	33.4	33.5	33.25	33.34	9174078.0
2008-01-17 14:00:00	MSFT	Stock	33.34	33.38	33.11	33.3	11457945.0
2008-01-17 15:00:00	MSFT	Stock	33.3	33.42	32.97	33.03	19770278.0
2008-01-17 16:00:00	MSFT	Stock	33.02	33.4	32.99	33.11	5731049.0
2008-01-17 17:00:00	MSFT	Stock	33.34	33.42	33.01	33.39	684085.0
2008-01-17 18:00:00	MSFT	Stock	33.34	33.39	33.34	33.35	710.0
2008-01-17 19:00:00	MSFT	Stock	33.39	33.39	33.34	33.34	5300.0
2008-01-17 08:00:00	NVDA	Stock	0.5938	0.6063	0.5928	0.6063	184000.0
2008-01-17 09:00:00	NVDA	Stock	0.6038	0.618	0.5963	0.615	129340320.0
2008-01-17 10:00:00	NVDA	Stock	0.615	0.615	0.5952	0.5995	254031000.0
2008-01-17 11:00:00	NVDA	Stock	0.5998	0.6063	0.593	0.593	119401840.0
2008-01-17 12:00:00	NVDA	Stock	0.593	0.6038	0.586	0.6	126109720.0
2008-01-17 13:00:00	NVDA	Stock	0.5999	0.605	0.5945	0.6005	102252880.0
2008-01-17 14:00:00	NVDA	Stock	0.6009	0.6033	0.5875	0.5928	115587520.0
2008-01-17 15:00:00	NVDA	Stock	0.593	0.5935	0.581	0.5825	194379880.0
2008-01-17 16:00:00	NVDA	Stock	0.5825	0.605	0.5825	0.59	88014080.0
2008-01-17 17:00:00	NVDA	Stock	0.5918	0.5938	0.5825	0.5938	3763080.0
2008-01-17 18:00:00	NVDA	Stock	0.5923	0.5968	0.5923	0.5968	83080.0
2008-01-17 19:00:00	NVDA	Stock	0.595	0.595	0.595	0.595	12000.0
2008-01-17 07:00:00	AMZN	Stock	3.9375	4.012	3.9375	4.012	24000.0
2008-01-17 08:00:00	AMZN	Stock	4.01	4.05	3.999	4.05	69200.0
2008-01-17 09:00:00	AMZN	Stock	4.0575	4.079	3.9775	4.04	11030180.0
2008-01-17 10:00:00	AMZN	Stock	4.0385	4.075	3.993	4.0695	35982520.0
2008-01-17 11:00:00	AMZN	Stock	4.07	4.1125	4.005	4.0635	26022780.0
2008-01-17 12:00:00	AMZN	Stock	4.062	4.068	4.007	4.037	19164940.0
2008-01-17 13:00:00	AMZN	Stock	4.0385	4.0895	4.021	4.0525	20897820.0
2008-01-17 14:00:00	AMZN	Stock	4.0525	4.0615	4.0005	4.0305	30613700.0
2008-01-17 15:00:00	AMZN	Stock	4.0305	4.049	3.977	4.001	47906720.0

> showing 50 of 41,560 rows — these rows as CSV

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