PREVIEW / stock_1hour / 2008-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-15.parquet
  size:    846 KB
  rows:    41,168
  symbols: 3,326

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-15 06:00:00	AAPL	Stock	6.3914	6.3914	6.3914	6.3914	5600.0
2008-08-15 07:00:00	AAPL	Stock	6.3854	6.3971	6.3643	6.3661	143220.0
2008-08-15 08:00:00	AAPL	Stock	6.3839	6.4286	6.3696	6.3964	1532776.0
2008-08-15 09:00:00	AAPL	Stock	6.3964	6.4196	6.3232	6.3546	112087080.0
2008-08-15 10:00:00	AAPL	Stock	6.3554	6.3921	6.2807	6.3843	114082080.0
2008-08-15 11:00:00	AAPL	Stock	6.3846	6.3975	6.3614	6.365	70925120.0
2008-08-15 12:00:00	AAPL	Stock	6.3657	6.3857	6.3504	6.3572	49541324.0
2008-08-15 13:00:00	AAPL	Stock	6.3571	6.3629	6.2686	6.2718	69907964.0
2008-08-15 14:00:00	AAPL	Stock	6.2714	6.2911	6.2518	6.2786	102293156.0
2008-08-15 15:00:00	AAPL	Stock	6.28	6.3036	6.2564	6.275	105526456.0
2008-08-15 16:00:00	AAPL	Stock	6.2757	6.3358	6.2689	6.2732	10247608.0
2008-08-15 17:00:00	AAPL	Stock	6.2736	6.31	6.2729	6.2843	351400.0
2008-08-15 18:00:00	AAPL	Stock	6.2814	6.2832	6.2771	6.2771	66388.0
2008-08-15 19:00:00	AAPL	Stock	6.2768	6.2768	6.2718	6.2718	30044.0
2008-08-15 07:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	1200.0
2008-08-15 08:00:00	MSFT	Stock	27.85	27.97	27.85	27.95	4725.0
2008-08-15 09:00:00	MSFT	Stock	27.95	28.15	27.81	27.848	11530982.0
2008-08-15 10:00:00	MSFT	Stock	27.85	28.03	27.67	28.01	7236922.0
2008-08-15 11:00:00	MSFT	Stock	28.02	28.02	27.84	27.853	4533136.0
2008-08-15 12:00:00	MSFT	Stock	27.86	27.9	27.75	27.86	2938377.0
2008-08-15 13:00:00	MSFT	Stock	27.86	27.87	27.74	27.75	2601890.0
2008-08-15 14:00:00	MSFT	Stock	27.752	27.82	27.58	27.73	7497944.0
2008-08-15 15:00:00	MSFT	Stock	27.72	27.85	27.69	27.8	7214967.0
2008-08-15 16:00:00	MSFT	Stock	27.81	27.865	27.722	27.81	3037839.0
2008-08-15 17:00:00	MSFT	Stock	27.78	27.83	27.78	27.83	900.0
2008-08-15 19:00:00	MSFT	Stock	27.83	27.85	27.83	27.85	865.0
2008-08-15 20:00:00	MSFT	Stock	27.99	27.99	27.99	27.99	763.0
2008-08-15 07:00:00	NVDA	Stock	0.3313	0.3313	0.3288	0.3288	68000.0
2008-08-15 08:00:00	NVDA	Stock	0.33	0.331	0.3268	0.3298	1872200.0
2008-08-15 09:00:00	NVDA	Stock	0.33	0.3345	0.3273	0.3288	149164920.0
2008-08-15 10:00:00	NVDA	Stock	0.3288	0.3288	0.3218	0.324	148744600.0
2008-08-15 11:00:00	NVDA	Stock	0.324	0.3248	0.323	0.3233	67564360.0
2008-08-15 12:00:00	NVDA	Stock	0.3231	0.325	0.3223	0.325	73910000.0
2008-08-15 13:00:00	NVDA	Stock	0.325	0.325	0.3234	0.3235	50414160.0
2008-08-15 14:00:00	NVDA	Stock	0.3237	0.3245	0.3225	0.324	118018760.0
2008-08-15 15:00:00	NVDA	Stock	0.324	0.325	0.3233	0.3238	104715160.0
2008-08-15 16:00:00	NVDA	Stock	0.324	0.3256	0.3236	0.3245	13969360.0
2008-08-15 17:00:00	NVDA	Stock	0.3243	0.3243	0.3243	0.3243	40000.0
2008-08-15 18:00:00	NVDA	Stock	0.3243	0.3243	0.3235	0.3235	91760.0
2008-08-15 19:00:00	NVDA	Stock	0.3245	0.3245	0.3235	0.3235	180480.0
2008-08-15 20:00:00	NVDA	Stock	0.3245	0.3245	0.3245	0.3245	9440.0
2008-08-15 07:00:00	AMZN	Stock	4.394	4.394	4.394	4.394	4000.0
2008-08-15 08:00:00	AMZN	Stock	4.4	4.4225	4.4	4.4205	34000.0
2008-08-15 09:00:00	AMZN	Stock	4.415	4.4765	4.341	4.354	23522600.0
2008-08-15 10:00:00	AMZN	Stock	4.3545	4.366	4.315	4.3525	26200020.0
2008-08-15 11:00:00	AMZN	Stock	4.354	4.3775	4.332	4.3565	16919700.0
2008-08-15 12:00:00	AMZN	Stock	4.355	4.38	4.3375	4.369	13293260.0
2008-08-15 13:00:00	AMZN	Stock	4.369	4.3755	4.355	4.357	13119680.0
2008-08-15 14:00:00	AMZN	Stock	4.357	4.3595	4.3255	4.336	12460300.0
2008-08-15 15:00:00	AMZN	Stock	4.336	4.35	4.313	4.32	28470180.0

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

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