PREVIEW / stock_1hour / 2008-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-11.parquet
  size:    836 KB
  rows:    41,312
  symbols: 3,332

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-09-11 05:00:00	AAPL	Stock	5.3679	5.3679	5.3679	5.3679	2800.0
2008-09-11 07:00:00	AAPL	Stock	5.3571	5.3571	5.3321	5.3321	19600.0
2008-09-11 08:00:00	AAPL	Stock	5.3261	5.3464	5.2804	5.2929	3432716.0
2008-09-11 09:00:00	AAPL	Stock	5.2886	5.3107	5.2143	5.2361	155451520.0
2008-09-11 10:00:00	AAPL	Stock	5.2395	5.3279	5.2182	5.3182	187301604.0
2008-09-11 11:00:00	AAPL	Stock	5.3182	5.3911	5.2846	5.3907	121916396.0
2008-09-11 12:00:00	AAPL	Stock	5.3896	5.4179	5.3225	5.3532	115638152.0
2008-09-11 13:00:00	AAPL	Stock	5.3532	5.3543	5.2954	5.33	92212484.0
2008-09-11 14:00:00	AAPL	Stock	5.3293	5.3689	5.3227	5.3279	102582816.0
2008-09-11 15:00:00	AAPL	Stock	5.3279	5.4639	5.3211	5.4521	171272192.0
2008-09-11 16:00:00	AAPL	Stock	5.4543	5.4761	5.3228	5.4721	11702880.0
2008-09-11 17:00:00	AAPL	Stock	5.4721	5.4793	5.4464	5.4464	1891596.0
2008-09-11 18:00:00	AAPL	Stock	5.4464	5.4625	5.4464	5.4557	192724.0
2008-09-11 19:00:00	AAPL	Stock	5.4607	5.4786	5.4607	5.4775	429800.0
2008-09-11 08:00:00	MSFT	Stock	26.25	26.4	26.0	26.01	8869.0
2008-09-11 09:00:00	MSFT	Stock	26.05	26.6	26.0	26.57	6278947.0
2008-09-11 10:00:00	MSFT	Stock	26.57	26.86	26.57	26.8	11963258.0
2008-09-11 11:00:00	MSFT	Stock	26.8	26.85	26.67	26.8	5934244.0
2008-09-11 12:00:00	MSFT	Stock	26.8	26.99	26.8	26.93	8663405.0
2008-09-11 13:00:00	MSFT	Stock	26.93	27.03	26.85	27.002	8185023.0
2008-09-11 14:00:00	MSFT	Stock	27.01	27.17	27.0	27.06	8657700.0
2008-09-11 15:00:00	MSFT	Stock	27.05	27.46	27.05	27.33	18419640.0
2008-09-11 16:00:00	MSFT	Stock	27.38	27.42	26.863	27.28	3258802.0
2008-09-11 17:00:00	MSFT	Stock	27.32	27.32	27.24	27.32	235600.0
2008-09-11 18:00:00	MSFT	Stock	27.26	27.26	27.26	27.26	500.0
2008-09-11 19:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	1400.0
2008-09-11 05:00:00	NVDA	Stock	0.27	0.27	0.27	0.27	4000.0
2008-09-11 06:00:00	NVDA	Stock	0.265	0.265	0.265	0.265	4000.0
2008-09-11 07:00:00	NVDA	Stock	0.265	0.265	0.258	0.258	68000.0
2008-09-11 08:00:00	NVDA	Stock	0.2625	0.2625	0.2563	0.2563	1073760.0
2008-09-11 09:00:00	NVDA	Stock	0.2563	0.2583	0.249	0.2507	157217720.0
2008-09-11 10:00:00	NVDA	Stock	0.2505	0.2595	0.2505	0.2592	158370960.0
2008-09-11 11:00:00	NVDA	Stock	0.2595	0.2624	0.257	0.2618	96729200.0
2008-09-11 12:00:00	NVDA	Stock	0.2618	0.263	0.2598	0.2615	110137520.0
2008-09-11 13:00:00	NVDA	Stock	0.2615	0.262	0.257	0.2575	142582840.0
2008-09-11 14:00:00	NVDA	Stock	0.2578	0.2588	0.256	0.2565	149937800.0
2008-09-11 15:00:00	NVDA	Stock	0.2565	0.2583	0.2538	0.2578	214995760.0
2008-09-11 16:00:00	NVDA	Stock	0.2578	0.2675	0.2538	0.2675	31948160.0
2008-09-11 17:00:00	NVDA	Stock	0.2638	0.2638	0.2575	0.2575	1260000.0
2008-09-11 18:00:00	NVDA	Stock	0.2588	0.2588	0.2588	0.2588	36000.0
2008-09-11 19:00:00	NVDA	Stock	0.2592	0.2595	0.2592	0.2595	45800.0
2008-09-11 07:00:00	AMZN	Stock	3.805	3.805	3.805	3.805	2000.0
2008-09-11 08:00:00	AMZN	Stock	3.8185	3.8315	3.74	3.75	659100.0
2008-09-11 09:00:00	AMZN	Stock	3.76	3.8415	3.755	3.813	17992160.0
2008-09-11 10:00:00	AMZN	Stock	3.814	3.885	3.8015	3.884	25592480.0
2008-09-11 11:00:00	AMZN	Stock	3.8835	3.9355	3.8725	3.917	17685680.0
2008-09-11 12:00:00	AMZN	Stock	3.9175	3.9525	3.8755	3.8945	20743240.0
2008-09-11 13:00:00	AMZN	Stock	3.895	3.9295	3.8535	3.918	15698200.0
2008-09-11 14:00:00	AMZN	Stock	3.918	3.974	3.914	3.95	19221420.0
2008-09-11 15:00:00	AMZN	Stock	3.949	3.99	3.911	3.978	33698040.0

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

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