PREVIEW / stock_1hour / 2012-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-01.parquet
  size:    961 KB
  rows:    46,356
  symbols: 3,534

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
2012-06-01 04:00:00	AAPL	Stock	20.5536	20.5536	20.5143	20.5393	103600.0
2012-06-01 05:00:00	AAPL	Stock	20.5179	20.5179	20.4643	20.4643	58296.0
2012-06-01 06:00:00	AAPL	Stock	20.4329	20.4607	20.4286	20.4357	39200.0
2012-06-01 07:00:00	AAPL	Stock	20.4357	20.4739	20.4018	20.4511	376376.0
2012-06-01 08:00:00	AAPL	Stock	20.4268	20.4867	20.2911	20.3532	6593048.0
2012-06-01 09:00:00	AAPL	Stock	20.3536	20.4071	20.2575	20.3636	75112464.0
2012-06-01 10:00:00	AAPL	Stock	20.3721	20.4518	20.2882	20.3229	86238488.0
2012-06-01 11:00:00	AAPL	Stock	20.3236	20.33	20.2021	20.2266	59049368.0
2012-06-01 12:00:00	AAPL	Stock	20.2266	20.2811	20.2143	20.2214	39486776.0
2012-06-01 13:00:00	AAPL	Stock	20.2214	20.2314	20.1	20.1468	58111900.0
2012-06-01 14:00:00	AAPL	Stock	20.1493	20.1511	20.0186	20.0911	73522792.0
2012-06-01 15:00:00	AAPL	Stock	20.0929	20.1379	20.0196	20.0379	95994528.0
2012-06-01 16:00:00	AAPL	Stock	20.0375	20.2118	20.0314	20.0396	17334156.0
2012-06-01 17:00:00	AAPL	Stock	20.0464	20.0643	20.0354	20.0511	1005704.0
2012-06-01 18:00:00	AAPL	Stock	20.0518	20.0536	20.04	20.0407	130228.0
2012-06-01 19:00:00	AAPL	Stock	20.0407	20.05	20.0361	20.04	267064.0
2012-06-01 05:00:00	MSFT	Stock	29.0	29.0	29.0	29.0	100.0
2012-06-01 06:00:00	MSFT	Stock	28.92	28.92	28.92	28.92	1000.0
2012-06-01 07:00:00	MSFT	Stock	28.95	28.95	28.95	28.95	100.0
2012-06-01 08:00:00	MSFT	Stock	29.0	29.01	28.51	28.76	121833.0
2012-06-01 09:00:00	MSFT	Stock	28.72	28.96	28.64	28.84	6224390.0
2012-06-01 10:00:00	MSFT	Stock	28.83	28.93	28.59	28.685	6818102.0
2012-06-01 11:00:00	MSFT	Stock	28.69	28.78	28.63	28.705	5435965.0
2012-06-01 12:00:00	MSFT	Stock	28.7	28.79	28.62	28.62	4033658.0
2012-06-01 13:00:00	MSFT	Stock	28.625	28.7	28.52	28.56	6363663.0
2012-06-01 14:00:00	MSFT	Stock	28.56	28.66	28.55	28.585	6307574.0
2012-06-01 15:00:00	MSFT	Stock	28.58	28.67	28.44	28.44	13119771.0
2012-06-01 16:00:00	MSFT	Stock	28.45	28.69	28.39	28.45	5639403.0
2012-06-01 17:00:00	MSFT	Stock	28.45	28.45	28.36	28.38	206080.0
2012-06-01 18:00:00	MSFT	Stock	28.38	28.42	28.37	28.39	7671.0
2012-06-01 19:00:00	MSFT	Stock	28.4	28.41	28.39	28.39	2650.0
2012-06-01 08:00:00	NVDA	Stock	0.3108	0.3108	0.3038	0.3075	292400.0
2012-06-01 09:00:00	NVDA	Stock	0.304	0.3064	0.3018	0.306	48773920.0
2012-06-01 10:00:00	NVDA	Stock	0.306	0.3065	0.3035	0.3058	77963160.0
2012-06-01 11:00:00	NVDA	Stock	0.3055	0.3073	0.3045	0.3065	45745880.0
2012-06-01 12:00:00	NVDA	Stock	0.3065	0.3065	0.3028	0.3031	45438600.0
2012-06-01 13:00:00	NVDA	Stock	0.303	0.3036	0.3005	0.3006	43158560.0
2012-06-01 14:00:00	NVDA	Stock	0.3008	0.3022	0.299	0.2998	78411320.0
2012-06-01 15:00:00	NVDA	Stock	0.3	0.3005	0.2991	0.2992	83877680.0
2012-06-01 16:00:00	NVDA	Stock	0.2992	0.3029	0.2992	0.3002	16096680.0
2012-06-01 17:00:00	NVDA	Stock	0.2995	0.3012	0.2995	0.3	535640.0
2012-06-01 18:00:00	NVDA	Stock	0.3018	0.3028	0.3	0.3008	100000.0
2012-06-01 19:00:00	NVDA	Stock	0.3002	0.301	0.3002	0.3005	16000.0
2012-06-01 05:00:00	AMZN	Stock	10.5225	10.5225	10.5225	10.5225	2000.0
2012-06-01 07:00:00	AMZN	Stock	10.5225	10.5225	10.5225	10.5225	2000.0
2012-06-01 08:00:00	AMZN	Stock	10.6455	10.6455	10.385	10.4	950620.0
2012-06-01 09:00:00	AMZN	Stock	10.419	10.5615	10.3975	10.4988	11372680.0
2012-06-01 10:00:00	AMZN	Stock	10.5	10.527	10.423	10.475	14538760.0
2012-06-01 11:00:00	AMZN	Stock	10.4736	10.526	10.4439	10.4785	9355340.0
2012-06-01 12:00:00	AMZN	Stock	10.4775	10.4865	10.428	10.4345	6005760.0

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

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