PREVIEW / stock_1hour / 2010-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-29.parquet
  size:    905 KB
  rows:    43,193
  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-10-29 05:00:00	AAPL	Stock	10.8414	10.8661	10.8368	10.8489	15400.0
2010-10-29 06:00:00	AAPL	Stock	10.8371	10.8571	10.8371	10.8571	14000.0
2010-10-29 07:00:00	AAPL	Stock	10.8464	10.86	10.8393	10.86	63980.0
2010-10-29 08:00:00	AAPL	Stock	10.8629	10.9071	10.85	10.9018	2584232.0
2010-10-29 09:00:00	AAPL	Stock	10.9018	10.9243	10.8571	10.872	45562468.0
2010-10-29 10:00:00	AAPL	Stock	10.8718	10.9036	10.8086	10.8393	59370556.0
2010-10-29 11:00:00	AAPL	Stock	10.8368	10.8439	10.7857	10.8057	50435168.0
2010-10-29 12:00:00	AAPL	Stock	10.8057	10.8804	10.8057	10.8441	44356788.0
2010-10-29 13:00:00	AAPL	Stock	10.845	10.845	10.795	10.8207	48776084.0
2010-10-29 14:00:00	AAPL	Stock	10.8203	10.8268	10.7864	10.7904	34753908.0
2010-10-29 15:00:00	AAPL	Stock	10.7897	10.8125	10.7457	10.7457	105107296.0
2010-10-29 16:00:00	AAPL	Stock	10.7457	10.9014	10.7196	10.7268	27258644.0
2010-10-29 17:00:00	AAPL	Stock	10.7282	10.7321	10.7168	10.7168	903756.0
2010-10-29 18:00:00	AAPL	Stock	10.7189	10.7639	10.7171	10.7339	3262308.0
2010-10-29 19:00:00	AAPL	Stock	10.7321	10.75	10.7236	10.7443	803124.0
2010-10-29 04:00:00	MSFT	Stock	27.01	27.01	26.95	26.97	2400.0
2010-10-29 05:00:00	MSFT	Stock	27.05	27.06	26.99	27.0	6300.0
2010-10-29 06:00:00	MSFT	Stock	27.0	27.23	27.0	27.23	8300.0
2010-10-29 07:00:00	MSFT	Stock	27.15	27.23	26.75	27.09	404438.0
2010-10-29 08:00:00	MSFT	Stock	27.1	27.22	26.97	27.21	1637961.0
2010-10-29 09:00:00	MSFT	Stock	27.21	27.3	26.64	26.729	31575421.0
2010-10-29 10:00:00	MSFT	Stock	26.725	26.81	26.48	26.59	19465706.0
2010-10-29 11:00:00	MSFT	Stock	26.582	26.75	26.55	26.721	9729566.0
2010-10-29 12:00:00	MSFT	Stock	26.728	26.88	26.71	26.86	8222361.0
2010-10-29 13:00:00	MSFT	Stock	26.86	26.96	26.71	26.96	9191366.0
2010-10-29 14:00:00	MSFT	Stock	26.96	26.96	26.536	26.77	7922696.0
2010-10-29 15:00:00	MSFT	Stock	26.76	26.81	26.61	26.63	13607517.0
2010-10-29 16:00:00	MSFT	Stock	26.63	26.789	26.28	26.66	9093085.0
2010-10-29 17:00:00	MSFT	Stock	26.66	27.0	26.63	26.63	10825.0
2010-10-29 18:00:00	MSFT	Stock	26.63	26.66	26.57	26.6	19097.0
2010-10-29 19:00:00	MSFT	Stock	26.6	26.62	26.58	26.58	13440.0
2010-10-29 08:00:00	NVDA	Stock	0.3055	0.3055	0.3055	0.3055	36000.0
2010-10-29 09:00:00	NVDA	Stock	0.3008	0.3038	0.299	0.3015	51643880.0
2010-10-29 10:00:00	NVDA	Stock	0.3014	0.3022	0.2988	0.2998	86983680.0
2010-10-29 11:00:00	NVDA	Stock	0.2998	0.2999	0.298	0.2992	59507240.0
2010-10-29 12:00:00	NVDA	Stock	0.2992	0.2995	0.298	0.2985	50658200.0
2010-10-29 13:00:00	NVDA	Stock	0.2985	0.299	0.2975	0.2988	44828760.0
2010-10-29 14:00:00	NVDA	Stock	0.2989	0.2995	0.298	0.298	33180320.0
2010-10-29 15:00:00	NVDA	Stock	0.2982	0.3008	0.298	0.3008	117697880.0
2010-10-29 16:00:00	NVDA	Stock	0.3008	0.3025	0.2988	0.3012	14054240.0
2010-10-29 17:00:00	NVDA	Stock	0.301	0.301	0.2978	0.298	80000.0
2010-10-29 18:00:00	NVDA	Stock	0.298	0.298	0.2978	0.2978	20000.0
2010-10-29 19:00:00	NVDA	Stock	0.2978	0.3005	0.2975	0.2975	224000.0
2010-10-29 08:00:00	AMZN	Stock	8.331	8.3325	8.2995	8.3	236260.0
2010-10-29 09:00:00	AMZN	Stock	8.3	8.3705	8.278	8.352	10576780.0
2010-10-29 10:00:00	AMZN	Stock	8.352	8.425	8.331	8.3665	19953840.0
2010-10-29 11:00:00	AMZN	Stock	8.368	8.385	8.3285	8.351	7666120.0
2010-10-29 12:00:00	AMZN	Stock	8.3515	8.3825	8.345	8.355	6308000.0
2010-10-29 13:00:00	AMZN	Stock	8.355	8.3556	8.3	8.3085	10166680.0
2010-10-29 14:00:00	AMZN	Stock	8.309	8.31	8.281	8.2864	6838780.0

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

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