PREVIEW / stock_1hour / 2010-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-16.parquet
  size:    889 KB
  rows:    42,500
  symbols: 3,459

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-06-16 05:00:00	AAPL	Stock	9.2321	9.2321	9.2196	9.2196	9100.0
2010-06-16 06:00:00	AAPL	Stock	9.22	9.2239	9.2196	9.2196	26600.0
2010-06-16 07:00:00	AAPL	Stock	9.2554	9.2821	9.2389	9.2518	370440.0
2010-06-16 08:00:00	AAPL	Stock	9.2536	9.2721	9.2071	9.2679	3936996.0
2010-06-16 09:00:00	AAPL	Stock	9.2643	9.4239	9.26	9.4104	123430496.0
2010-06-16 10:00:00	AAPL	Stock	9.4104	9.4271	9.3714	9.4271	107479624.0
2010-06-16 11:00:00	AAPL	Stock	9.4271	9.4954	9.4082	9.4918	133483224.0
2010-06-16 12:00:00	AAPL	Stock	9.4918	9.5179	9.4654	9.4893	90138076.0
2010-06-16 13:00:00	AAPL	Stock	9.4896	9.5175	9.4732	9.515	58700404.0
2010-06-16 14:00:00	AAPL	Stock	9.515	9.5625	9.5057	9.5543	90529908.0
2010-06-16 15:00:00	AAPL	Stock	9.5536	9.5554	9.4946	9.5457	155560664.0
2010-06-16 16:00:00	AAPL	Stock	9.5457	9.5625	9.3124	9.5532	8639232.0
2010-06-16 17:00:00	AAPL	Stock	9.5525	9.5554	9.5446	9.5536	359716.0
2010-06-16 18:00:00	AAPL	Stock	9.5536	9.5536	9.5379	9.55	708932.0
2010-06-16 19:00:00	AAPL	Stock	9.55	9.5554	9.5446	9.5536	443184.0
2010-06-16 07:00:00	MSFT	Stock	26.47	26.47	26.43	26.43	11600.0
2010-06-16 08:00:00	MSFT	Stock	26.45	26.45	26.33	26.41	41294.0
2010-06-16 09:00:00	MSFT	Stock	26.42	26.58	26.31	26.378	4728280.0
2010-06-16 10:00:00	MSFT	Stock	26.375	26.44	26.3	26.42	8048939.0
2010-06-16 11:00:00	MSFT	Stock	26.421	26.55	26.38	26.401	5711152.0
2010-06-16 12:00:00	MSFT	Stock	26.41	26.54	26.4	26.46	2808088.0
2010-06-16 13:00:00	MSFT	Stock	26.47	26.5	26.42	26.5	3394433.0
2010-06-16 14:00:00	MSFT	Stock	26.5	26.55	26.41	26.44	4919715.0
2010-06-16 15:00:00	MSFT	Stock	26.44	26.44	26.23	26.33	11760559.0
2010-06-16 16:00:00	MSFT	Stock	26.33	26.407	26.28	26.308	5983923.0
2010-06-16 17:00:00	MSFT	Stock	26.499	26.499	26.3	26.3	452785.0
2010-06-16 18:00:00	MSFT	Stock	26.32	26.32	26.26	26.26	78071.0
2010-06-16 19:00:00	MSFT	Stock	26.3	26.38	26.3	26.38	216.0
2010-06-16 20:00:00	MSFT	Stock	26.52	26.52	26.52	26.52	1000.0
2010-06-16 08:00:00	NVDA	Stock	0.295	0.295	0.2912	0.292	102200.0
2010-06-16 09:00:00	NVDA	Stock	0.2928	0.296	0.2925	0.293	35538600.0
2010-06-16 10:00:00	NVDA	Stock	0.2931	0.2952	0.2902	0.295	87181440.0
2010-06-16 11:00:00	NVDA	Stock	0.2948	0.2975	0.294	0.296	36232160.0
2010-06-16 12:00:00	NVDA	Stock	0.296	0.2978	0.2939	0.2948	30263840.0
2010-06-16 13:00:00	NVDA	Stock	0.2948	0.2974	0.2945	0.2972	19408360.0
2010-06-16 14:00:00	NVDA	Stock	0.2975	0.2988	0.2952	0.296	57584600.0
2010-06-16 15:00:00	NVDA	Stock	0.2958	0.296	0.293	0.2945	85606000.0
2010-06-16 16:00:00	NVDA	Stock	0.2942	0.2962	0.294	0.2959	7334600.0
2010-06-16 17:00:00	NVDA	Stock	0.2938	0.2938	0.2938	0.2938	4000.0
2010-06-16 18:00:00	NVDA	Stock	0.2988	0.3062	0.2988	0.3048	2206240.0
2010-06-16 19:00:00	NVDA	Stock	0.3045	0.3048	0.3028	0.3042	1244480.0
2010-06-16 07:00:00	AMZN	Stock	6.3	6.3	6.3	6.3	2000.0
2010-06-16 08:00:00	AMZN	Stock	6.3	6.3	6.27	6.275	375500.0
2010-06-16 09:00:00	AMZN	Stock	6.275	6.384	6.2682	6.3765	11236680.0
2010-06-16 10:00:00	AMZN	Stock	6.3712	6.39	6.305	6.3575	18344260.0
2010-06-16 11:00:00	AMZN	Stock	6.3595	6.367	6.333	6.3435	6626440.0
2010-06-16 12:00:00	AMZN	Stock	6.3465	6.372	6.32	6.3377	5788260.0
2010-06-16 13:00:00	AMZN	Stock	6.3365	6.38	6.324	6.3786	8173280.0
2010-06-16 14:00:00	AMZN	Stock	6.3795	6.399	6.3725	6.389	7764320.0
2010-06-16 15:00:00	AMZN	Stock	6.3865	6.3865	6.3095	6.3445	18434120.0

> showing 50 of 42,500 rows — these rows as CSV

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