PREVIEW / stock_1hour / 2010-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-27.parquet
  size:    914 KB
  rows:    43,646
  symbols: 3,499

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-27 05:00:00	AAPL	Stock	10.9843	10.9843	10.9821	10.9821	11200.0
2010-10-27 07:00:00	AAPL	Stock	10.9821	10.9921	10.9446	10.9511	526960.0
2010-10-27 08:00:00	AAPL	Stock	10.95	11.0446	10.9429	11.0129	6998124.0
2010-10-27 09:00:00	AAPL	Stock	11.0089	11.0679	10.9579	11.0039	75817364.0
2010-10-27 10:00:00	AAPL	Stock	11.006	11.0143	10.9336	10.935	71109500.0
2010-10-27 11:00:00	AAPL	Stock	10.9382	10.9643	10.9143	10.9536	52558912.0
2010-10-27 12:00:00	AAPL	Stock	10.9518	10.9568	10.9296	10.9368	19935384.0
2010-10-27 13:00:00	AAPL	Stock	10.9375	10.9711	10.92	10.9685	33652332.0
2010-10-27 14:00:00	AAPL	Stock	10.9683	10.9875	10.9446	10.9671	35082208.0
2010-10-27 15:00:00	AAPL	Stock	10.9675	10.9996	10.9357	10.9896	58635808.0
2010-10-27 16:00:00	AAPL	Stock	10.9939	10.9952	10.85	10.9414	25764088.0
2010-10-27 17:00:00	AAPL	Stock	10.9357	10.9939	10.9111	10.925	12176836.0
2010-10-27 18:00:00	AAPL	Stock	10.9236	10.9939	10.8929	10.8971	2793252.0
2010-10-27 19:00:00	AAPL	Stock	10.8968	10.9311	10.8964	10.93	2003792.0
2010-10-27 07:00:00	MSFT	Stock	25.75	25.93	25.75	25.82	10910.0
2010-10-27 08:00:00	MSFT	Stock	25.81	25.88	25.73	25.75	68977.0
2010-10-27 09:00:00	MSFT	Stock	25.75	25.89	25.68	25.83	6938125.0
2010-10-27 10:00:00	MSFT	Stock	25.84	25.87	25.72	25.8	9429038.0
2010-10-27 11:00:00	MSFT	Stock	25.802	25.85	25.76	25.76	6650423.0
2010-10-27 12:00:00	MSFT	Stock	25.76	25.78	25.66	25.705	6614674.0
2010-10-27 13:00:00	MSFT	Stock	25.7	25.8	25.62	25.795	5489774.0
2010-10-27 14:00:00	MSFT	Stock	25.79	26.0	25.76	25.96	8140393.0
2010-10-27 15:00:00	MSFT	Stock	25.97	26.11	25.89	26.06	15415810.0
2010-10-27 16:00:00	MSFT	Stock	26.05	26.12	25.8	26.09	3055700.0
2010-10-27 17:00:00	MSFT	Stock	26.08	26.08	26.03	26.03	103890.0
2010-10-27 18:00:00	MSFT	Stock	26.03	26.07	26.03	26.06	30728.0
2010-10-27 19:00:00	MSFT	Stock	26.05	26.09	26.05	26.07	11905.0
2010-10-27 08:00:00	NVDA	Stock	0.2958	0.2958	0.293	0.2932	237240.0
2010-10-27 09:00:00	NVDA	Stock	0.2938	0.2985	0.2932	0.2974	69727600.0
2010-10-27 10:00:00	NVDA	Stock	0.2975	0.2998	0.2968	0.297	105047320.0
2010-10-27 11:00:00	NVDA	Stock	0.2972	0.2975	0.2951	0.2962	90027080.0
2010-10-27 12:00:00	NVDA	Stock	0.2965	0.2988	0.2962	0.2984	27689360.0
2010-10-27 13:00:00	NVDA	Stock	0.2985	0.3	0.2978	0.2999	42960200.0
2010-10-27 14:00:00	NVDA	Stock	0.3	0.3015	0.2995	0.3012	48904120.0
2010-10-27 15:00:00	NVDA	Stock	0.3012	0.302	0.3005	0.3008	99374680.0
2010-10-27 16:00:00	NVDA	Stock	0.301	0.3025	0.2975	0.3015	10415800.0
2010-10-27 17:00:00	NVDA	Stock	0.3002	0.3012	0.3002	0.301	493640.0
2010-10-27 18:00:00	NVDA	Stock	0.302	0.302	0.3	0.3	66920.0
2010-10-27 19:00:00	NVDA	Stock	0.3002	0.3002	0.3002	0.3002	8000.0
2010-10-27 07:00:00	AMZN	Stock	8.511	8.511	8.5	8.5	6000.0
2010-10-27 08:00:00	AMZN	Stock	8.48	8.483	8.47	8.475	106000.0
2010-10-27 09:00:00	AMZN	Stock	8.47	8.4875	8.406	8.42	16646680.0
2010-10-27 10:00:00	AMZN	Stock	8.4195	8.4635	8.3615	8.3689	20641080.0
2010-10-27 11:00:00	AMZN	Stock	8.3671	8.3875	8.3435	8.3725	15841640.0
2010-10-27 12:00:00	AMZN	Stock	8.372	8.385	8.3605	8.373	5105940.0
2010-10-27 13:00:00	AMZN	Stock	8.373	8.379	8.34	8.3732	7923080.0
2010-10-27 14:00:00	AMZN	Stock	8.3732	8.375	8.34	8.3596	14761060.0
2010-10-27 15:00:00	AMZN	Stock	8.359	8.3925	8.327	8.3755	27599400.0
2010-10-27 16:00:00	AMZN	Stock	8.3755	8.3878	8.344	8.35	2921640.0
2010-10-27 17:00:00	AMZN	Stock	8.355	8.3755	8.3425	8.3755	144740.0

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

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