PREVIEW / stock_1hour / 2008-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-14.parquet
  size:    827 KB
  rows:    40,125
  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
2008-08-14 07:00:00	AAPL	Stock	6.4107	6.4214	6.4107	6.4211	152320.0
2008-08-14 08:00:00	AAPL	Stock	6.4196	6.4268	6.3661	6.3839	2439836.0
2008-08-14 09:00:00	AAPL	Stock	6.3804	6.4446	6.3514	6.4304	127746024.0
2008-08-14 10:00:00	AAPL	Stock	6.4304	6.4375	6.3679	6.4157	140041720.0
2008-08-14 11:00:00	AAPL	Stock	6.4161	6.4293	6.3932	6.4025	90968696.0
2008-08-14 12:00:00	AAPL	Stock	6.4032	6.4125	6.375	6.3836	76667948.0
2008-08-14 13:00:00	AAPL	Stock	6.3846	6.4089	6.3607	6.3962	71628284.0
2008-08-14 14:00:00	AAPL	Stock	6.3971	6.4054	6.3732	6.3893	58281132.0
2008-08-14 15:00:00	AAPL	Stock	6.3893	6.4079	6.3611	6.4021	103587400.0
2008-08-14 16:00:00	AAPL	Stock	6.4023	6.4089	6.3949	6.4004	25490416.0
2008-08-14 17:00:00	AAPL	Stock	6.4018	6.4054	6.4007	6.4011	333004.0
2008-08-14 18:00:00	AAPL	Stock	6.4029	6.4054	6.4011	6.4036	188076.0
2008-08-14 19:00:00	AAPL	Stock	6.4036	6.4061	6.4036	6.4057	123704.0
2008-08-14 07:00:00	MSFT	Stock	27.88	27.88	27.88	27.88	100.0
2008-08-14 08:00:00	MSFT	Stock	27.99	27.99	27.83	27.91	19022.0
2008-08-14 09:00:00	MSFT	Stock	27.88	28.05	27.6	27.781	6355131.0
2008-08-14 10:00:00	MSFT	Stock	27.78	28.06	27.56	27.85	10397217.0
2008-08-14 11:00:00	MSFT	Stock	27.85	28.06	27.8	28.04	5547882.0
2008-08-14 12:00:00	MSFT	Stock	28.04	28.28	28.0	28.19	4367199.0
2008-08-14 13:00:00	MSFT	Stock	28.198	28.26	28.0	28.02	4095538.0
2008-08-14 14:00:00	MSFT	Stock	28.03	28.08	27.94	27.95	4711141.0
2008-08-14 15:00:00	MSFT	Stock	27.95	28.0	27.87	27.92	7767550.0
2008-08-14 16:00:00	MSFT	Stock	27.9	28.01	27.88	27.91	2745035.0
2008-08-14 17:00:00	MSFT	Stock	27.96	28.042	27.93	27.93	90100.0
2008-08-14 19:00:00	MSFT	Stock	27.97	27.98	27.93	27.93	2800.0
2008-08-14 08:00:00	NVDA	Stock	0.3075	0.3113	0.305	0.305	819440.0
2008-08-14 09:00:00	NVDA	Stock	0.3032	0.3188	0.303	0.3188	164455520.0
2008-08-14 10:00:00	NVDA	Stock	0.3188	0.3293	0.3178	0.3243	373402800.0
2008-08-14 11:00:00	NVDA	Stock	0.3242	0.3268	0.3225	0.3259	229085240.0
2008-08-14 12:00:00	NVDA	Stock	0.3259	0.3315	0.3255	0.3285	181251480.0
2008-08-14 13:00:00	NVDA	Stock	0.3285	0.3373	0.3275	0.3314	259532880.0
2008-08-14 14:00:00	NVDA	Stock	0.3315	0.3318	0.326	0.3283	134978080.0
2008-08-14 15:00:00	NVDA	Stock	0.328	0.3285	0.3248	0.3248	239433040.0
2008-08-14 16:00:00	NVDA	Stock	0.325	0.3264	0.322	0.3248	41654000.0
2008-08-14 17:00:00	NVDA	Stock	0.3238	0.3288	0.322	0.3268	3038480.0
2008-08-14 18:00:00	NVDA	Stock	0.3268	0.327	0.3253	0.327	205400.0
2008-08-14 19:00:00	NVDA	Stock	0.3268	0.3283	0.3255	0.3258	704160.0
2008-08-14 08:00:00	AMZN	Stock	4.3425	4.3425	4.3425	4.3425	2000.0
2008-08-14 09:00:00	AMZN	Stock	4.32	4.328	4.261	4.328	20271560.0
2008-08-14 10:00:00	AMZN	Stock	4.328	4.415	4.3125	4.3765	28135680.0
2008-08-14 11:00:00	AMZN	Stock	4.3765	4.4015	4.37	4.3905	13160380.0
2008-08-14 12:00:00	AMZN	Stock	4.3905	4.4375	4.3885	4.4345	18934220.0
2008-08-14 13:00:00	AMZN	Stock	4.4325	4.433	4.4005	4.4155	10210260.0
2008-08-14 14:00:00	AMZN	Stock	4.4145	4.4246	4.3945	4.4	13691400.0
2008-08-14 15:00:00	AMZN	Stock	4.3995	4.416	4.384	4.4015	24893200.0
2008-08-14 16:00:00	AMZN	Stock	4.3975	4.4053	4.3805	4.3905	4052940.0
2008-08-14 17:00:00	AMZN	Stock	4.4	4.4135	4.4	4.4135	106300.0
2008-08-14 18:00:00	AMZN	Stock	4.4135	4.4135	4.4135	4.4135	3000.0
2008-08-14 19:00:00	AMZN	Stock	4.406	4.406	4.406	4.406	6000.0
2008-08-14 08:00:00	TLT	Stock	91.76	92.1	91.76	92.1	6974.0

> showing 50 of 40,125 rows — these rows as CSV

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