PREVIEW / stock_1hour / 2008-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-13.parquet
  size:    823 KB
  rows:    39,628
  symbols: 3,327

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-08-13 04:00:00	AAPL	Stock	6.2996	6.2996	6.2996	6.2996	2800.0
2008-08-13 06:00:00	AAPL	Stock	6.2804	6.2804	6.2804	6.2804	26936.0
2008-08-13 07:00:00	AAPL	Stock	6.2979	6.3786	6.2939	6.3482	813260.0
2008-08-13 08:00:00	AAPL	Stock	6.3536	6.3732	6.3286	6.3318	3518032.0
2008-08-13 09:00:00	AAPL	Stock	6.3371	6.4214	6.3239	6.3886	134534904.0
2008-08-13 10:00:00	AAPL	Stock	6.3882	6.4268	6.3546	6.4025	152373312.0
2008-08-13 11:00:00	AAPL	Stock	6.4025	6.4032	6.2904	6.2936	118381900.0
2008-08-13 12:00:00	AAPL	Stock	6.2936	6.3475	6.2821	6.3375	74379424.0
2008-08-13 13:00:00	AAPL	Stock	6.3371	6.3929	6.3314	6.3907	92059576.0
2008-08-13 14:00:00	AAPL	Stock	6.3896	6.4286	6.3722	6.4264	110079900.0
2008-08-13 15:00:00	AAPL	Stock	6.4264	6.4286	6.3729	6.4043	138203240.0
2008-08-13 16:00:00	AAPL	Stock	6.4043	6.4086	6.3767	6.4014	8546720.0
2008-08-13 17:00:00	AAPL	Stock	6.4	6.4	6.3607	6.3964	120792.0
2008-08-13 18:00:00	AAPL	Stock	6.3961	6.4054	6.3946	6.4043	305312.0
2008-08-13 19:00:00	AAPL	Stock	6.4043	6.4071	6.3993	6.3993	218876.0
2008-08-13 07:00:00	MSFT	Stock	28.2	28.28	28.2	28.28	3000.0
2008-08-13 08:00:00	MSFT	Stock	28.21	28.21	28.01	28.05	13654.0
2008-08-13 09:00:00	MSFT	Stock	28.08	28.5	28.01	28.28	4682289.0
2008-08-13 10:00:00	MSFT	Stock	28.28	28.44	28.0	28.11	7945946.0
2008-08-13 11:00:00	MSFT	Stock	28.12	28.12	27.98	28.0	5363577.0
2008-08-13 12:00:00	MSFT	Stock	28.0	28.09	27.97	28.01	5229527.0
2008-08-13 13:00:00	MSFT	Stock	28.01	28.1	27.89	28.061	6733634.0
2008-08-13 14:00:00	MSFT	Stock	28.06	28.14	27.95	28.11	6275168.0
2008-08-13 15:00:00	MSFT	Stock	28.11	28.16	27.76	27.91	10452378.0
2008-08-13 16:00:00	MSFT	Stock	27.91	28.043	27.84	27.896	2596718.0
2008-08-13 17:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	1000.0
2008-08-13 18:00:00	MSFT	Stock	27.91	27.91	27.88	27.88	2150.0
2008-08-13 19:00:00	MSFT	Stock	27.88	27.9	27.88	27.9	1100.0
2008-08-13 06:00:00	NVDA	Stock	0.3012	0.3012	0.3012	0.3012	10400.0
2008-08-13 07:00:00	NVDA	Stock	0.3	0.3	0.2875	0.2942	2396000.0
2008-08-13 08:00:00	NVDA	Stock	0.2942	0.2962	0.2875	0.2912	19774280.0
2008-08-13 09:00:00	NVDA	Stock	0.2918	0.3088	0.2852	0.3048	490048120.0
2008-08-13 10:00:00	NVDA	Stock	0.305	0.311	0.295	0.3058	584397520.0
2008-08-13 11:00:00	NVDA	Stock	0.3058	0.3058	0.3018	0.3042	229553320.0
2008-08-13 12:00:00	NVDA	Stock	0.3042	0.305	0.2992	0.3005	143564360.0
2008-08-13 13:00:00	NVDA	Stock	0.3006	0.3035	0.2988	0.3034	133030440.0
2008-08-13 14:00:00	NVDA	Stock	0.3032	0.3075	0.3	0.3075	162424000.0
2008-08-13 15:00:00	NVDA	Stock	0.3075	0.3075	0.3045	0.307	268681480.0
2008-08-13 16:00:00	NVDA	Stock	0.307	0.308	0.3046	0.3073	28677920.0
2008-08-13 17:00:00	NVDA	Stock	0.3065	0.3075	0.306	0.3065	224000.0
2008-08-13 18:00:00	NVDA	Stock	0.3048	0.3075	0.3045	0.3045	60320.0
2008-08-13 19:00:00	NVDA	Stock	0.3052	0.3052	0.3052	0.3052	64000.0
2008-08-13 08:00:00	AMZN	Stock	4.33	4.33	4.33	4.33	2000.0
2008-08-13 09:00:00	AMZN	Stock	4.33	4.391	4.3065	4.325	12145640.0
2008-08-13 10:00:00	AMZN	Stock	4.325	4.359	4.27	4.3345	23000040.0
2008-08-13 11:00:00	AMZN	Stock	4.3335	4.3335	4.227	4.2505	17278220.0
2008-08-13 12:00:00	AMZN	Stock	4.2505	4.273	4.2425	4.269	16058580.0
2008-08-13 13:00:00	AMZN	Stock	4.27	4.323	4.2405	4.3075	14486900.0
2008-08-13 14:00:00	AMZN	Stock	4.3065	4.3995	4.29	4.3935	22420000.0
2008-08-13 15:00:00	AMZN	Stock	4.3955	4.4125	4.2865	4.3415	36295300.0

> showing 50 of 39,628 rows — these rows as CSV

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