PREVIEW / stock_1hour / 2010-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-04.parquet
  size:    916 KB
  rows:    44,167
  symbols: 3,488

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-04 04:00:00	AAPL	Stock	10.0396	10.0396	10.0396	10.0396	2800.0
2010-10-04 05:00:00	AAPL	Stock	10.0357	10.0375	10.0357	10.0357	8400.0
2010-10-04 06:00:00	AAPL	Stock	10.0321	10.0321	10.0321	10.0321	16800.0
2010-10-04 07:00:00	AAPL	Stock	10.0679	10.0775	10.0464	10.0543	100380.0
2010-10-04 08:00:00	AAPL	Stock	10.0636	10.0871	10.0429	10.0561	1379532.0
2010-10-04 09:00:00	AAPL	Stock	10.0543	10.1036	10.0143	10.0625	78092700.0
2010-10-04 10:00:00	AAPL	Stock	10.0632	10.0786	10.0321	10.0586	63191408.0
2010-10-04 11:00:00	AAPL	Stock	10.0589	10.0596	9.9404	9.9443	78946980.0
2010-10-04 12:00:00	AAPL	Stock	9.9432	9.9528	9.9204	9.9361	52437336.0
2010-10-04 13:00:00	AAPL	Stock	9.9375	9.9629	9.9239	9.9446	34880356.0
2010-10-04 14:00:00	AAPL	Stock	9.945	9.9761	9.9257	9.9646	47947760.0
2010-10-04 15:00:00	AAPL	Stock	9.9643	9.9925	9.9446	9.95	64342292.0
2010-10-04 16:00:00	AAPL	Stock	9.9514	10.068	9.9262	9.9514	8636404.0
2010-10-04 17:00:00	AAPL	Stock	9.9668	9.9732	9.9664	9.9732	245504.0
2010-10-04 18:00:00	AAPL	Stock	9.9729	9.9804	9.9514	9.9782	449456.0
2010-10-04 19:00:00	AAPL	Stock	9.9732	9.9779	9.9714	9.9732	166880.0
2010-10-04 04:00:00	MSFT	Stock	24.33	24.33	23.8	23.8	2880.0
2010-10-04 05:00:00	MSFT	Stock	23.93	23.99	23.9	23.9	5000.0
2010-10-04 06:00:00	MSFT	Stock	23.91	23.91	23.88	23.9	17200.0
2010-10-04 07:00:00	MSFT	Stock	23.88	23.97	23.83	23.93	60299.0
2010-10-04 08:00:00	MSFT	Stock	23.94	24.0	23.91	24.0	417765.0
2010-10-04 09:00:00	MSFT	Stock	24.0	24.38	23.83	23.91	19809723.0
2010-10-04 10:00:00	MSFT	Stock	23.885	23.98	23.84	23.911	16303746.0
2010-10-04 11:00:00	MSFT	Stock	23.91	23.92	23.78	23.86	12007647.0
2010-10-04 12:00:00	MSFT	Stock	23.87	23.9	23.79	23.795	8556254.0
2010-10-04 13:00:00	MSFT	Stock	23.8	23.85	23.79	23.82	6591157.0
2010-10-04 14:00:00	MSFT	Stock	23.82	23.85	23.79	23.81	9934818.0
2010-10-04 15:00:00	MSFT	Stock	23.81	23.92	23.79	23.91	20195803.0
2010-10-04 16:00:00	MSFT	Stock	23.91	23.97	23.848	23.96	2513779.0
2010-10-04 17:00:00	MSFT	Stock	23.97	24.38	23.91	23.95	33122.0
2010-10-04 18:00:00	MSFT	Stock	23.94	23.99	23.91	23.94	46276.0
2010-10-04 19:00:00	MSFT	Stock	23.94	23.95	23.94	23.95	10289.0
2010-10-04 08:00:00	NVDA	Stock	0.2838	0.2838	0.28	0.2803	162800.0
2010-10-04 09:00:00	NVDA	Stock	0.2812	0.2858	0.2775	0.2825	121190360.0
2010-10-04 10:00:00	NVDA	Stock	0.2825	0.2835	0.2808	0.282	114792680.0
2010-10-04 11:00:00	NVDA	Stock	0.282	0.282	0.2758	0.276	111568560.0
2010-10-04 12:00:00	NVDA	Stock	0.2763	0.2815	0.2752	0.281	143654840.0
2010-10-04 13:00:00	NVDA	Stock	0.2811	0.2822	0.279	0.28	78403600.0
2010-10-04 14:00:00	NVDA	Stock	0.2798	0.281	0.2783	0.2798	62449400.0
2010-10-04 15:00:00	NVDA	Stock	0.28	0.2818	0.2795	0.2808	96257320.0
2010-10-04 16:00:00	NVDA	Stock	0.2808	0.2838	0.28	0.2804	7793760.0
2010-10-04 17:00:00	NVDA	Stock	0.281	0.2838	0.281	0.281	294560.0
2010-10-04 19:00:00	NVDA	Stock	0.28	0.28	0.28	0.28	4000.0
2010-10-04 08:00:00	AMZN	Stock	7.637	7.6845	7.637	7.661	35000.0
2010-10-04 09:00:00	AMZN	Stock	7.6625	7.7945	7.661	7.729	18576580.0
2010-10-04 10:00:00	AMZN	Stock	7.7295	7.7805	7.7025	7.738	20207320.0
2010-10-04 11:00:00	AMZN	Stock	7.7354	7.7385	7.654	7.659	12598860.0
2010-10-04 12:00:00	AMZN	Stock	7.659	7.706	7.6395	7.6965	11527900.0
2010-10-04 13:00:00	AMZN	Stock	7.6985	7.7395	7.694	7.7325	8138240.0
2010-10-04 14:00:00	AMZN	Stock	7.7321	7.7467	7.699	7.7395	7599920.0

> showing 50 of 44,167 rows — these rows as CSV

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