PREVIEW / stock_1hour / 2008-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-18.parquet
  size:    844 KB
  rows:    40,505
  symbols: 3,303

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-18 06:00:00	AAPL	Stock	6.4779	6.4989	6.4779	6.4989	32200.0
2008-06-18 07:00:00	AAPL	Stock	6.4821	6.4907	6.4757	6.4771	164080.0
2008-06-18 08:00:00	AAPL	Stock	6.4682	6.4804	6.44	6.4554	2316524.0
2008-06-18 09:00:00	AAPL	Stock	6.4536	6.5071	6.4361	6.4646	110165664.0
2008-06-18 10:00:00	AAPL	Stock	6.4646	6.4907	6.3339	6.3661	183205036.0
2008-06-18 11:00:00	AAPL	Stock	6.3657	6.4482	6.3525	6.4418	129601472.0
2008-06-18 12:00:00	AAPL	Stock	6.4421	6.4429	6.3975	6.4092	59341912.0
2008-06-18 13:00:00	AAPL	Stock	6.4089	6.4107	6.3525	6.3986	81036200.0
2008-06-18 14:00:00	AAPL	Stock	6.3982	6.4129	6.3746	6.3996	73662960.0
2008-06-18 15:00:00	AAPL	Stock	6.3996	6.4293	6.3661	6.3825	124362168.0
2008-06-18 16:00:00	AAPL	Stock	6.3868	6.4135	6.3661	6.3679	25273668.0
2008-06-18 17:00:00	AAPL	Stock	6.3664	6.4046	6.3643	6.3646	250656.0
2008-06-18 18:00:00	AAPL	Stock	6.4814	6.4814	6.3657	6.3736	230104.0
2008-06-18 19:00:00	AAPL	Stock	6.3707	6.3746	6.3664	6.3739	208376.0
2008-06-18 08:00:00	MSFT	Stock	28.64	28.7	28.6	28.69	11886.0
2008-06-18 09:00:00	MSFT	Stock	28.7	28.86	28.52	28.67	4835530.0
2008-06-18 10:00:00	MSFT	Stock	28.66	28.752	28.58	28.61	6771329.0
2008-06-18 11:00:00	MSFT	Stock	28.62	28.78	28.558	28.73	5796148.0
2008-06-18 12:00:00	MSFT	Stock	28.73	28.77	28.62	28.66	3931054.0
2008-06-18 13:00:00	MSFT	Stock	28.66	28.71	28.55	28.59	4429086.0
2008-06-18 14:00:00	MSFT	Stock	28.595	28.66	28.5	28.61	6901215.0
2008-06-18 15:00:00	MSFT	Stock	28.62	28.67	28.46	28.46	9987645.0
2008-06-18 16:00:00	MSFT	Stock	28.46	28.647	28.45	28.49	4039592.0
2008-06-18 17:00:00	MSFT	Stock	28.49	28.55	28.46	28.49	13092.0
2008-06-18 18:00:00	MSFT	Stock	28.49	28.49	28.49	28.49	800.0
2008-06-18 19:00:00	MSFT	Stock	28.49	28.56	28.49	28.56	9191.0
2008-06-18 08:00:00	NVDA	Stock	0.531	0.531	0.5058	0.5062	649960.0
2008-06-18 09:00:00	NVDA	Stock	0.5065	0.5122	0.5032	0.5043	101778520.0
2008-06-18 10:00:00	NVDA	Stock	0.5043	0.5085	0.495	0.4955	180009520.0
2008-06-18 11:00:00	NVDA	Stock	0.4955	0.499	0.4938	0.4972	185321000.0
2008-06-18 12:00:00	NVDA	Stock	0.4972	0.4998	0.4952	0.4985	111260920.0
2008-06-18 13:00:00	NVDA	Stock	0.4985	0.4995	0.4935	0.4937	130984640.0
2008-06-18 14:00:00	NVDA	Stock	0.4935	0.495	0.4895	0.4932	135936600.0
2008-06-18 15:00:00	NVDA	Stock	0.4935	0.4995	0.4934	0.4978	182823320.0
2008-06-18 16:00:00	NVDA	Stock	0.4978	0.4998	0.4966	0.4978	5187960.0
2008-06-18 17:00:00	NVDA	Stock	0.4978	0.4988	0.4978	0.4988	42720.0
2008-06-18 18:00:00	NVDA	Stock	0.4988	0.5	0.4988	0.4998	306000.0
2008-06-18 08:00:00	AMZN	Stock	4.1385	4.1385	4.1	4.105	97080.0
2008-06-18 09:00:00	AMZN	Stock	4.1055	4.126	4.075	4.1005	17765340.0
2008-06-18 10:00:00	AMZN	Stock	4.1008	4.103	4.066	4.0685	26329880.0
2008-06-18 11:00:00	AMZN	Stock	4.0695	4.138	4.0665	4.1255	16692340.0
2008-06-18 12:00:00	AMZN	Stock	4.1245	4.1352	4.1095	4.117	18955380.0
2008-06-18 13:00:00	AMZN	Stock	4.116	4.116	4.081	4.0995	15432980.0
2008-06-18 14:00:00	AMZN	Stock	4.1	4.13	4.0905	4.129	12439100.0
2008-06-18 15:00:00	AMZN	Stock	4.129	4.1585	4.1125	4.123	22266960.0
2008-06-18 16:00:00	AMZN	Stock	4.134	4.145	4.1062	4.1275	1508880.0
2008-06-18 17:00:00	AMZN	Stock	4.1044	4.126	4.1044	4.126	10420.0
2008-06-18 18:00:00	AMZN	Stock	4.1265	4.1265	4.1265	4.1265	20000.0
2008-06-18 19:00:00	AMZN	Stock	4.105	4.105	4.105	4.105	10000.0
2008-06-18 09:00:00	TLT	Stock	89.29	89.29	89.09	89.21	109524.0

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

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