PREVIEW / stock_1hour / 2010-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-26.parquet
  size:    933 KB
  rows:    45,408
  symbols: 3,478

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-26 04:00:00	AAPL	Stock	10.9829	10.9829	10.9782	10.9782	8400.0
2010-10-26 05:00:00	AAPL	Stock	10.9586	10.9704	10.9586	10.9704	8400.0
2010-10-26 06:00:00	AAPL	Stock	10.9821	10.9821	10.9714	10.9729	19600.0
2010-10-26 07:00:00	AAPL	Stock	10.9736	11.0	10.9729	10.9729	227640.0
2010-10-26 08:00:00	AAPL	Stock	10.9821	10.9957	10.9611	10.9764	1437772.0
2010-10-26 09:00:00	AAPL	Stock	10.9764	10.9786	10.9161	10.9432	76429556.0
2010-10-26 10:00:00	AAPL	Stock	10.9411	11.0464	10.9411	11.0364	91715036.0
2010-10-26 11:00:00	AAPL	Stock	11.0368	11.0621	11.0096	11.0504	48431292.0
2010-10-26 12:00:00	AAPL	Stock	11.0504	11.0568	11.025	11.0368	26278448.0
2010-10-26 13:00:00	AAPL	Stock	11.0371	11.0471	10.9814	10.9914	40864544.0
2010-10-26 14:00:00	AAPL	Stock	10.9889	11.0175	10.98	11.0004	29294524.0
2010-10-26 15:00:00	AAPL	Stock	11.0007	11.0157	10.9832	11.0021	49998536.0
2010-10-26 16:00:00	AAPL	Stock	11.0018	11.0415	10.9551	10.9786	18686836.0
2010-10-26 17:00:00	AAPL	Stock	10.9696	10.9761	10.9596	10.9707	2447592.0
2010-10-26 18:00:00	AAPL	Stock	10.9711	11.0018	10.9621	10.9879	1387904.0
2010-10-26 19:00:00	AAPL	Stock	10.985	10.985	10.9654	10.9721	2061304.0
2010-10-26 04:00:00	MSFT	Stock	25.15	25.15	25.15	25.15	500.0
2010-10-26 07:00:00	MSFT	Stock	25.25	25.31	25.18	25.31	22100.0
2010-10-26 08:00:00	MSFT	Stock	25.25	25.25	25.15	25.16	85297.0
2010-10-26 09:00:00	MSFT	Stock	25.17	25.21	25.06	25.16	3636205.0
2010-10-26 10:00:00	MSFT	Stock	25.16	25.39	25.15	25.365	6945788.0
2010-10-26 11:00:00	MSFT	Stock	25.37	25.49	25.29	25.49	7091080.0
2010-10-26 12:00:00	MSFT	Stock	25.49	25.64	25.47	25.54	6822773.0
2010-10-26 13:00:00	MSFT	Stock	25.54	25.695	25.54	25.645	6598955.0
2010-10-26 14:00:00	MSFT	Stock	25.64	25.79	25.57	25.79	9001213.0
2010-10-26 15:00:00	MSFT	Stock	25.79	25.97	25.59	25.91	23943351.0
2010-10-26 16:00:00	MSFT	Stock	25.91	25.98	25.07	25.97	2446696.0
2010-10-26 17:00:00	MSFT	Stock	25.97	25.97	25.88	25.89	5967.0
2010-10-26 18:00:00	MSFT	Stock	25.9	25.94	25.9	25.93	42683.0
2010-10-26 19:00:00	MSFT	Stock	25.95	25.95	25.89	25.89	5045.0
2010-10-26 07:00:00	NVDA	Stock	0.297	0.297	0.297	0.297	8000.0
2010-10-26 08:00:00	NVDA	Stock	0.3	0.3	0.2945	0.2945	272000.0
2010-10-26 09:00:00	NVDA	Stock	0.2945	0.2958	0.2918	0.2952	66997280.0
2010-10-26 10:00:00	NVDA	Stock	0.2952	0.2985	0.2945	0.2972	94043880.0
2010-10-26 11:00:00	NVDA	Stock	0.2971	0.3	0.2958	0.2998	165726080.0
2010-10-26 12:00:00	NVDA	Stock	0.2998	0.3012	0.2978	0.2978	105057000.0
2010-10-26 13:00:00	NVDA	Stock	0.2978	0.3	0.2972	0.2986	93264120.0
2010-10-26 14:00:00	NVDA	Stock	0.2986	0.2995	0.2978	0.2978	55467000.0
2010-10-26 15:00:00	NVDA	Stock	0.2978	0.2984	0.2965	0.2968	86941720.0
2010-10-26 16:00:00	NVDA	Stock	0.2968	0.2988	0.2955	0.2964	6184920.0
2010-10-26 17:00:00	NVDA	Stock	0.298	0.298	0.298	0.298	76000.0
2010-10-26 18:00:00	NVDA	Stock	0.297	0.297	0.297	0.297	24000.0
2010-10-26 19:00:00	NVDA	Stock	0.2988	0.2988	0.2988	0.2988	40000.0
2010-10-26 08:00:00	AMZN	Stock	8.425	8.425	8.3945	8.42	228140.0
2010-10-26 09:00:00	AMZN	Stock	8.4125	8.463	8.375	8.399	13791420.0
2010-10-26 10:00:00	AMZN	Stock	8.4035	8.5	8.3975	8.47	15595880.0
2010-10-26 11:00:00	AMZN	Stock	8.468	8.497	8.446	8.49	9247800.0
2010-10-26 12:00:00	AMZN	Stock	8.4915	8.5225	8.4703	8.4875	9618800.0
2010-10-26 13:00:00	AMZN	Stock	8.4875	8.5275	8.4665	8.475	11517960.0
2010-10-26 14:00:00	AMZN	Stock	8.473	8.523	8.4505	8.4985	11025100.0

> showing 50 of 45,408 rows — these rows as CSV

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