PREVIEW / stock_1hour / 2010-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-06.parquet
  size:    908 KB
  rows:    43,602
  symbols: 3,487

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-10-06 04:00:00	AAPL	Stock	10.3607	10.3607	10.3607	10.3607	4508.0
2010-10-06 06:00:00	AAPL	Stock	10.3821	10.3821	10.375	10.375	29400.0
2010-10-06 07:00:00	AAPL	Stock	10.3571	10.3818	10.3518	10.375	655900.0
2010-10-06 08:00:00	AAPL	Stock	10.3768	10.3821	10.3346	10.3482	4877236.0
2010-10-06 09:00:00	AAPL	Stock	10.3482	10.4282	10.3271	10.3437	103915952.0
2010-10-06 10:00:00	AAPL	Stock	10.3436	10.3743	10.2314	10.2821	111887356.0
2010-10-06 11:00:00	AAPL	Stock	10.2814	10.3296	10.2607	10.3007	54457200.0
2010-10-06 12:00:00	AAPL	Stock	10.3018	10.3207	10.2321	10.2382	51067324.0
2010-10-06 13:00:00	AAPL	Stock	10.2392	10.3107	10.1879	10.3071	83812708.0
2010-10-06 14:00:00	AAPL	Stock	10.3071	10.3493	10.2375	10.325	136572716.0
2010-10-06 15:00:00	AAPL	Stock	10.3268	10.3393	10.2593	10.32	97687968.0
2010-10-06 16:00:00	AAPL	Stock	10.3282	10.3375	10.2847	10.3371	12372976.0
2010-10-06 17:00:00	AAPL	Stock	10.3357	10.3486	10.3357	10.3429	1551088.0
2010-10-06 18:00:00	AAPL	Stock	10.3421	10.3457	10.3129	10.32	876764.0
2010-10-06 19:00:00	AAPL	Stock	10.3214	10.3246	10.2964	10.3025	601888.0
2010-10-06 07:00:00	MSFT	Stock	24.45	24.5	24.4	24.5	10100.0
2010-10-06 08:00:00	MSFT	Stock	24.5	24.5	24.32	24.35	25750.0
2010-10-06 09:00:00	MSFT	Stock	24.35	24.5	24.23	24.49	6220177.0
2010-10-06 10:00:00	MSFT	Stock	24.491	24.54	24.27	24.32	7373779.0
2010-10-06 11:00:00	MSFT	Stock	24.32	24.39	24.27	24.32	4758477.0
2010-10-06 12:00:00	MSFT	Stock	24.325	24.34	24.2	24.21	5717451.0
2010-10-06 13:00:00	MSFT	Stock	24.21	24.27	24.13	24.27	4513162.0
2010-10-06 14:00:00	MSFT	Stock	24.27	24.38	24.23	24.351	6381591.0
2010-10-06 15:00:00	MSFT	Stock	24.35	24.44	24.29	24.43	11932619.0
2010-10-06 16:00:00	MSFT	Stock	24.43	24.5	24.298	24.44	2526161.0
2010-10-06 17:00:00	MSFT	Stock	24.44	24.44	24.4	24.43	1280.0
2010-10-06 18:00:00	MSFT	Stock	24.43	24.43	24.43	24.43	78618.0
2010-10-06 19:00:00	MSFT	Stock	24.4	24.41	24.4	24.41	950.0
2010-10-06 08:00:00	NVDA	Stock	0.2852	0.2852	0.282	0.282	223200.0
2010-10-06 09:00:00	NVDA	Stock	0.2818	0.2842	0.2752	0.2755	171812160.0
2010-10-06 10:00:00	NVDA	Stock	0.2756	0.277	0.268	0.2715	342320240.0
2010-10-06 11:00:00	NVDA	Stock	0.2715	0.2732	0.2703	0.2718	84566760.0
2010-10-06 12:00:00	NVDA	Stock	0.2718	0.2725	0.27	0.2705	57571520.0
2010-10-06 13:00:00	NVDA	Stock	0.2704	0.271	0.2683	0.2695	99811520.0
2010-10-06 14:00:00	NVDA	Stock	0.2694	0.2695	0.268	0.268	86911360.0
2010-10-06 15:00:00	NVDA	Stock	0.2682	0.27	0.2668	0.2695	193815840.0
2010-10-06 16:00:00	NVDA	Stock	0.2695	0.2716	0.2668	0.269	19854240.0
2010-10-06 17:00:00	NVDA	Stock	0.2698	0.2698	0.2695	0.2695	52000.0
2010-10-06 18:00:00	NVDA	Stock	0.2695	0.2698	0.2695	0.2698	96000.0
2010-10-06 19:00:00	NVDA	Stock	0.2698	0.27	0.2688	0.2688	218880.0
2010-10-06 08:00:00	AMZN	Stock	8.0145	8.0495	7.9925	8.0	131660.0
2010-10-06 09:00:00	AMZN	Stock	8.005	8.034	7.9595	7.974	10600320.0
2010-10-06 10:00:00	AMZN	Stock	7.975	8.0205	7.8525	7.8835	21554440.0
2010-10-06 11:00:00	AMZN	Stock	7.8835	7.9175	7.8605	7.878	12624060.0
2010-10-06 12:00:00	AMZN	Stock	7.8755	7.893	7.796	7.803	13369520.0
2010-10-06 13:00:00	AMZN	Stock	7.804	7.808	7.749	7.781	18554080.0
2010-10-06 14:00:00	AMZN	Stock	7.78	7.806	7.73	7.7895	14838360.0
2010-10-06 15:00:00	AMZN	Stock	7.7895	7.797	7.7305	7.77	25565980.0
2010-10-06 16:00:00	AMZN	Stock	7.772	7.8355	7.7175	7.7734	3426500.0
2010-10-06 17:00:00	AMZN	Stock	7.769	7.775	7.76	7.76	32600.0

> showing 50 of 43,602 rows — these rows as CSV

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