PREVIEW / stock_1hour / 2012-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-03.parquet
  size:    958 KB
  rows:    45,742
  symbols: 3,541

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-05-03 04:00:00	AAPL	Stock	20.9546	20.9821	20.9546	20.9643	58100.0
2012-05-03 05:00:00	AAPL	Stock	20.9639	20.9639	20.9464	20.9464	27580.0
2012-05-03 06:00:00	AAPL	Stock	20.9468	20.9468	20.9464	20.9464	11200.0
2012-05-03 07:00:00	AAPL	Stock	20.9643	21.0354	20.9461	20.9825	304472.0
2012-05-03 08:00:00	AAPL	Stock	20.9861	21.0536	20.9282	21.0243	4403840.0
2012-05-03 09:00:00	AAPL	Stock	21.0196	21.1214	20.9911	21.02	65145164.0
2012-05-03 10:00:00	AAPL	Stock	21.02	21.0357	20.9243	21.0357	66285100.0
2012-05-03 11:00:00	AAPL	Stock	21.0336	21.0357	20.8686	20.8789	45425492.0
2012-05-03 12:00:00	AAPL	Stock	20.8764	20.9282	20.8086	20.8743	45380580.0
2012-05-03 13:00:00	AAPL	Stock	20.8743	20.8904	20.7596	20.7596	40312496.0
2012-05-03 14:00:00	AAPL	Stock	20.7607	20.8036	20.725	20.765	42774508.0
2012-05-03 15:00:00	AAPL	Stock	20.7693	20.8371	20.7289	20.7765	54612152.0
2012-05-03 16:00:00	AAPL	Stock	20.7793	20.9818	20.7468	20.7471	18766076.0
2012-05-03 17:00:00	AAPL	Stock	20.7793	20.7793	20.7325	20.7446	555968.0
2012-05-03 18:00:00	AAPL	Stock	20.7429	20.7589	20.7325	20.7325	217532.0
2012-05-03 19:00:00	AAPL	Stock	20.7414	20.7461	20.7254	20.7254	320180.0
2012-05-03 08:00:00	MSFT	Stock	31.83	31.9	31.83	31.85	10075.0
2012-05-03 09:00:00	MSFT	Stock	31.85	31.88	31.7	31.77	2724070.0
2012-05-03 10:00:00	MSFT	Stock	31.76	31.9	31.689	31.85	4827095.0
2012-05-03 11:00:00	MSFT	Stock	31.855	31.87	31.66	31.74	3831403.0
2012-05-03 12:00:00	MSFT	Stock	31.735	31.83	31.67	31.75	3011836.0
2012-05-03 13:00:00	MSFT	Stock	31.75	31.78	31.62	31.669	2913347.0
2012-05-03 14:00:00	MSFT	Stock	31.66	31.74	31.63	31.667	3069532.0
2012-05-03 15:00:00	MSFT	Stock	31.66	31.78	31.61	31.76	8716610.0
2012-05-03 16:00:00	MSFT	Stock	31.75	31.78	31.66	31.69	2030630.0
2012-05-03 17:00:00	MSFT	Stock	31.76	31.76	31.66	31.66	63665.0
2012-05-03 18:00:00	MSFT	Stock	31.69	31.69	31.69	31.69	1670.0
2012-05-03 19:00:00	MSFT	Stock	31.66	31.72	31.66	31.68	1361.0
2012-05-03 08:00:00	NVDA	Stock	0.3225	0.323	0.3225	0.323	27280.0
2012-05-03 09:00:00	NVDA	Stock	0.322	0.3239	0.32	0.3221	31445160.0
2012-05-03 10:00:00	NVDA	Stock	0.322	0.322	0.3183	0.3198	48365560.0
2012-05-03 11:00:00	NVDA	Stock	0.3198	0.32	0.3145	0.3158	67540960.0
2012-05-03 12:00:00	NVDA	Stock	0.3159	0.316	0.314	0.3155	51245840.0
2012-05-03 13:00:00	NVDA	Stock	0.3155	0.3165	0.3145	0.3154	47947560.0
2012-05-03 14:00:00	NVDA	Stock	0.3155	0.3163	0.3145	0.3149	37737640.0
2012-05-03 15:00:00	NVDA	Stock	0.3148	0.3173	0.3138	0.3156	120246040.0
2012-05-03 16:00:00	NVDA	Stock	0.3158	0.3188	0.3138	0.3138	4962120.0
2012-05-03 17:00:00	NVDA	Stock	0.3158	0.3163	0.3158	0.3158	1269480.0
2012-05-03 19:00:00	NVDA	Stock	0.3168	0.3168	0.3168	0.3168	28000.0
2012-05-03 07:00:00	AMZN	Stock	11.5	11.5	11.5	11.5	2000.0
2012-05-03 08:00:00	AMZN	Stock	11.526	11.54	11.485	11.5045	142200.0
2012-05-03 09:00:00	AMZN	Stock	11.51	11.512	11.4155	11.453	8307500.0
2012-05-03 10:00:00	AMZN	Stock	11.46	11.6105	11.435	11.599	16733940.0
2012-05-03 11:00:00	AMZN	Stock	11.5975	11.6265	11.5	11.512	15350720.0
2012-05-03 12:00:00	AMZN	Stock	11.5168	11.522	11.457	11.5085	8478920.0
2012-05-03 13:00:00	AMZN	Stock	11.5085	11.5165	11.4015	11.41	9667480.0
2012-05-03 14:00:00	AMZN	Stock	11.4125	11.465	11.409	11.4266	8442340.0
2012-05-03 15:00:00	AMZN	Stock	11.4263	11.5111	11.4263	11.4725	11145280.0
2012-05-03 16:00:00	AMZN	Stock	11.4725	11.5	11.447	11.4585	1984800.0
2012-05-03 17:00:00	AMZN	Stock	11.4725	11.4725	11.4635	11.4635	68500.0

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

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