PREVIEW / stock_1hour / 2010-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-02.parquet
  size:    954 KB
  rows:    46,165
  symbols: 3,502

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
2010-11-02 04:00:00	AAPL	Stock	10.8896	10.8929	10.8893	10.8929	11200.0
2010-11-02 05:00:00	AAPL	Stock	10.9018	10.9018	10.8929	10.8929	23240.0
2010-11-02 06:00:00	AAPL	Stock	10.9007	10.9164	10.8893	10.9164	103460.0
2010-11-02 07:00:00	AAPL	Stock	10.9107	10.9407	10.9054	10.9346	276696.0
2010-11-02 08:00:00	AAPL	Stock	10.9357	10.9389	10.9154	10.9304	3132668.0
2010-11-02 09:00:00	AAPL	Stock	10.9307	11.0589	10.9304	11.0236	99126636.0
2010-11-02 10:00:00	AAPL	Stock	11.0235	11.0321	10.985	11.0175	57561812.0
2010-11-02 11:00:00	AAPL	Stock	11.0175	11.0268	10.9932	11.0143	27010956.0
2010-11-02 12:00:00	AAPL	Stock	11.015	11.0464	11.0089	11.0418	37832648.0
2010-11-02 13:00:00	AAPL	Stock	11.0418	11.0782	11.0411	11.0618	65100588.0
2010-11-02 14:00:00	AAPL	Stock	11.0614	11.0621	11.02	11.0377	45668056.0
2010-11-02 15:00:00	AAPL	Stock	11.0375	11.075	11.0282	11.0607	79030812.0
2010-11-02 16:00:00	AAPL	Stock	11.0593	11.0768	11.0343	11.0679	13874532.0
2010-11-02 17:00:00	AAPL	Stock	10.8636	11.0714	10.8636	11.0654	930692.0
2010-11-02 18:00:00	AAPL	Stock	11.0675	11.0821	11.0486	11.0654	1094688.0
2010-11-02 19:00:00	AAPL	Stock	11.0714	11.1014	11.0682	11.0979	1691620.0
2010-11-02 05:00:00	MSFT	Stock	27.15	27.15	27.15	27.15	100.0
2010-11-02 06:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	1000.0
2010-11-02 07:00:00	MSFT	Stock	27.06	27.11	27.02	27.02	7000.0
2010-11-02 08:00:00	MSFT	Stock	27.07	27.1	26.98	27.08	86362.0
2010-11-02 09:00:00	MSFT	Stock	27.08	27.25	26.95	27.18	6663320.0
2010-11-02 10:00:00	MSFT	Stock	27.18	27.22	27.12	27.12	7006158.0
2010-11-02 11:00:00	MSFT	Stock	27.12	27.195	27.12	27.18	3905927.0
2010-11-02 12:00:00	MSFT	Stock	27.175	27.32	27.17	27.3	5720599.0
2010-11-02 13:00:00	MSFT	Stock	27.3	27.4	27.27	27.34	7117135.0
2010-11-02 14:00:00	MSFT	Stock	27.349	27.385	27.31	27.374	4896925.0
2010-11-02 15:00:00	MSFT	Stock	27.37	27.42	27.33	27.4	14012339.0
2010-11-02 16:00:00	MSFT	Stock	27.39	27.45	26.95	27.42	3278320.0
2010-11-02 17:00:00	MSFT	Stock	26.95	27.45	26.95	27.42	134408.0
2010-11-02 18:00:00	MSFT	Stock	27.42	27.45	27.39	27.44	28554.0
2010-11-02 19:00:00	MSFT	Stock	27.45	27.5	27.45	27.49	7872.0
2010-11-02 09:00:00	NVDA	Stock	0.3028	0.3045	0.3005	0.3023	61492720.0
2010-11-02 10:00:00	NVDA	Stock	0.3022	0.3045	0.302	0.3032	60494760.0
2010-11-02 11:00:00	NVDA	Stock	0.3033	0.3065	0.3032	0.306	63011280.0
2010-11-02 12:00:00	NVDA	Stock	0.306	0.3062	0.3052	0.3055	23921400.0
2010-11-02 13:00:00	NVDA	Stock	0.3058	0.3123	0.3055	0.3113	181034920.0
2010-11-02 14:00:00	NVDA	Stock	0.3113	0.3115	0.3078	0.3078	78163360.0
2010-11-02 15:00:00	NVDA	Stock	0.3078	0.3088	0.3068	0.307	100537680.0
2010-11-02 16:00:00	NVDA	Stock	0.307	0.3118	0.307	0.3073	1521320.0
2010-11-02 17:00:00	NVDA	Stock	0.301	0.3073	0.301	0.3071	445640.0
2010-11-02 19:00:00	NVDA	Stock	0.3093	0.3093	0.3093	0.3093	8040.0
2010-11-02 07:00:00	AMZN	Stock	8.173	8.2045	8.173	8.2045	4000.0
2010-11-02 08:00:00	AMZN	Stock	8.1735	8.1805	8.1655	8.166	78380.0
2010-11-02 09:00:00	AMZN	Stock	8.1725	8.2705	8.1725	8.1985	17688400.0
2010-11-02 10:00:00	AMZN	Stock	8.2	8.2345	8.168	8.228	16866020.0
2010-11-02 11:00:00	AMZN	Stock	8.226	8.245	8.2025	8.2155	7513700.0
2010-11-02 12:00:00	AMZN	Stock	8.218	8.2468	8.2045	8.244	6158420.0
2010-11-02 13:00:00	AMZN	Stock	8.2435	8.297	8.239	8.2845	9858680.0
2010-11-02 14:00:00	AMZN	Stock	8.285	8.294	8.252	8.2615	8690600.0
2010-11-02 15:00:00	AMZN	Stock	8.2635	8.272	8.2215	8.2305	14910660.0

> showing 50 of 46,165 rows — these rows as CSV

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