PREVIEW / stock_1hour / 2012-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-11.parquet
  size:    920 KB
  rows:    43,545
  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-11 04:00:00	AAPL	Stock	22.9339	23.0	22.9286	22.9957	57092.0
2012-10-11 05:00:00	AAPL	Stock	23.0139	23.0179	23.0036	23.0179	48664.0
2012-10-11 06:00:00	AAPL	Stock	23.0357	23.0357	23.0354	23.0357	15400.0
2012-10-11 07:00:00	AAPL	Stock	23.0179	23.0571	22.9896	23.0257	797244.0
2012-10-11 08:00:00	AAPL	Stock	23.0161	23.0714	22.9821	23.0593	2707264.0
2012-10-11 09:00:00	AAPL	Stock	23.0575	23.1143	22.9289	22.9664	63492716.0
2012-10-11 10:00:00	AAPL	Stock	22.9654	23.0104	22.8632	22.8789	69490260.0
2012-10-11 11:00:00	AAPL	Stock	22.8804	22.8811	22.5586	22.6812	111029884.0
2012-10-11 12:00:00	AAPL	Stock	22.6789	22.7214	22.5736	22.6084	47262124.0
2012-10-11 13:00:00	AAPL	Stock	22.608	22.6739	22.4932	22.5125	65092860.0
2012-10-11 14:00:00	AAPL	Stock	22.5132	22.6361	22.5099	22.5414	50279208.0
2012-10-11 15:00:00	AAPL	Stock	22.5425	22.6132	22.4321	22.4321	100908864.0
2012-10-11 16:00:00	AAPL	Stock	22.4321	22.706	22.4	22.4536	12643848.0
2012-10-11 17:00:00	AAPL	Stock	22.4486	22.4696	22.4411	22.4643	393764.0
2012-10-11 18:00:00	AAPL	Stock	22.4575	22.4643	22.4518	22.4536	114548.0
2012-10-11 19:00:00	AAPL	Stock	22.4571	22.4732	22.445	22.4732	309288.0
2012-10-11 06:00:00	MSFT	Stock	29.1	29.1	29.1	29.1	1000.0
2012-10-11 07:00:00	MSFT	Stock	29.15	29.15	29.0	29.08	17938.0
2012-10-11 08:00:00	MSFT	Stock	29.08	29.12	29.04	29.11	70669.0
2012-10-11 09:00:00	MSFT	Stock	29.11	29.28	29.0	29.065	6795924.0
2012-10-11 10:00:00	MSFT	Stock	29.06	29.16	29.02	29.115	6851787.0
2012-10-11 11:00:00	MSFT	Stock	29.115	29.13	28.98	29.01	5221800.0
2012-10-11 12:00:00	MSFT	Stock	29.015	29.06	28.98	29.03	2682269.0
2012-10-11 13:00:00	MSFT	Stock	29.026	29.06	28.9	28.93	4017028.0
2012-10-11 14:00:00	MSFT	Stock	28.925	28.97	28.87	28.902	4950418.0
2012-10-11 15:00:00	MSFT	Stock	28.9	29.05	28.9	28.955	7953280.0
2012-10-11 16:00:00	MSFT	Stock	28.95	29.04	28.88	29.022	1414054.0
2012-10-11 17:00:00	MSFT	Stock	28.97	28.97	28.96	28.97	3426.0
2012-10-11 18:00:00	MSFT	Stock	28.97	28.99	28.97	28.99	7550.0
2012-10-11 19:00:00	MSFT	Stock	28.96	28.99	28.95	28.95	2351.0
2012-10-11 08:00:00	NVDA	Stock	0.3203	0.3203	0.3203	0.3203	8000.0
2012-10-11 09:00:00	NVDA	Stock	0.3203	0.3203	0.3175	0.32	52020320.0
2012-10-11 10:00:00	NVDA	Stock	0.3198	0.3208	0.3178	0.3188	90634400.0
2012-10-11 11:00:00	NVDA	Stock	0.3188	0.3193	0.316	0.318	48902120.0
2012-10-11 12:00:00	NVDA	Stock	0.318	0.32	0.3178	0.3193	31989840.0
2012-10-11 13:00:00	NVDA	Stock	0.3194	0.3205	0.318	0.3185	24210920.0
2012-10-11 14:00:00	NVDA	Stock	0.3185	0.3199	0.3183	0.3183	21589960.0
2012-10-11 15:00:00	NVDA	Stock	0.3184	0.3198	0.318	0.3185	40190600.0
2012-10-11 16:00:00	NVDA	Stock	0.3185	0.3198	0.3163	0.3163	10387160.0
2012-10-11 17:00:00	NVDA	Stock	0.3183	0.3185	0.3163	0.3163	64000.0
2012-10-11 19:00:00	NVDA	Stock	0.3168	0.3185	0.3168	0.3185	42000.0
2012-10-11 07:00:00	AMZN	Stock	12.325	12.325	12.325	12.325	6000.0
2012-10-11 08:00:00	AMZN	Stock	12.325	12.381	12.3015	12.371	290020.0
2012-10-11 09:00:00	AMZN	Stock	12.375	12.465	12.32	12.337	10761560.0
2012-10-11 10:00:00	AMZN	Stock	12.3369	12.3525	12.2175	12.224	12456340.0
2012-10-11 11:00:00	AMZN	Stock	12.226	12.281	12.1841	12.228	8650140.0
2012-10-11 12:00:00	AMZN	Stock	12.225	12.2495	12.185	12.1925	5685040.0
2012-10-11 13:00:00	AMZN	Stock	12.1905	12.21	12.0945	12.1075	7704520.0
2012-10-11 14:00:00	AMZN	Stock	12.1075	12.211	12.105	12.2	8704940.0
2012-10-11 15:00:00	AMZN	Stock	12.2	12.256	12.176	12.2145	11047080.0

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

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