PREVIEW / stock_1hour / 2008-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-07.parquet
  size:    824 KB
  rows:    40,077
  symbols: 3,309

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-07 07:00:00	AAPL	Stock	5.8411	5.8479	5.8207	5.8214	223440.0
2008-08-07 08:00:00	AAPL	Stock	5.8214	5.8286	5.7857	5.795	1857352.0
2008-08-07 09:00:00	AAPL	Stock	5.7946	5.8768	5.7679	5.8443	107869608.0
2008-08-07 10:00:00	AAPL	Stock	5.8464	5.8929	5.8286	5.8671	121080456.0
2008-08-07 11:00:00	AAPL	Stock	5.8675	5.9114	5.8464	5.9054	79517648.0
2008-08-07 12:00:00	AAPL	Stock	5.905	5.9339	5.8804	5.9243	72762004.0
2008-08-07 13:00:00	AAPL	Stock	5.9246	5.9314	5.8786	5.8807	57598996.0
2008-08-07 14:00:00	AAPL	Stock	5.8811	5.8832	5.8239	5.83	88965464.0
2008-08-07 15:00:00	AAPL	Stock	5.8307	5.8589	5.8043	5.8507	117077156.0
2008-08-07 16:00:00	AAPL	Stock	5.845	5.867	5.8336	5.8418	11775596.0
2008-08-07 17:00:00	AAPL	Stock	5.8536	5.855	5.8486	5.8525	296100.0
2008-08-07 18:00:00	AAPL	Stock	5.85	5.8521	5.8479	5.8521	148120.0
2008-08-07 19:00:00	AAPL	Stock	5.8493	5.8571	5.8493	5.8514	120400.0
2008-08-07 08:00:00	MSFT	Stock	26.87	27.0	26.77	26.77	19625.0
2008-08-07 09:00:00	MSFT	Stock	26.77	27.11	26.73	27.1	5090735.0
2008-08-07 10:00:00	MSFT	Stock	27.1	27.5	26.98	27.49	13453508.0
2008-08-07 11:00:00	MSFT	Stock	27.49	27.62	27.33	27.43	12411631.0
2008-08-07 12:00:00	MSFT	Stock	27.43	27.69	27.38	27.67	9465137.0
2008-08-07 13:00:00	MSFT	Stock	27.67	27.75	27.54	27.54	7935412.0
2008-08-07 14:00:00	MSFT	Stock	27.54	27.56	27.34	27.35	10299521.0
2008-08-07 15:00:00	MSFT	Stock	27.35	27.54	27.33	27.43	18491956.0
2008-08-07 16:00:00	MSFT	Stock	27.39	27.499	27.37	27.47	4078596.0
2008-08-07 17:00:00	MSFT	Stock	27.42	27.49	27.42	27.49	2250.0
2008-08-07 18:00:00	MSFT	Stock	27.43	27.48	27.42	27.48	800.0
2008-08-07 19:00:00	MSFT	Stock	27.44	27.44	27.42	27.43	2100.0
2008-08-07 20:00:00	MSFT	Stock	27.52	27.52	27.52	27.52	25400.0
2008-08-07 08:00:00	NVDA	Stock	0.2875	0.288	0.2788	0.2788	452000.0
2008-08-07 09:00:00	NVDA	Stock	0.28	0.2888	0.2795	0.2888	70506120.0
2008-08-07 10:00:00	NVDA	Stock	0.289	0.2925	0.2858	0.2913	110616680.0
2008-08-07 11:00:00	NVDA	Stock	0.2915	0.2952	0.29	0.2945	77807360.0
2008-08-07 12:00:00	NVDA	Stock	0.2942	0.2975	0.2912	0.2973	81096720.0
2008-08-07 13:00:00	NVDA	Stock	0.2972	0.2975	0.2912	0.2915	99860960.0
2008-08-07 14:00:00	NVDA	Stock	0.2912	0.2925	0.289	0.2898	106949400.0
2008-08-07 15:00:00	NVDA	Stock	0.2898	0.2902	0.2825	0.2835	244750080.0
2008-08-07 16:00:00	NVDA	Stock	0.2828	0.2908	0.2828	0.2828	19317000.0
2008-08-07 17:00:00	NVDA	Stock	0.2832	0.2832	0.2832	0.2832	6000.0
2008-08-07 18:00:00	NVDA	Stock	0.2838	0.2848	0.2838	0.2848	18000.0
2008-08-07 19:00:00	NVDA	Stock	0.2845	0.2852	0.284	0.284	136000.0
2008-08-07 08:00:00	AMZN	Stock	3.8855	3.898	3.863	3.866	10000.0
2008-08-07 09:00:00	AMZN	Stock	3.866	3.885	3.8	3.865	12481560.0
2008-08-07 10:00:00	AMZN	Stock	3.865	3.9025	3.855	3.8915	17138080.0
2008-08-07 11:00:00	AMZN	Stock	3.892	3.9	3.8505	3.865	11464780.0
2008-08-07 12:00:00	AMZN	Stock	3.8655	3.89	3.8565	3.8845	11037520.0
2008-08-07 13:00:00	AMZN	Stock	3.8825	3.8865	3.8705	3.875	7491800.0
2008-08-07 14:00:00	AMZN	Stock	3.8752	3.877	3.823	3.84	13969940.0
2008-08-07 15:00:00	AMZN	Stock	3.8405	3.86	3.828	3.849	29248120.0
2008-08-07 16:00:00	AMZN	Stock	3.852	3.8828	3.845	3.8525	5043800.0
2008-08-07 17:00:00	AMZN	Stock	3.855	3.86	3.855	3.86	11000.0
2008-08-07 19:00:00	AMZN	Stock	3.855	3.855	3.855	3.855	10200.0
2008-08-07 08:00:00	TLT	Stock	90.53	90.69	90.51	90.64	19100.0

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

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