PREVIEW / stock_1hour / 2010-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-30.parquet
  size:    921 KB
  rows:    43,677
  symbols: 3,532

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-12-30 04:00:00	AAPL	Stock	11.6286	11.6425	11.6286	11.6425	11200.0
2010-12-30 05:00:00	AAPL	Stock	11.6239	11.6239	11.6239	11.6239	2800.0
2010-12-30 06:00:00	AAPL	Stock	11.6239	11.6239	11.6136	11.6136	14000.0
2010-12-30 07:00:00	AAPL	Stock	11.6139	11.6175	11.6075	11.6075	22400.0
2010-12-30 08:00:00	AAPL	Stock	11.6114	11.6318	11.6107	11.625	1101800.0
2010-12-30 09:00:00	AAPL	Stock	11.6246	11.6318	11.5757	11.5796	22274840.0
2010-12-30 10:00:00	AAPL	Stock	11.5779	11.5821	11.554	11.5696	35786968.0
2010-12-30 11:00:00	AAPL	Stock	11.5696	11.5739	11.5461	11.5511	18545660.0
2010-12-30 12:00:00	AAPL	Stock	11.5507	11.5604	11.5429	11.5432	11770584.0
2010-12-30 13:00:00	AAPL	Stock	11.5439	11.5561	11.5375	11.5532	12999700.0
2010-12-30 14:00:00	AAPL	Stock	11.5535	11.5721	11.5464	11.5693	14485100.0
2010-12-30 15:00:00	AAPL	Stock	11.57	11.58	11.5514	11.5593	31560704.0
2010-12-30 16:00:00	AAPL	Stock	11.5593	11.6293	11.5525	11.6293	6762588.0
2010-12-30 17:00:00	AAPL	Stock	11.5561	11.5589	11.5561	11.5586	21420.0
2010-12-30 18:00:00	AAPL	Stock	11.5571	11.5593	11.5571	11.5589	144732.0
2010-12-30 19:00:00	AAPL	Stock	11.5586	11.5593	11.5571	11.5571	96068.0
2010-12-30 07:00:00	MSFT	Stock	27.98	28.09	27.95	28.09	1700.0
2010-12-30 08:00:00	MSFT	Stock	28.04	28.04	28.04	28.04	2124.0
2010-12-30 09:00:00	MSFT	Stock	28.0	28.0	27.9	27.925	2184158.0
2010-12-30 10:00:00	MSFT	Stock	27.93	27.94	27.86	27.86	3762559.0
2010-12-30 11:00:00	MSFT	Stock	27.86	27.88	27.78	27.81	2547144.0
2010-12-30 12:00:00	MSFT	Stock	27.815	27.83	27.775	27.802	2335425.0
2010-12-30 13:00:00	MSFT	Stock	27.8	27.83	27.785	27.82	2059270.0
2010-12-30 14:00:00	MSFT	Stock	27.825	27.87	27.82	27.86	2322857.0
2010-12-30 15:00:00	MSFT	Stock	27.86	27.91	27.845	27.865	4105407.0
2010-12-30 16:00:00	MSFT	Stock	27.85	27.91	27.84	27.855	904620.0
2010-12-30 17:00:00	MSFT	Stock	27.85	27.86	27.84	27.84	1600.0
2010-12-30 18:00:00	MSFT	Stock	27.85	28.05	27.85	28.05	9910.0
2010-12-30 19:00:00	MSFT	Stock	27.84	27.85	27.84	27.84	3637.0
2010-12-30 08:00:00	NVDA	Stock	0.3748	0.375	0.3748	0.375	12800.0
2010-12-30 09:00:00	NVDA	Stock	0.3735	0.3743	0.3718	0.3733	17365080.0
2010-12-30 10:00:00	NVDA	Stock	0.3735	0.3738	0.3725	0.3728	17750760.0
2010-12-30 11:00:00	NVDA	Stock	0.3728	0.3748	0.3725	0.3746	25743960.0
2010-12-30 12:00:00	NVDA	Stock	0.3748	0.3763	0.3745	0.376	13292200.0
2010-12-30 13:00:00	NVDA	Stock	0.3761	0.377	0.3758	0.376	32206400.0
2010-12-30 14:00:00	NVDA	Stock	0.3758	0.3763	0.3748	0.3753	22532320.0
2010-12-30 15:00:00	NVDA	Stock	0.3753	0.3763	0.3745	0.375	34529280.0
2010-12-30 16:00:00	NVDA	Stock	0.3748	0.3758	0.3738	0.3758	597200.0
2010-12-30 17:00:00	NVDA	Stock	0.3748	0.3748	0.3748	0.3748	16000.0
2010-12-30 18:00:00	NVDA	Stock	0.3748	0.3748	0.3748	0.3748	8000.0
2010-12-30 08:00:00	AMZN	Stock	9.1925	9.199	9.1915	9.1925	38720.0
2010-12-30 09:00:00	AMZN	Stock	9.192	9.2275	9.1385	9.176	7683420.0
2010-12-30 10:00:00	AMZN	Stock	9.1795	9.1925	9.15	9.1565	6677740.0
2010-12-30 11:00:00	AMZN	Stock	9.1565	9.1745	9.1515	9.1595	4288120.0
2010-12-30 12:00:00	AMZN	Stock	9.161	9.167	9.1505	9.152	2997620.0
2010-12-30 13:00:00	AMZN	Stock	9.1535	9.169	9.1435	9.166	2676720.0
2010-12-30 14:00:00	AMZN	Stock	9.1655	9.171	9.1505	9.153	3267940.0
2010-12-30 15:00:00	AMZN	Stock	9.1525	9.174	9.138	9.138	9827080.0
2010-12-30 16:00:00	AMZN	Stock	9.1375	9.1651	9.1375	9.1612	1645060.0
2010-12-30 17:00:00	AMZN	Stock	9.144	9.144	9.127	9.127	39100.0

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

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