PREVIEW / stock_1hour / 2010-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-09.parquet
  size:    901 KB
  rows:    43,104
  symbols: 3,460

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-09 04:00:00	AAPL	Stock	9.3757	9.3757	9.3757	9.3757	4200.0
2010-09-09 05:00:00	AAPL	Stock	9.4046	9.405	9.4046	9.405	28000.0
2010-09-09 07:00:00	AAPL	Stock	9.4071	9.425	9.4071	9.4125	191436.0
2010-09-09 08:00:00	AAPL	Stock	9.4139	9.4804	9.3929	9.4775	6007960.0
2010-09-09 09:00:00	AAPL	Stock	9.4775	9.5	9.4521	9.4907	82379528.0
2010-09-09 10:00:00	AAPL	Stock	9.49	9.5186	9.4839	9.4864	79869552.0
2010-09-09 11:00:00	AAPL	Stock	9.4882	9.5129	9.4839	9.5085	36199912.0
2010-09-09 12:00:00	AAPL	Stock	9.5084	9.5107	9.4771	9.479	32894428.0
2010-09-09 13:00:00	AAPL	Stock	9.4794	9.4796	9.4039	9.4318	76196232.0
2010-09-09 14:00:00	AAPL	Stock	9.4311	9.4643	9.4243	9.4614	36496012.0
2010-09-09 15:00:00	AAPL	Stock	9.4614	9.4679	9.3936	9.3954	67560808.0
2010-09-09 16:00:00	AAPL	Stock	9.4089	9.5006	9.3868	9.3893	10185224.0
2010-09-09 17:00:00	AAPL	Stock	9.3893	9.3942	9.375	9.3821	1107820.0
2010-09-09 18:00:00	AAPL	Stock	9.3771	9.3954	9.3754	9.3821	264852.0
2010-09-09 19:00:00	AAPL	Stock	9.3804	9.3825	9.3768	9.3789	351848.0
2010-09-09 07:00:00	MSFT	Stock	24.05	24.06	24.05	24.06	1200.0
2010-09-09 08:00:00	MSFT	Stock	23.97	24.15	23.97	24.09	30585.0
2010-09-09 09:00:00	MSFT	Stock	24.11	24.21	23.92	24.082	7341561.0
2010-09-09 10:00:00	MSFT	Stock	24.09	24.15	24.075	24.098	6316546.0
2010-09-09 11:00:00	MSFT	Stock	24.08	24.14	24.07	24.12	5644681.0
2010-09-09 12:00:00	MSFT	Stock	24.112	24.13	24.09	24.09	3852887.0
2010-09-09 13:00:00	MSFT	Stock	24.09	24.14	24.042	24.08	5121046.0
2010-09-09 14:00:00	MSFT	Stock	24.08	24.17	24.06	24.17	4194373.0
2010-09-09 15:00:00	MSFT	Stock	24.17	24.18	23.99	24.01	9494062.0
2010-09-09 16:00:00	MSFT	Stock	24.01	24.111	23.951	24.105	2798677.0
2010-09-09 17:00:00	MSFT	Stock	24.0	24.007	24.0	24.0	5317.0
2010-09-09 18:00:00	MSFT	Stock	24.01	24.02	24.0	24.01	46819.0
2010-09-09 19:00:00	MSFT	Stock	24.02	24.02	24.01	24.01	9000.0
2010-09-09 08:00:00	NVDA	Stock	0.2588	0.2612	0.2583	0.2608	1001760.0
2010-09-09 09:00:00	NVDA	Stock	0.2612	0.2625	0.2555	0.2599	137915080.0
2010-09-09 10:00:00	NVDA	Stock	0.26	0.2608	0.2563	0.2563	147193120.0
2010-09-09 11:00:00	NVDA	Stock	0.2563	0.2588	0.2563	0.2569	82280200.0
2010-09-09 12:00:00	NVDA	Stock	0.2569	0.2578	0.2555	0.2555	44829080.0
2010-09-09 13:00:00	NVDA	Stock	0.2555	0.2555	0.2525	0.2527	67821920.0
2010-09-09 14:00:00	NVDA	Stock	0.2527	0.2545	0.2513	0.2545	72317080.0
2010-09-09 15:00:00	NVDA	Stock	0.2544	0.2555	0.2543	0.2547	127450640.0
2010-09-09 16:00:00	NVDA	Stock	0.2545	0.2583	0.2538	0.2583	13784280.0
2010-09-09 17:00:00	NVDA	Stock	0.2545	0.2545	0.2538	0.2538	78240.0
2010-09-09 20:00:00	NVDA	Stock	0.2565	0.2565	0.2565	0.2565	2948000.0
2010-09-09 08:00:00	AMZN	Stock	6.9975	7.022	6.9975	7.0085	215440.0
2010-09-09 09:00:00	AMZN	Stock	7.0085	7.038	6.957	7.0261	13799860.0
2010-09-09 10:00:00	AMZN	Stock	7.028	7.034	6.963	6.972	18440660.0
2010-09-09 11:00:00	AMZN	Stock	6.9735	7.0375	6.9705	7.023	13231000.0
2010-09-09 12:00:00	AMZN	Stock	7.023	7.0685	7.022	7.0362	14828140.0
2010-09-09 13:00:00	AMZN	Stock	7.0358	7.0465	6.9895	7.0023	11864500.0
2010-09-09 14:00:00	AMZN	Stock	6.999	7.017	6.975	7.013	8342220.0
2010-09-09 15:00:00	AMZN	Stock	7.0145	7.0395	7.006	7.019	15160900.0
2010-09-09 16:00:00	AMZN	Stock	7.0195	7.029	7.0149	7.02	2411220.0
2010-09-09 17:00:00	AMZN	Stock	7.0145	7.0182	7.0145	7.0155	17320.0
2010-09-09 18:00:00	AMZN	Stock	7.0125	7.019	7.0075	7.0075	128800.0

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

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