PREVIEW / stock_1hour / 2008-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-15.parquet
  size:    820 KB
  rows:    40,267
  symbols: 3,292

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-04-15 05:00:00	AAPL	Stock	5.2675	5.2675	5.2661	5.2661	10948.0
2008-04-15 06:00:00	AAPL	Stock	5.2693	5.2714	5.2546	5.2546	53200.0
2008-04-15 07:00:00	AAPL	Stock	5.2671	5.2771	5.2607	5.2771	181356.0
2008-04-15 08:00:00	AAPL	Stock	5.2771	5.3482	5.2757	5.3357	4215204.0
2008-04-15 09:00:00	AAPL	Stock	5.3343	5.3518	5.2918	5.2929	95783996.0
2008-04-15 10:00:00	AAPL	Stock	5.2932	5.3168	5.2304	5.25	130343976.0
2008-04-15 11:00:00	AAPL	Stock	5.2496	5.265	5.2043	5.2218	100810500.0
2008-04-15 12:00:00	AAPL	Stock	5.2229	5.255	5.2107	5.2475	56215404.0
2008-04-15 13:00:00	AAPL	Stock	5.2475	5.28	5.2404	5.2668	67792816.0
2008-04-15 14:00:00	AAPL	Stock	5.2668	5.3196	5.2579	5.275	112370804.0
2008-04-15 15:00:00	AAPL	Stock	5.2743	5.3125	5.2707	5.2993	97685392.0
2008-04-15 16:00:00	AAPL	Stock	5.2993	5.3996	5.2617	5.3893	19404084.0
2008-04-15 17:00:00	AAPL	Stock	5.3911	5.3982	5.3821	5.3982	2065392.0
2008-04-15 18:00:00	AAPL	Stock	5.3982	5.4	5.3893	5.4	1494976.0
2008-04-15 19:00:00	AAPL	Stock	5.4	5.4046	5.3964	5.4036	352744.0
2008-04-15 20:00:00	AAPL	Stock	5.2779	5.2779	5.2779	5.2779	423024.0
2008-04-15 08:00:00	MSFT	Stock	28.15	28.29	28.1	28.2	17098.0
2008-04-15 09:00:00	MSFT	Stock	28.16	28.41	28.1	28.4	3519166.0
2008-04-15 10:00:00	MSFT	Stock	28.4	28.48	28.18	28.26	5548562.0
2008-04-15 11:00:00	MSFT	Stock	28.25	28.27	28.03	28.119	4555205.0
2008-04-15 12:00:00	MSFT	Stock	28.12	28.16	28.05	28.09	2918498.0
2008-04-15 13:00:00	MSFT	Stock	28.09	28.15	28.04	28.15	3864042.0
2008-04-15 14:00:00	MSFT	Stock	28.15	28.25	28.1	28.14	3865674.0
2008-04-15 15:00:00	MSFT	Stock	28.15	28.35	28.13	28.27	5972341.0
2008-04-15 16:00:00	MSFT	Stock	28.27	28.65	28.146	28.6	3259798.0
2008-04-15 17:00:00	MSFT	Stock	28.6	28.6	28.5	28.51	30880.0
2008-04-15 18:00:00	MSFT	Stock	28.51	28.59	28.5	28.57	19059.0
2008-04-15 19:00:00	MSFT	Stock	28.59	28.59	28.5	28.51	11731.0
2008-04-15 20:00:00	MSFT	Stock	28.06	28.06	28.06	28.06	245720.0
2008-04-15 08:00:00	NVDA	Stock	0.45	0.452	0.45	0.4502	28000.0
2008-04-15 09:00:00	NVDA	Stock	0.45	0.4525	0.4465	0.4465	45085480.0
2008-04-15 10:00:00	NVDA	Stock	0.4465	0.4478	0.4418	0.4426	68451920.0
2008-04-15 11:00:00	NVDA	Stock	0.4425	0.4445	0.4402	0.4428	65812760.0
2008-04-15 12:00:00	NVDA	Stock	0.4425	0.4482	0.441	0.4475	44089840.0
2008-04-15 13:00:00	NVDA	Stock	0.4478	0.4538	0.4472	0.4522	58227680.0
2008-04-15 14:00:00	NVDA	Stock	0.4522	0.4528	0.4495	0.4505	49746880.0
2008-04-15 15:00:00	NVDA	Stock	0.4505	0.4548	0.4495	0.4535	80409080.0
2008-04-15 16:00:00	NVDA	Stock	0.453	0.47	0.4478	0.4675	15921840.0
2008-04-15 17:00:00	NVDA	Stock	0.4675	0.4685	0.4675	0.4675	1214080.0
2008-04-15 18:00:00	NVDA	Stock	0.468	0.4688	0.4662	0.4662	107080.0
2008-04-15 19:00:00	NVDA	Stock	0.4675	0.469	0.4662	0.4678	137840.0
2008-04-15 20:00:00	NVDA	Stock	0.4478	0.4478	0.4478	0.4478	5737400.0
2008-04-15 08:00:00	AMZN	Stock	3.6305	3.667	3.6305	3.667	734000.0
2008-04-15 09:00:00	AMZN	Stock	3.6685	3.699	3.57	3.5895	18396680.0
2008-04-15 10:00:00	AMZN	Stock	3.5895	3.595	3.5325	3.5675	24716820.0
2008-04-15 11:00:00	AMZN	Stock	3.569	3.5865	3.551	3.5805	11922080.0
2008-04-15 12:00:00	AMZN	Stock	3.58	3.6065	3.574	3.5805	11127260.0
2008-04-15 13:00:00	AMZN	Stock	3.5805	3.608	3.5755	3.605	15937360.0
2008-04-15 14:00:00	AMZN	Stock	3.6055	3.61	3.5825	3.593	16800500.0
2008-04-15 15:00:00	AMZN	Stock	3.5915	3.6315	3.5895	3.6275	30758340.0

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

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