PREVIEW / stock_1hour / 2008-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-12.parquet
  size:    833 KB
  rows:    40,009
  symbols: 3,306

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-06-12 05:00:00	AAPL	Stock	6.4911	6.4911	6.4821	6.4821	8400.0
2008-06-12 06:00:00	AAPL	Stock	6.4811	6.4811	6.4589	6.475	123200.0
2008-06-12 07:00:00	AAPL	Stock	6.4914	6.5357	6.4911	6.5304	1108968.0
2008-06-12 08:00:00	AAPL	Stock	6.5243	6.525	6.4821	6.5	4538632.0
2008-06-12 09:00:00	AAPL	Stock	6.5021	6.5214	6.4429	6.4589	121822988.0
2008-06-12 10:00:00	AAPL	Stock	6.4589	6.4704	6.2536	6.3118	315937776.0
2008-06-12 11:00:00	AAPL	Stock	6.3118	6.345	6.2654	6.285	151004532.0
2008-06-12 12:00:00	AAPL	Stock	6.2846	6.3168	6.2561	6.2625	91977760.0
2008-06-12 13:00:00	AAPL	Stock	6.2625	6.275	6.2164	6.2439	144660348.0
2008-06-12 14:00:00	AAPL	Stock	6.2432	6.2554	6.1143	6.1839	185571960.0
2008-06-12 15:00:00	AAPL	Stock	6.1839	6.1964	6.1254	6.1711	203500500.0
2008-06-12 16:00:00	AAPL	Stock	6.1711	6.38	6.1606	6.1714	22170176.0
2008-06-12 17:00:00	AAPL	Stock	6.1732	6.1879	6.1339	6.1425	1635928.0
2008-06-12 18:00:00	AAPL	Stock	6.1429	6.1536	6.1357	6.1507	449204.0
2008-06-12 19:00:00	AAPL	Stock	6.1454	6.1514	6.1411	6.1411	629216.0
2008-06-12 07:00:00	MSFT	Stock	27.34	27.34	27.34	27.34	600.0
2008-06-12 08:00:00	MSFT	Stock	27.3	27.39	27.28	27.33	74569.0
2008-06-12 09:00:00	MSFT	Stock	27.35	27.58	27.3	27.44	5776337.0
2008-06-12 10:00:00	MSFT	Stock	27.45	27.55	27.26	27.49	8772970.0
2008-06-12 11:00:00	MSFT	Stock	27.48	27.55	27.29	27.33	5851517.0
2008-06-12 12:00:00	MSFT	Stock	27.32	27.45	27.24	27.25	4109281.0
2008-06-12 13:00:00	MSFT	Stock	27.25	27.32	27.19	27.27	6402378.0
2008-06-12 14:00:00	MSFT	Stock	27.27	27.87	27.23	27.85	27299683.0
2008-06-12 15:00:00	MSFT	Stock	27.85	28.55	27.75	28.26	49452496.0
2008-06-12 16:00:00	MSFT	Stock	28.28	28.38	27.305	28.32	3774673.0
2008-06-12 17:00:00	MSFT	Stock	28.32	28.42	28.24	28.3	167696.0
2008-06-12 18:00:00	MSFT	Stock	28.3	28.32	28.28	28.29	20049.0
2008-06-12 19:00:00	MSFT	Stock	28.29	28.33	28.29	28.33	3700.0
2008-06-12 20:00:00	MSFT	Stock	28.24	28.24	28.24	28.24	16900.0
2008-06-12 08:00:00	NVDA	Stock	0.5342	0.544	0.5342	0.5388	1621520.0
2008-06-12 09:00:00	NVDA	Stock	0.5388	0.5538	0.5385	0.5482	136772200.0
2008-06-12 10:00:00	NVDA	Stock	0.548	0.5505	0.5388	0.5425	154505760.0
2008-06-12 11:00:00	NVDA	Stock	0.5425	0.549	0.54	0.5475	106918920.0
2008-06-12 12:00:00	NVDA	Stock	0.5475	0.5478	0.542	0.5422	50056200.0
2008-06-12 13:00:00	NVDA	Stock	0.5425	0.5448	0.5407	0.5428	97634000.0
2008-06-12 14:00:00	NVDA	Stock	0.5428	0.5445	0.5335	0.5352	93782360.0
2008-06-12 15:00:00	NVDA	Stock	0.5355	0.5365	0.53	0.5345	151358480.0
2008-06-12 16:00:00	NVDA	Stock	0.5345	0.5424	0.5325	0.5365	6111960.0
2008-06-12 17:00:00	NVDA	Stock	0.5372	0.5419	0.5345	0.5365	196080.0
2008-06-12 18:00:00	NVDA	Stock	0.5462	0.5462	0.5365	0.5375	3280000.0
2008-06-12 08:00:00	AMZN	Stock	3.88	3.922	3.88	3.922	64000.0
2008-06-12 09:00:00	AMZN	Stock	3.92	3.9525	3.8775	3.935	11641660.0
2008-06-12 10:00:00	AMZN	Stock	3.9345	3.947	3.8515	3.879	24739420.0
2008-06-12 11:00:00	AMZN	Stock	3.8785	3.903	3.8295	3.841	14830120.0
2008-06-12 12:00:00	AMZN	Stock	3.841	3.8695	3.819	3.824	8446020.0
2008-06-12 13:00:00	AMZN	Stock	3.824	3.837	3.797	3.819	16871460.0
2008-06-12 14:00:00	AMZN	Stock	3.818	3.827	3.7505	3.7775	17517820.0
2008-06-12 15:00:00	AMZN	Stock	3.778	3.813	3.758	3.8085	24006160.0
2008-06-12 16:00:00	AMZN	Stock	3.8075	3.844	3.7845	3.8075	3626940.0
2008-06-12 17:00:00	AMZN	Stock	3.8075	3.9113	3.8075	3.9113	91880.0

> showing 50 of 40,009 rows — these rows as CSV

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