PREVIEW / stock_1hour / 2009-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-06.parquet
  size:    846 KB
  rows:    41,231
  symbols: 3,329

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
2009-01-06 05:00:00	AAPL	Stock	3.3925	3.3925	3.3925	3.3925	5600.0
2009-01-06 06:00:00	AAPL	Stock	3.4161	3.4161	3.4161	3.4161	19600.0
2009-01-06 07:00:00	AAPL	Stock	3.4357	3.4643	3.4214	3.435	1500800.0
2009-01-06 08:00:00	AAPL	Stock	3.4346	3.4414	3.4143	3.4196	6866664.0
2009-01-06 09:00:00	AAPL	Stock	3.42	3.4489	3.4029	3.4296	133997948.0
2009-01-06 10:00:00	AAPL	Stock	3.4293	3.4704	3.42	3.4275	200570888.0
2009-01-06 11:00:00	AAPL	Stock	3.4282	3.4321	3.4061	3.4211	103713036.0
2009-01-06 12:00:00	AAPL	Stock	3.4221	3.4568	3.4132	3.4411	116684484.0
2009-01-06 13:00:00	AAPL	Stock	3.4406	3.4418	3.3257	3.3389	301654136.0
2009-01-06 14:00:00	AAPL	Stock	3.3396	3.3618	3.3143	3.355	180175576.0
2009-01-06 15:00:00	AAPL	Stock	3.3557	3.3571	3.2996	3.3214	217881160.0
2009-01-06 16:00:00	AAPL	Stock	3.3229	3.4179	3.3061	3.3154	13217960.0
2009-01-06 17:00:00	AAPL	Stock	3.3171	3.3196	3.3086	3.3125	426608.0
2009-01-06 18:00:00	AAPL	Stock	3.3139	3.3221	3.3071	3.3082	2504936.0
2009-01-06 19:00:00	AAPL	Stock	3.3089	3.3118	3.25	3.3068	369684.0
2009-01-06 07:00:00	MSFT	Stock	20.52	20.85	20.52	20.85	27596.0
2009-01-06 08:00:00	MSFT	Stock	20.52	20.81	20.52	20.76	953455.0
2009-01-06 09:00:00	MSFT	Stock	20.76	20.94	20.69	20.9	7640902.0
2009-01-06 10:00:00	MSFT	Stock	20.91	20.96	20.69	20.94	9485953.0
2009-01-06 11:00:00	MSFT	Stock	20.94	20.98	20.79	20.85	5934419.0
2009-01-06 12:00:00	MSFT	Stock	20.85	20.9	20.79	20.89	5507455.0
2009-01-06 13:00:00	MSFT	Stock	20.89	20.9	20.72	20.78	5709830.0
2009-01-06 14:00:00	MSFT	Stock	20.79	21.0	20.69	20.97	6527718.0
2009-01-06 15:00:00	MSFT	Stock	20.96	20.99	20.61	20.76	13539125.0
2009-01-06 16:00:00	MSFT	Stock	20.75	20.906	20.67	20.67	2277997.0
2009-01-06 17:00:00	MSFT	Stock	20.68	20.76	20.67	20.68	7754.0
2009-01-06 18:00:00	MSFT	Stock	20.7	20.72	20.67	20.69	1221.0
2009-01-06 19:00:00	MSFT	Stock	20.69	20.69	20.67	20.67	1259.0
2009-01-06 08:00:00	NVDA	Stock	0.2248	0.2248	0.2248	0.2248	44000.0
2009-01-06 09:00:00	NVDA	Stock	0.225	0.2308	0.2232	0.2288	54801520.0
2009-01-06 10:00:00	NVDA	Stock	0.229	0.2303	0.226	0.229	98785520.0
2009-01-06 11:00:00	NVDA	Stock	0.229	0.2295	0.225	0.2295	63099840.0
2009-01-06 12:00:00	NVDA	Stock	0.2298	0.2358	0.2295	0.2348	109773840.0
2009-01-06 13:00:00	NVDA	Stock	0.2348	0.2348	0.231	0.2322	81367560.0
2009-01-06 14:00:00	NVDA	Stock	0.2325	0.2345	0.2305	0.2338	68577240.0
2009-01-06 15:00:00	NVDA	Stock	0.2338	0.2342	0.229	0.2298	167120520.0
2009-01-06 16:00:00	NVDA	Stock	0.2295	0.2325	0.227	0.2298	8543080.0
2009-01-06 17:00:00	NVDA	Stock	0.231	0.2378	0.231	0.2348	3776800.0
2009-01-06 18:00:00	NVDA	Stock	0.2345	0.2362	0.2345	0.236	451920.0
2009-01-06 19:00:00	NVDA	Stock	0.235	0.235	0.2345	0.235	181600.0
2009-01-06 08:00:00	AMZN	Stock	2.6765	2.6765	2.6765	2.6765	10000.0
2009-01-06 09:00:00	AMZN	Stock	2.6965	2.7735	2.6875	2.77	27990920.0
2009-01-06 10:00:00	AMZN	Stock	2.7705	2.7975	2.7575	2.788	37707980.0
2009-01-06 11:00:00	AMZN	Stock	2.7875	2.869	2.781	2.869	34478580.0
2009-01-06 12:00:00	AMZN	Stock	2.869	2.911	2.8575	2.8665	32314300.0
2009-01-06 13:00:00	AMZN	Stock	2.865	2.8745	2.847	2.8625	17611520.0
2009-01-06 14:00:00	AMZN	Stock	2.8625	2.9075	2.843	2.9	23796700.0
2009-01-06 15:00:00	AMZN	Stock	2.9	2.905	2.8565	2.868	42422000.0
2009-01-06 16:00:00	AMZN	Stock	2.8675	2.8762	2.8306	2.87	2676240.0
2009-01-06 17:00:00	AMZN	Stock	2.8763	2.885	2.8715	2.875	16000.0

> showing 50 of 41,231 rows — these rows as CSV

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