PREVIEW / stock_1hour / 2010-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-16.parquet
  size:    885 KB
  rows:    42,358
  symbols: 3,439

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
2010-07-16 05:00:00	AAPL	Stock	9.0214	9.0214	9.0214	9.0214	2800.0
2010-07-16 06:00:00	AAPL	Stock	9.0286	9.0357	9.0286	9.0357	39200.0
2010-07-16 07:00:00	AAPL	Stock	9.0307	9.0589	8.9929	9.0104	369348.0
2010-07-16 08:00:00	AAPL	Stock	9.0104	9.0643	8.9968	9.0286	2609740.0
2010-07-16 09:00:00	AAPL	Stock	9.0321	9.0571	8.9646	8.9925	131867400.0
2010-07-16 10:00:00	AAPL	Stock	8.9914	9.0111	8.9143	8.9411	115934364.0
2010-07-16 11:00:00	AAPL	Stock	8.9393	8.9561	8.8946	8.8946	71019704.0
2010-07-16 12:00:00	AAPL	Stock	8.8946	8.9464	8.8718	8.9274	78449504.0
2010-07-16 13:00:00	AAPL	Stock	8.928	9.1061	8.8829	8.9857	344731800.0
2010-07-16 14:00:00	AAPL	Stock	8.9844	9.0339	8.965	9.0147	98879396.0
2010-07-16 15:00:00	AAPL	Stock	9.0164	9.0232	8.9236	8.9236	154189504.0
2010-07-16 16:00:00	AAPL	Stock	8.9264	8.9784	8.9232	8.9268	27877164.0
2010-07-16 17:00:00	AAPL	Stock	8.9268	8.9286	8.925	8.9279	1569316.0
2010-07-16 18:00:00	AAPL	Stock	8.9264	8.9264	8.9107	8.9193	582148.0
2010-07-16 19:00:00	AAPL	Stock	8.9232	8.9304	8.9143	8.9304	396424.0
2010-07-16 20:00:00	AAPL	Stock	8.9186	8.9889	8.9186	8.9889	427000.0
2010-07-16 07:00:00	MSFT	Stock	25.65	25.65	25.52	25.6	1976.0
2010-07-16 08:00:00	MSFT	Stock	25.52	25.52	25.38	25.4	15000.0
2010-07-16 09:00:00	MSFT	Stock	25.41	25.64	25.19	25.19	6031503.0
2010-07-16 10:00:00	MSFT	Stock	25.19	25.25	24.98	25.04	11671236.0
2010-07-16 11:00:00	MSFT	Stock	25.045	25.06	24.93	24.98	6174393.0
2010-07-16 12:00:00	MSFT	Stock	24.98	25.04	24.88	24.97	4475515.0
2010-07-16 13:00:00	MSFT	Stock	24.969	25.04	24.91	25.025	5185551.0
2010-07-16 14:00:00	MSFT	Stock	25.025	25.05	24.97	24.99	4512595.0
2010-07-16 15:00:00	MSFT	Stock	24.99	25.02	24.88	24.91	14492416.0
2010-07-16 16:00:00	MSFT	Stock	24.91	25.1	24.83	24.9	4501870.0
2010-07-16 17:00:00	MSFT	Stock	25.51	25.51	24.9	24.95	6475.0
2010-07-16 18:00:00	MSFT	Stock	24.95	24.96	24.89	24.96	6775.0
2010-07-16 19:00:00	MSFT	Stock	24.95	24.95	24.9	24.91	7650.0
2010-07-16 08:00:00	NVDA	Stock	0.2688	0.2698	0.2675	0.2675	682000.0
2010-07-16 09:00:00	NVDA	Stock	0.2675	0.2688	0.258	0.2583	203441840.0
2010-07-16 10:00:00	NVDA	Stock	0.2583	0.2598	0.2572	0.2587	169558320.0
2010-07-16 11:00:00	NVDA	Stock	0.2586	0.2591	0.2547	0.255	171116320.0
2010-07-16 12:00:00	NVDA	Stock	0.2549	0.256	0.2538	0.2539	203188560.0
2010-07-16 13:00:00	NVDA	Stock	0.2538	0.2563	0.253	0.2535	129189600.0
2010-07-16 14:00:00	NVDA	Stock	0.2535	0.2545	0.253	0.2533	80853520.0
2010-07-16 15:00:00	NVDA	Stock	0.2534	0.255	0.2503	0.251	304990400.0
2010-07-16 16:00:00	NVDA	Stock	0.2515	0.256	0.2505	0.252	19222120.0
2010-07-16 17:00:00	NVDA	Stock	0.268	0.268	0.2518	0.254	2357960.0
2010-07-16 18:00:00	NVDA	Stock	0.2538	0.2545	0.2527	0.254	830680.0
2010-07-16 19:00:00	NVDA	Stock	0.254	0.2545	0.2535	0.2538	876000.0
2010-07-16 20:00:00	NVDA	Stock	0.2523	0.2523	0.2523	0.2523	152000.0
2010-07-16 07:00:00	AMZN	Stock	6.0425	6.0425	6.0425	6.0425	2000.0
2010-07-16 08:00:00	AMZN	Stock	6.0685	6.0855	6.0685	6.07	18000.0
2010-07-16 09:00:00	AMZN	Stock	6.0555	6.096	6.0205	6.0425	19390180.0
2010-07-16 10:00:00	AMZN	Stock	6.0435	6.0575	5.9845	5.9985	18239540.0
2010-07-16 11:00:00	AMZN	Stock	5.998	6.0075	5.965	5.9696	12398560.0
2010-07-16 12:00:00	AMZN	Stock	5.9655	5.979	5.9275	5.9325	14260160.0
2010-07-16 13:00:00	AMZN	Stock	5.9325	5.965	5.9155	5.921	11434560.0
2010-07-16 14:00:00	AMZN	Stock	5.9205	5.928	5.905	5.9185	11166500.0

> showing 50 of 42,358 rows — these rows as CSV

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