PREVIEW / stock_1hour / 2012-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-14.parquet
  size:    966 KB
  rows:    45,401
  symbols: 3,503

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-09-14 04:00:00	AAPL	Stock	24.475	24.5	24.475	24.5	44520.0
2012-09-14 05:00:00	AAPL	Stock	24.4929	24.5357	24.4911	24.5357	30800.0
2012-09-14 06:00:00	AAPL	Stock	24.5482	24.5482	24.5089	24.5429	110040.0
2012-09-14 07:00:00	AAPL	Stock	24.5536	24.5804	24.5268	24.5464	1501640.0
2012-09-14 08:00:00	AAPL	Stock	24.5393	24.6282	24.5357	24.5804	5845056.0
2012-09-14 09:00:00	AAPL	Stock	24.5871	24.8521	24.5675	24.7564	132400436.0
2012-09-14 10:00:00	AAPL	Stock	24.7559	24.8393	24.7229	24.815	89441184.0
2012-09-14 11:00:00	AAPL	Stock	24.8136	24.8864	24.7786	24.8354	70910336.0
2012-09-14 12:00:00	AAPL	Stock	24.8357	24.8921	24.8232	24.8571	42863744.0
2012-09-14 13:00:00	AAPL	Stock	24.8564	24.8649	24.6496	24.6718	69361068.0
2012-09-14 14:00:00	AAPL	Stock	24.6713	24.7982	24.6713	24.7846	56616980.0
2012-09-14 15:00:00	AAPL	Stock	24.7857	24.7939	24.6311	24.6871	90714036.0
2012-09-14 16:00:00	AAPL	Stock	24.6875	24.8097	24.3961	24.7039	24486168.0
2012-09-14 17:00:00	AAPL	Stock	24.7071	24.7379	24.7046	24.725	751072.0
2012-09-14 18:00:00	AAPL	Stock	24.725	24.7286	24.7157	24.7193	267316.0
2012-09-14 19:00:00	AAPL	Stock	24.7189	24.7589	24.7189	24.75	446852.0
2012-09-14 06:00:00	MSFT	Stock	31.06	31.12	31.06	31.12	1100.0
2012-09-14 07:00:00	MSFT	Stock	31.12	31.15	31.07	31.08	3700.0
2012-09-14 08:00:00	MSFT	Stock	31.05	31.15	30.97	31.09	152258.0
2012-09-14 09:00:00	MSFT	Stock	31.07	31.09	30.81	30.9	5630925.0
2012-09-14 10:00:00	MSFT	Stock	30.9	31.15	30.89	31.12	8258826.0
2012-09-14 11:00:00	MSFT	Stock	31.115	31.14	31.02	31.06	4741698.0
2012-09-14 12:00:00	MSFT	Stock	31.052	31.15	31.05	31.13	4021756.0
2012-09-14 13:00:00	MSFT	Stock	31.13	31.2	31.08	31.18	4336291.0
2012-09-14 14:00:00	MSFT	Stock	31.183	31.25	31.15	31.2	4721842.0
2012-09-14 15:00:00	MSFT	Stock	31.205	31.23	31.04	31.2	10659594.0
2012-09-14 16:00:00	MSFT	Stock	31.2	31.21	30.97	31.15	6222853.0
2012-09-14 17:00:00	MSFT	Stock	30.97	31.15	30.97	31.15	6795.0
2012-09-14 18:00:00	MSFT	Stock	31.15	31.15	31.14	31.15	28205.0
2012-09-14 08:00:00	NVDA	Stock	0.345	0.345	0.345	0.345	12000.0
2012-09-14 09:00:00	NVDA	Stock	0.345	0.352	0.3418	0.3508	63808880.0
2012-09-14 10:00:00	NVDA	Stock	0.3508	0.351	0.347	0.3471	46349120.0
2012-09-14 11:00:00	NVDA	Stock	0.347	0.3488	0.3462	0.3473	42173520.0
2012-09-14 12:00:00	NVDA	Stock	0.3475	0.3495	0.347	0.3485	36984040.0
2012-09-14 13:00:00	NVDA	Stock	0.3482	0.3488	0.3453	0.346	38678880.0
2012-09-14 14:00:00	NVDA	Stock	0.346	0.3461	0.3448	0.3456	34094640.0
2012-09-14 15:00:00	NVDA	Stock	0.3458	0.346	0.3438	0.346	58140120.0
2012-09-14 16:00:00	NVDA	Stock	0.346	0.3472	0.342	0.3453	4350760.0
2012-09-14 07:00:00	AMZN	Stock	13.1125	13.137	13.09	13.116	68000.0
2012-09-14 08:00:00	AMZN	Stock	13.1055	13.1055	13.016	13.0405	292620.0
2012-09-14 09:00:00	AMZN	Stock	13.05	13.155	13.0154	13.121	9906120.0
2012-09-14 10:00:00	AMZN	Stock	13.13	13.2055	13.08	13.1015	13857420.0
2012-09-14 11:00:00	AMZN	Stock	13.098	13.1045	12.9885	13.0245	11128620.0
2012-09-14 12:00:00	AMZN	Stock	13.0235	13.1295	13.015	13.0975	8144480.0
2012-09-14 13:00:00	AMZN	Stock	13.097	13.1175	13.05	13.085	4329100.0
2012-09-14 14:00:00	AMZN	Stock	13.0855	13.165	13.0815	13.156	5443300.0
2012-09-14 15:00:00	AMZN	Stock	13.157	13.1615	13.0235	13.0635	16055680.0
2012-09-14 16:00:00	AMZN	Stock	13.0635	13.1054	13.016	13.1054	3649060.0
2012-09-14 17:00:00	AMZN	Stock	13.016	13.065	13.016	13.0635	68000.0
2012-09-14 19:00:00	AMZN	Stock	13.079	13.08	13.079	13.08	7800.0

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

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