PREVIEW / stock_1hour / 2010-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-04.parquet
  size:    912 KB
  rows:    43,818
  symbols: 3,472

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-06-04 04:00:00	AAPL	Stock	9.4279	9.4279	9.4279	9.4279	8400.0
2010-06-04 05:00:00	AAPL	Stock	9.425	9.425	9.425	9.425	23772.0
2010-06-04 06:00:00	AAPL	Stock	9.4375	9.4554	9.4071	9.4071	44100.0
2010-06-04 07:00:00	AAPL	Stock	9.4018	9.4182	9.31	9.3179	480760.0
2010-06-04 08:00:00	AAPL	Stock	9.3214	9.3661	9.2146	9.2357	11208736.0
2010-06-04 09:00:00	AAPL	Stock	9.2368	9.3525	9.1821	9.32	128773596.0
2010-06-04 10:00:00	AAPL	Stock	9.3196	9.3536	9.2879	9.2925	105490868.0
2010-06-04 11:00:00	AAPL	Stock	9.2914	9.3086	9.2536	9.2818	84583072.0
2010-06-04 12:00:00	AAPL	Stock	9.2807	9.2807	9.2389	9.2786	61698728.0
2010-06-04 13:00:00	AAPL	Stock	9.2789	9.2814	9.2011	9.2096	68524848.0
2010-06-04 14:00:00	AAPL	Stock	9.2071	9.2243	9.1471	9.1514	97034140.0
2010-06-04 15:00:00	AAPL	Stock	9.1521	9.1689	9.0939	9.1459	176467984.0
2010-06-04 16:00:00	AAPL	Stock	9.1414	9.1766	9.1255	9.1571	16354324.0
2010-06-04 17:00:00	AAPL	Stock	9.1536	9.1571	9.1364	9.1518	1049076.0
2010-06-04 18:00:00	AAPL	Stock	9.1468	9.1536	9.1375	9.1404	1251096.0
2010-06-04 19:00:00	AAPL	Stock	9.1411	9.1411	9.1071	9.1143	524888.0
2010-06-04 07:00:00	MSFT	Stock	26.62	26.62	26.61	26.61	400.0
2010-06-04 08:00:00	MSFT	Stock	26.69	26.7	26.25	26.25	34325.0
2010-06-04 09:00:00	MSFT	Stock	26.29	26.43	26.03	26.24	14004744.0
2010-06-04 10:00:00	MSFT	Stock	26.24	26.57	26.23	26.28	10072344.0
2010-06-04 11:00:00	MSFT	Stock	26.28	26.43	26.26	26.36	6701953.0
2010-06-04 12:00:00	MSFT	Stock	26.362	26.37	26.18	26.27	6932239.0
2010-06-04 13:00:00	MSFT	Stock	26.26	26.27	25.97	26.01	6810649.0
2010-06-04 14:00:00	MSFT	Stock	26.005	26.11	25.84	25.86	10487575.0
2010-06-04 15:00:00	MSFT	Stock	25.86	25.92	25.62	25.78	29069710.0
2010-06-04 16:00:00	MSFT	Stock	25.78	26.835	25.69	25.71	4321335.0
2010-06-04 17:00:00	MSFT	Stock	26.85	26.85	25.7	25.75	97592.0
2010-06-04 18:00:00	MSFT	Stock	25.75	25.83	25.71	25.74	223423.0
2010-06-04 19:00:00	MSFT	Stock	25.77	25.78	25.72	25.78	5368.0
2010-06-04 08:00:00	NVDA	Stock	0.315	0.3155	0.3073	0.3088	384480.0
2010-06-04 09:00:00	NVDA	Stock	0.3088	0.3138	0.3068	0.3123	54941400.0
2010-06-04 10:00:00	NVDA	Stock	0.3121	0.3123	0.3075	0.3078	133325600.0
2010-06-04 11:00:00	NVDA	Stock	0.3078	0.31	0.306	0.308	63977960.0
2010-06-04 12:00:00	NVDA	Stock	0.3083	0.3085	0.3032	0.3058	100021640.0
2010-06-04 13:00:00	NVDA	Stock	0.3055	0.3068	0.3028	0.3035	63063600.0
2010-06-04 14:00:00	NVDA	Stock	0.3035	0.3042	0.3022	0.3022	99929000.0
2010-06-04 15:00:00	NVDA	Stock	0.3022	0.3038	0.3008	0.3022	138328520.0
2010-06-04 16:00:00	NVDA	Stock	0.3025	0.3176	0.3008	0.3022	15208320.0
2010-06-04 17:00:00	NVDA	Stock	0.3022	0.3022	0.3022	0.3022	56000.0
2010-06-04 18:00:00	NVDA	Stock	0.3038	0.3038	0.3022	0.3038	777760.0
2010-06-04 19:00:00	NVDA	Stock	0.3038	0.3038	0.303	0.303	108000.0
2010-06-04 07:00:00	AMZN	Stock	6.375	6.375	6.375	6.375	2000.0
2010-06-04 08:00:00	AMZN	Stock	6.3255	6.375	6.253	6.3	549900.0
2010-06-04 09:00:00	AMZN	Stock	6.305	6.3765	6.289	6.3705	13445860.0
2010-06-04 10:00:00	AMZN	Stock	6.367	6.41	6.3435	6.3525	13196360.0
2010-06-04 11:00:00	AMZN	Stock	6.351	6.3705	6.261	6.338	12920080.0
2010-06-04 12:00:00	AMZN	Stock	6.3375	6.3375	6.25	6.2621	11926680.0
2010-06-04 13:00:00	AMZN	Stock	6.2605	6.2635	6.189	6.19	10862540.0
2010-06-04 14:00:00	AMZN	Stock	6.19	6.2125	6.123	6.1307	13594720.0
2010-06-04 15:00:00	AMZN	Stock	6.135	6.1785	6.109	6.136	27435820.0

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

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