PREVIEW / stock_1hour / 2011-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-04.parquet
  size:    953 KB
  rows:    45,503
  symbols: 3,517

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
2011-10-04 04:00:00	AAPL	Stock	13.3504	13.3504	13.3504	13.3504	5600.0
2011-10-04 06:00:00	AAPL	Stock	13.3932	13.3964	13.3793	13.3821	72800.0
2011-10-04 07:00:00	AAPL	Stock	13.3725	13.4214	13.3286	13.3446	784784.0
2011-10-04 08:00:00	AAPL	Stock	13.3636	13.4125	13.2943	13.4107	3655372.0
2011-10-04 09:00:00	AAPL	Stock	13.4146	13.5179	13.2689	13.3321	99480808.0
2011-10-04 10:00:00	AAPL	Stock	13.3254	13.4532	13.225	13.4311	117350688.0
2011-10-04 11:00:00	AAPL	Stock	13.431	13.5607	13.3929	13.5354	80796128.0
2011-10-04 12:00:00	AAPL	Stock	13.5357	13.6357	13.4446	13.4714	83900348.0
2011-10-04 13:00:00	AAPL	Stock	13.4686	13.5125	13.1625	13.2118	170874816.0
2011-10-04 14:00:00	AAPL	Stock	13.2046	13.2457	12.825	12.8476	329859432.0
2011-10-04 15:00:00	AAPL	Stock	12.8414	13.3304	12.6514	13.3064	321232100.0
2011-10-04 16:00:00	AAPL	Stock	13.294	13.3786	12.8659	13.2804	18337480.0
2011-10-04 17:00:00	AAPL	Stock	13.28	13.3143	13.2693	13.3054	1234548.0
2011-10-04 18:00:00	AAPL	Stock	13.3036	13.3114	13.2861	13.3114	469952.0
2011-10-04 19:00:00	AAPL	Stock	13.3107	13.3357	13.3032	13.3118	486724.0
2011-10-04 04:00:00	MSFT	Stock	24.27	24.27	24.27	24.27	100.0
2011-10-04 06:00:00	MSFT	Stock	24.33	24.33	24.26	24.26	8500.0
2011-10-04 07:00:00	MSFT	Stock	24.25	24.31	24.22	24.22	25327.0
2011-10-04 08:00:00	MSFT	Stock	24.29	24.35	24.22	24.31	44367.0
2011-10-04 09:00:00	MSFT	Stock	24.3	24.61	24.23	24.54	8832999.0
2011-10-04 10:00:00	MSFT	Stock	24.54	24.81	24.44	24.69	14453175.0
2011-10-04 11:00:00	MSFT	Stock	24.69	24.88	24.56	24.83	8776717.0
2011-10-04 12:00:00	MSFT	Stock	24.83	25.02	24.73	24.85	7559357.0
2011-10-04 13:00:00	MSFT	Stock	24.85	24.89	24.565	24.6	5237203.0
2011-10-04 14:00:00	MSFT	Stock	24.595	24.76	24.48	24.501	9788827.0
2011-10-04 15:00:00	MSFT	Stock	24.51	25.39	24.46	25.34	20451210.0
2011-10-04 16:00:00	MSFT	Stock	25.35	25.37	24.53	25.27	4922341.0
2011-10-04 17:00:00	MSFT	Stock	25.27	25.3	25.27	25.28	2621.0
2011-10-04 18:00:00	MSFT	Stock	25.34	25.34	25.29	25.29	31540.0
2011-10-04 19:00:00	MSFT	Stock	25.3	25.33	25.3	25.3	11319.0
2011-10-04 08:00:00	NVDA	Stock	0.2932	0.2932	0.2855	0.2918	804080.0
2011-10-04 09:00:00	NVDA	Stock	0.2922	0.2972	0.2868	0.2968	115152520.0
2011-10-04 10:00:00	NVDA	Stock	0.2965	0.317	0.2942	0.3163	308939200.0
2011-10-04 11:00:00	NVDA	Stock	0.3163	0.3198	0.3103	0.313	166836800.0
2011-10-04 12:00:00	NVDA	Stock	0.313	0.319	0.313	0.3163	98682840.0
2011-10-04 13:00:00	NVDA	Stock	0.316	0.3168	0.3059	0.3065	152745240.0
2011-10-04 14:00:00	NVDA	Stock	0.3068	0.3087	0.3018	0.3025	177632040.0
2011-10-04 15:00:00	NVDA	Stock	0.3022	0.3225	0.3018	0.3225	297798720.0
2011-10-04 16:00:00	NVDA	Stock	0.322	0.323	0.2952	0.3223	12395720.0
2011-10-04 17:00:00	NVDA	Stock	0.3225	0.324	0.3215	0.324	140000.0
2011-10-04 18:00:00	NVDA	Stock	0.3225	0.3225	0.3215	0.3225	465320.0
2011-10-04 19:00:00	NVDA	Stock	0.3225	0.3225	0.3213	0.3225	156800.0
2011-10-04 07:00:00	AMZN	Stock	10.459	10.463	10.4375	10.45	64000.0
2011-10-04 08:00:00	AMZN	Stock	10.4625	10.497	10.386	10.497	566800.0
2011-10-04 09:00:00	AMZN	Stock	10.4985	10.542	10.0215	10.1855	35160660.0
2011-10-04 10:00:00	AMZN	Stock	10.174	10.3765	10.1	10.337	35740920.0
2011-10-04 11:00:00	AMZN	Stock	10.3415	10.4625	10.2676	10.3845	20938060.0
2011-10-04 12:00:00	AMZN	Stock	10.3825	10.5185	10.35	10.375	10570540.0
2011-10-04 13:00:00	AMZN	Stock	10.3665	10.405	10.2515	10.2925	12182400.0
2011-10-04 14:00:00	AMZN	Stock	10.2875	10.3375	10.125	10.1377	18193480.0

> showing 50 of 45,503 rows — these rows as CSV

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