PREVIEW / stock_1hour / 2010-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-17.parquet
  size:    889 KB
  rows:    42,748
  symbols: 3,447

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
2010-02-17 06:00:00	AAPL	Stock	7.2696	7.2696	7.2696	7.2696	3752.0
2010-02-17 07:00:00	AAPL	Stock	7.2732	7.2946	7.2732	7.2921	122024.0
2010-02-17 08:00:00	AAPL	Stock	7.2857	7.3036	7.2804	7.2961	1817424.0
2010-02-17 09:00:00	AAPL	Stock	7.295	7.3	7.2457	7.2618	72391452.0
2010-02-17 10:00:00	AAPL	Stock	7.2625	7.2846	7.2486	7.2593	78049776.0
2010-02-17 11:00:00	AAPL	Stock	7.2589	7.2599	7.1896	7.2073	72963408.0
2010-02-17 12:00:00	AAPL	Stock	7.2079	7.2239	7.1736	7.2225	54988248.0
2010-02-17 13:00:00	AAPL	Stock	7.2228	7.2439	7.2189	7.2343	49034216.0
2010-02-17 14:00:00	AAPL	Stock	7.2339	7.235	7.1964	7.2314	35165844.0
2010-02-17 15:00:00	AAPL	Stock	7.2304	7.2393	7.2086	7.2336	58516752.0
2010-02-17 16:00:00	AAPL	Stock	7.2321	7.2669	7.2239	7.2361	4996068.0
2010-02-17 17:00:00	AAPL	Stock	7.2364	7.2393	7.2361	7.2382	47432.0
2010-02-17 18:00:00	AAPL	Stock	7.2341	7.2357	7.2325	7.2339	1159312.0
2010-02-17 19:00:00	AAPL	Stock	7.2339	7.2339	7.2254	7.2254	449988.0
2010-02-17 07:00:00	MSFT	Stock	28.47	28.5	28.45	28.45	4050.0
2010-02-17 08:00:00	MSFT	Stock	28.55	28.62	28.5	28.57	35370.0
2010-02-17 09:00:00	MSFT	Stock	28.58	28.62	28.42	28.515	8268843.0
2010-02-17 10:00:00	MSFT	Stock	28.52	28.65	28.47	28.56	6567072.0
2010-02-17 11:00:00	MSFT	Stock	28.56	28.58	28.43	28.58	5858655.0
2010-02-17 12:00:00	MSFT	Stock	28.58	28.62	28.44	28.5	3626327.0
2010-02-17 13:00:00	MSFT	Stock	28.5	28.54	28.4	28.45	2845717.0
2010-02-17 14:00:00	MSFT	Stock	28.45	28.49	28.36	28.48	3849414.0
2010-02-17 15:00:00	MSFT	Stock	28.475	28.61	28.46	28.6	11217444.0
2010-02-17 16:00:00	MSFT	Stock	28.6	28.68	28.485	28.67	2284250.0
2010-02-17 17:00:00	MSFT	Stock	28.519	28.65	28.482	28.59	207911.0
2010-02-17 18:00:00	MSFT	Stock	28.59	28.67	28.59	28.6	10746.0
2010-02-17 19:00:00	MSFT	Stock	28.6	28.66	28.6	28.6	1575.0
2010-02-17 20:00:00	MSFT	Stock	28.35	28.35	28.35	28.35	94300.0
2010-02-17 07:00:00	NVDA	Stock	0.445	0.4452	0.445	0.4452	24000.0
2010-02-17 08:00:00	NVDA	Stock	0.4462	0.4462	0.4442	0.4448	116080.0
2010-02-17 09:00:00	NVDA	Stock	0.445	0.4475	0.4412	0.4445	86113720.0
2010-02-17 10:00:00	NVDA	Stock	0.4445	0.4452	0.4361	0.4365	144451480.0
2010-02-17 11:00:00	NVDA	Stock	0.4362	0.4389	0.4331	0.4345	98653160.0
2010-02-17 12:00:00	NVDA	Stock	0.4345	0.4375	0.4342	0.4365	44613520.0
2010-02-17 13:00:00	NVDA	Stock	0.4364	0.4382	0.4362	0.437	49413160.0
2010-02-17 14:00:00	NVDA	Stock	0.4371	0.4438	0.4366	0.4428	109241840.0
2010-02-17 15:00:00	NVDA	Stock	0.4425	0.4472	0.4412	0.4465	262745480.0
2010-02-17 16:00:00	NVDA	Stock	0.4462	0.4512	0.4275	0.4312	54228400.0
2010-02-17 17:00:00	NVDA	Stock	0.4312	0.446	0.4275	0.4285	6112760.0
2010-02-17 18:00:00	NVDA	Stock	0.4275	0.446	0.4242	0.4298	5124080.0
2010-02-17 19:00:00	NVDA	Stock	0.4288	0.4305	0.4275	0.4285	378600.0
2010-02-17 07:00:00	AMZN	Stock	5.91	5.91	5.91	5.91	2000.0
2010-02-17 08:00:00	AMZN	Stock	5.8965	5.9	5.866	5.875	156260.0
2010-02-17 09:00:00	AMZN	Stock	5.8725	5.876	5.7925	5.817	33833600.0
2010-02-17 10:00:00	AMZN	Stock	5.8165	5.8555	5.806	5.829	33390340.0
2010-02-17 11:00:00	AMZN	Stock	5.829	5.834	5.7775	5.8005	28659880.0
2010-02-17 12:00:00	AMZN	Stock	5.801	5.8145	5.7825	5.813	16211940.0
2010-02-17 13:00:00	AMZN	Stock	5.813	5.824	5.796	5.803	15497240.0
2010-02-17 14:00:00	AMZN	Stock	5.803	5.8093	5.791	5.7965	16585580.0
2010-02-17 15:00:00	AMZN	Stock	5.7966	5.817	5.7935	5.815	30307680.0

> showing 50 of 42,748 rows — these rows as CSV

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