PREVIEW / stock_1hour / 2008-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-07.parquet
  size:    799 KB
  rows:    40,091
  symbols: 3,254

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-02-07 04:00:00	AAPL	Stock	4.3225	4.3225	4.3225	4.3225	2800.0
2008-02-07 05:00:00	AAPL	Stock	4.3232	4.3232	4.3104	4.3107	86800.0
2008-02-07 06:00:00	AAPL	Stock	4.3114	4.3114	4.305	4.3107	28700.0
2008-02-07 07:00:00	AAPL	Stock	4.3107	4.3136	4.2743	4.2743	460012.0
2008-02-07 08:00:00	AAPL	Stock	4.3571	4.3571	4.2357	4.2668	6932800.0
2008-02-07 09:00:00	AAPL	Stock	4.2657	4.3571	4.1882	4.2107	316110284.0
2008-02-07 10:00:00	AAPL	Stock	4.2118	4.3536	4.2096	4.2811	478358328.0
2008-02-07 11:00:00	AAPL	Stock	4.2818	4.2993	4.2464	4.2872	188023920.0
2008-02-07 12:00:00	AAPL	Stock	4.2868	4.3671	4.2804	4.3489	199682812.0
2008-02-07 13:00:00	AAPL	Stock	4.3486	4.4375	4.3196	4.4279	242821628.0
2008-02-07 14:00:00	AAPL	Stock	4.4271	4.4564	4.3011	4.3057	318659768.0
2008-02-07 15:00:00	AAPL	Stock	4.305	4.3439	4.2429	4.3289	315841092.0
2008-02-07 16:00:00	AAPL	Stock	4.33	4.3554	4.2912	4.3357	13684468.0
2008-02-07 17:00:00	AAPL	Stock	4.3357	4.3714	4.2884	4.3686	2095436.0
2008-02-07 18:00:00	AAPL	Stock	4.3682	4.3857	4.3571	4.3579	1426880.0
2008-02-07 19:00:00	AAPL	Stock	4.3571	4.3671	4.35	4.3671	476616.0
2008-02-07 06:00:00	MSFT	Stock	28.3	28.31	28.3	28.31	1200.0
2008-02-07 07:00:00	MSFT	Stock	28.35	28.35	28.1	28.12	51648.0
2008-02-07 08:00:00	MSFT	Stock	28.15	28.52	28.12	28.17	257201.0
2008-02-07 09:00:00	MSFT	Stock	28.17	28.4	28.0	28.259	22698492.0
2008-02-07 10:00:00	MSFT	Stock	28.25	28.68	28.23	28.33	27816196.0
2008-02-07 11:00:00	MSFT	Stock	28.33	28.39	28.18	28.322	11910206.0
2008-02-07 12:00:00	MSFT	Stock	28.323	28.48	28.2	28.4	14979959.0
2008-02-07 13:00:00	MSFT	Stock	28.4	28.74	28.26	28.7	21959976.0
2008-02-07 14:00:00	MSFT	Stock	28.7	28.78	28.15	28.16	24815583.0
2008-02-07 15:00:00	MSFT	Stock	28.16	28.23	27.9	28.12	36582505.0
2008-02-07 16:00:00	MSFT	Stock	28.13	28.309	28.09	28.18	3712250.0
2008-02-07 17:00:00	MSFT	Stock	28.2	28.52	28.12	28.22	372711.0
2008-02-07 18:00:00	MSFT	Stock	28.23	28.37	28.14	28.19	267923.0
2008-02-07 19:00:00	MSFT	Stock	28.19	28.22	28.15	28.21	52538.0
2008-02-07 08:00:00	NVDA	Stock	0.5963	0.5963	0.5863	0.5912	468320.0
2008-02-07 09:00:00	NVDA	Stock	0.59	0.6078	0.5775	0.5788	101072520.0
2008-02-07 10:00:00	NVDA	Stock	0.5788	0.5983	0.5785	0.5922	113935480.0
2008-02-07 11:00:00	NVDA	Stock	0.5924	0.5988	0.5898	0.5986	43531760.0
2008-02-07 12:00:00	NVDA	Stock	0.5988	0.6162	0.598	0.6135	58465760.0
2008-02-07 13:00:00	NVDA	Stock	0.6135	0.6295	0.61	0.6278	74907480.0
2008-02-07 14:00:00	NVDA	Stock	0.6275	0.631	0.614	0.614	103872480.0
2008-02-07 15:00:00	NVDA	Stock	0.614	0.6173	0.605	0.6135	161866120.0
2008-02-07 16:00:00	NVDA	Stock	0.6135	0.6198	0.6055	0.6198	10802480.0
2008-02-07 17:00:00	NVDA	Stock	0.6109	0.6109	0.6109	0.6109	20000.0
2008-02-07 18:00:00	NVDA	Stock	0.619	0.619	0.615	0.615	32000.0
2008-02-07 19:00:00	NVDA	Stock	0.615	0.6162	0.615	0.6162	20000.0
2008-02-07 04:00:00	AMZN	Stock	3.4245	3.4245	3.4245	3.4245	2000.0
2008-02-07 07:00:00	AMZN	Stock	3.4	3.4185	3.3605	3.4185	26000.0
2008-02-07 08:00:00	AMZN	Stock	3.4245	3.4245	3.375	3.376	87300.0
2008-02-07 09:00:00	AMZN	Stock	3.4245	3.4595	3.361	3.4325	51661920.0
2008-02-07 10:00:00	AMZN	Stock	3.4325	3.5345	3.4255	3.4775	50425860.0
2008-02-07 11:00:00	AMZN	Stock	3.476	3.4955	3.415	3.457	22352560.0
2008-02-07 12:00:00	AMZN	Stock	3.4585	3.519	3.456	3.517	17685040.0
2008-02-07 13:00:00	AMZN	Stock	3.519	3.5735	3.4845	3.567	31036200.0

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

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