PREVIEW / stock_1hour / 2012-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-26.parquet
  size:    911 KB
  rows:    43,202
  symbols: 3,465

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-10-26 04:00:00	AAPL	Stock	21.7143	21.8393	21.6429	21.7857	589848.0
2012-10-26 05:00:00	AAPL	Stock	21.7889	21.7889	21.7164	21.7729	310968.0
2012-10-26 06:00:00	AAPL	Stock	21.75	21.7504	21.7325	21.7446	152236.0
2012-10-26 07:00:00	AAPL	Stock	21.7446	21.8746	21.7189	21.8571	3617572.0
2012-10-26 08:00:00	AAPL	Stock	21.8236	21.8718	21.7325	21.8143	20314672.0
2012-10-26 09:00:00	AAPL	Stock	21.8096	21.9286	21.5604	21.7332	188187972.0
2012-10-26 10:00:00	AAPL	Stock	21.7332	21.8443	21.5614	21.5679	104256376.0
2012-10-26 11:00:00	AAPL	Stock	21.5632	21.5725	21.2857	21.3382	136450664.0
2012-10-26 12:00:00	AAPL	Stock	21.3325	21.3368	21.1071	21.3304	157639692.0
2012-10-26 13:00:00	AAPL	Stock	21.3307	21.6704	21.2768	21.6368	119602224.0
2012-10-26 14:00:00	AAPL	Stock	21.6368	21.7932	21.5646	21.6911	129372320.0
2012-10-26 15:00:00	AAPL	Stock	21.6911	21.7661	21.5343	21.5704	120491868.0
2012-10-26 16:00:00	AAPL	Stock	21.5714	21.7945	21.5029	21.5625	17654868.0
2012-10-26 17:00:00	AAPL	Stock	21.5629	21.5689	21.5482	21.5643	736176.0
2012-10-26 18:00:00	AAPL	Stock	21.5643	21.5643	21.5464	21.5571	129192.0
2012-10-26 19:00:00	AAPL	Stock	21.5468	21.5632	21.5461	21.5486	224924.0
2012-10-26 04:00:00	MSFT	Stock	27.75	27.75	27.75	27.75	497.0
2012-10-26 06:00:00	MSFT	Stock	27.75	27.75	27.75	27.75	247.0
2012-10-26 07:00:00	MSFT	Stock	27.76	27.82	27.75	27.8	8685.0
2012-10-26 08:00:00	MSFT	Stock	27.79	28.0	27.74	27.88	100049.0
2012-10-26 09:00:00	MSFT	Stock	27.93	28.05	27.76	27.96	6598213.0
2012-10-26 10:00:00	MSFT	Stock	27.97	28.05	27.92	27.98	7698324.0
2012-10-26 11:00:00	MSFT	Stock	27.98	28.12	27.95	28.01	5694467.0
2012-10-26 12:00:00	MSFT	Stock	28.01	28.06	27.95	28.059	6365428.0
2012-10-26 13:00:00	MSFT	Stock	28.05	28.09	27.95	28.05	5535965.0
2012-10-26 14:00:00	MSFT	Stock	28.05	28.18	28.0	28.18	7603305.0
2012-10-26 15:00:00	MSFT	Stock	28.17	28.34	28.16	28.2	12472113.0
2012-10-26 16:00:00	MSFT	Stock	28.21	28.304	27.9	28.23	4753110.0
2012-10-26 17:00:00	MSFT	Stock	28.22	28.27	28.22	28.25	3888.0
2012-10-26 18:00:00	MSFT	Stock	28.24	28.26	28.24	28.25	3878.0
2012-10-26 19:00:00	MSFT	Stock	28.26	28.26	28.25	28.25	7879.0
2012-10-26 08:00:00	NVDA	Stock	0.303	0.3038	0.3025	0.3038	217440.0
2012-10-26 09:00:00	NVDA	Stock	0.305	0.3068	0.3015	0.3015	46225400.0
2012-10-26 10:00:00	NVDA	Stock	0.3018	0.3048	0.3016	0.3032	46642000.0
2012-10-26 11:00:00	NVDA	Stock	0.303	0.3049	0.3025	0.3032	40519760.0
2012-10-26 12:00:00	NVDA	Stock	0.3034	0.3048	0.3022	0.3047	23070200.0
2012-10-26 13:00:00	NVDA	Stock	0.3045	0.3046	0.302	0.3021	50218760.0
2012-10-26 14:00:00	NVDA	Stock	0.3022	0.303	0.302	0.3025	38896320.0
2012-10-26 15:00:00	NVDA	Stock	0.3024	0.303	0.3012	0.3015	120141480.0
2012-10-26 16:00:00	NVDA	Stock	0.3018	0.3043	0.3012	0.302	6888720.0
2012-10-26 17:00:00	NVDA	Stock	0.3012	0.3012	0.3012	0.3012	28000.0
2012-10-26 18:00:00	NVDA	Stock	0.3022	0.3022	0.3022	0.3022	4000.0
2012-10-26 19:00:00	NVDA	Stock	0.3022	0.3022	0.3022	0.3022	4000.0
2012-10-26 04:00:00	AMZN	Stock	10.905	10.905	10.9025	10.9025	4000.0
2012-10-26 05:00:00	AMZN	Stock	10.9465	11.05	10.9465	11.05	39320.0
2012-10-26 06:00:00	AMZN	Stock	11.035	11.0845	10.9735	10.9735	136080.0
2012-10-26 07:00:00	AMZN	Stock	10.9935	11.294	10.977	11.28	769580.0
2012-10-26 08:00:00	AMZN	Stock	11.28	11.4605	11.225	11.4125	5122240.0
2012-10-26 09:00:00	AMZN	Stock	11.4125	11.707	11.3775	11.6185	56269480.0
2012-10-26 10:00:00	AMZN	Stock	11.6225	11.64	11.407	11.4155	37499500.0

> showing 50 of 43,202 rows — these rows as CSV

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