PREVIEW / stock_1hour / 2010-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-17.parquet
  size:    927 KB
  rows:    43,907
  symbols: 3,492

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-09-17 04:00:00	AAPL	Stock	9.9454	9.9454	9.9286	9.9286	8400.0
2010-09-17 05:00:00	AAPL	Stock	9.9554	9.9554	9.9096	9.9096	57120.0
2010-09-17 06:00:00	AAPL	Stock	9.9107	9.9107	9.8893	9.9104	44800.0
2010-09-17 07:00:00	AAPL	Stock	9.9143	9.9464	9.8775	9.9004	564900.0
2010-09-17 08:00:00	AAPL	Stock	9.8932	9.9393	9.8768	9.9157	5756940.0
2010-09-17 09:00:00	AAPL	Stock	9.9157	9.9271	9.7743	9.7875	143047604.0
2010-09-17 10:00:00	AAPL	Stock	9.7882	9.8564	9.7771	9.8554	98643524.0
2010-09-17 11:00:00	AAPL	Stock	9.8546	9.8889	9.8311	9.8493	63754572.0
2010-09-17 12:00:00	AAPL	Stock	9.8482	9.8782	9.8457	9.8535	36380988.0
2010-09-17 13:00:00	AAPL	Stock	9.8537	9.8568	9.8211	9.8493	33731236.0
2010-09-17 14:00:00	AAPL	Stock	9.8479	9.8643	9.8386	9.8543	36223684.0
2010-09-17 15:00:00	AAPL	Stock	9.8546	9.855	9.8132	9.8379	95580016.0
2010-09-17 16:00:00	AAPL	Stock	9.8314	9.9092	9.8211	9.8396	48632444.0
2010-09-17 17:00:00	AAPL	Stock	9.8379	9.8411	9.8221	9.8261	296660.0
2010-09-17 18:00:00	AAPL	Stock	9.8225	9.8346	9.8143	9.8232	273364.0
2010-09-17 19:00:00	AAPL	Stock	9.8261	9.8264	9.8154	9.8179	250348.0
2010-09-17 04:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	100.0
2010-09-17 07:00:00	MSFT	Stock	25.5	25.55	25.36	25.44	10300.0
2010-09-17 08:00:00	MSFT	Stock	25.44	25.49	25.35	25.43	39815.0
2010-09-17 09:00:00	MSFT	Stock	25.41	25.53	25.25	25.32	21340606.0
2010-09-17 10:00:00	MSFT	Stock	25.32	25.329	25.12	25.179	10689360.0
2010-09-17 11:00:00	MSFT	Stock	25.175	25.23	25.13	25.175	7372290.0
2010-09-17 12:00:00	MSFT	Stock	25.176	25.2	25.09	25.113	3644634.0
2010-09-17 13:00:00	MSFT	Stock	25.12	25.17	25.08	25.13	4901601.0
2010-09-17 14:00:00	MSFT	Stock	25.135	25.2	25.13	25.16	3161759.0
2010-09-17 15:00:00	MSFT	Stock	25.16	25.26	25.09	25.22	12110988.0
2010-09-17 16:00:00	MSFT	Stock	25.2	25.28	25.08	25.19	4958404.0
2010-09-17 17:00:00	MSFT	Stock	25.22	25.255	25.15	25.15	3173.0
2010-09-17 18:00:00	MSFT	Stock	25.22	25.22	25.14	25.15	54462.0
2010-09-17 19:00:00	MSFT	Stock	25.14	25.16	25.14	25.16	2140.0
2010-09-17 07:00:00	NVDA	Stock	0.2663	0.2663	0.2663	0.2663	20000.0
2010-09-17 08:00:00	NVDA	Stock	0.2652	0.2652	0.2652	0.2652	60000.0
2010-09-17 09:00:00	NVDA	Stock	0.266	0.2675	0.2638	0.2643	107024640.0
2010-09-17 10:00:00	NVDA	Stock	0.2645	0.2663	0.2641	0.2658	50818840.0
2010-09-17 11:00:00	NVDA	Stock	0.2658	0.2663	0.263	0.2636	54747200.0
2010-09-17 12:00:00	NVDA	Stock	0.2636	0.265	0.2632	0.2635	25256040.0
2010-09-17 13:00:00	NVDA	Stock	0.2632	0.265	0.263	0.2645	22294200.0
2010-09-17 14:00:00	NVDA	Stock	0.2645	0.2649	0.2635	0.2643	32872640.0
2010-09-17 15:00:00	NVDA	Stock	0.2643	0.2645	0.263	0.264	78012280.0
2010-09-17 16:00:00	NVDA	Stock	0.264	0.2649	0.2631	0.2643	43467480.0
2010-09-17 17:00:00	NVDA	Stock	0.2648	0.2648	0.2648	0.2648	136000.0
2010-09-17 18:00:00	NVDA	Stock	0.2635	0.2635	0.2635	0.2635	8000.0
2010-09-17 08:00:00	AMZN	Stock	7.449	7.459	7.4255	7.4255	165360.0
2010-09-17 09:00:00	AMZN	Stock	7.4275	7.449	7.3375	7.3472	29621540.0
2010-09-17 10:00:00	AMZN	Stock	7.3475	7.372	7.325	7.365	15186820.0
2010-09-17 11:00:00	AMZN	Stock	7.3665	7.378	7.351	7.3615	9042420.0
2010-09-17 12:00:00	AMZN	Stock	7.362	7.3695	7.3425	7.3525	5836260.0
2010-09-17 13:00:00	AMZN	Stock	7.3515	7.363	7.3415	7.3615	4785220.0
2010-09-17 14:00:00	AMZN	Stock	7.3605	7.4085	7.352	7.3995	10303140.0
2010-09-17 15:00:00	AMZN	Stock	7.399	7.44	7.3695	7.4175	27683220.0

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

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