PREVIEW / stock_1hour / 2010-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-12.parquet
  size:    936 KB
  rows:    45,258
  symbols: 3,480

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-11-12 04:00:00	AAPL	Stock	11.2679	11.2679	11.1839	11.1839	44800.0
2010-11-12 05:00:00	AAPL	Stock	11.2071	11.2321	11.2071	11.2321	130620.0
2010-11-12 06:00:00	AAPL	Stock	11.2325	11.2393	11.2143	11.2393	61264.0
2010-11-12 07:00:00	AAPL	Stock	11.2625	11.2786	11.2246	11.2664	302148.0
2010-11-12 08:00:00	AAPL	Stock	11.2696	11.2957	11.2368	11.2889	3085516.0
2010-11-12 09:00:00	AAPL	Stock	11.2893	11.3321	11.2486	11.2832	59037552.0
2010-11-12 10:00:00	AAPL	Stock	11.2836	11.2918	11.13	11.1414	103914888.0
2010-11-12 11:00:00	AAPL	Stock	11.145	11.1786	11.0932	11.1232	87474912.0
2010-11-12 12:00:00	AAPL	Stock	11.1221	11.1411	10.8439	10.9529	188579972.0
2010-11-12 13:00:00	AAPL	Stock	10.9525	11.0671	10.9286	11.0036	105997780.0
2010-11-12 14:00:00	AAPL	Stock	11.0036	11.0971	10.9754	11.0736	96626040.0
2010-11-12 15:00:00	AAPL	Stock	11.0729	11.1039	10.995	11.0039	136359608.0
2010-11-12 16:00:00	AAPL	Stock	10.9971	11.3039	10.9929	11.0029	9390360.0
2010-11-12 17:00:00	AAPL	Stock	11.0007	11.2589	10.9786	10.9821	1210636.0
2010-11-12 18:00:00	AAPL	Stock	10.9807	11.0011	10.9696	10.9714	413644.0
2010-11-12 19:00:00	AAPL	Stock	10.9714	10.9857	10.9682	10.9804	333004.0
2010-11-12 07:00:00	MSFT	Stock	26.57	26.6	26.55	26.55	2700.0
2010-11-12 08:00:00	MSFT	Stock	26.51	26.55	26.48	26.55	28738.0
2010-11-12 09:00:00	MSFT	Stock	26.55	26.62	26.36	26.42	7246499.0
2010-11-12 10:00:00	MSFT	Stock	26.41	26.45	26.29	26.3	11158936.0
2010-11-12 11:00:00	MSFT	Stock	26.295	26.32	26.2	26.24	8320216.0
2010-11-12 12:00:00	MSFT	Stock	26.24	26.27	26.1	26.14	8694126.0
2010-11-12 13:00:00	MSFT	Stock	26.15	26.28	26.13	26.235	5367328.0
2010-11-12 14:00:00	MSFT	Stock	26.232	26.35	26.19	26.32	4713138.0
2010-11-12 15:00:00	MSFT	Stock	26.31	26.36	26.2	26.27	15270834.0
2010-11-12 16:00:00	MSFT	Stock	26.26	26.298	26.1	26.2	2386548.0
2010-11-12 17:00:00	MSFT	Stock	26.238	26.27	26.16	26.18	52737.0
2010-11-12 18:00:00	MSFT	Stock	26.16	26.27	26.15	26.15	10299.0
2010-11-12 19:00:00	MSFT	Stock	26.15	26.18	26.15	26.16	13430.0
2010-11-12 04:00:00	NVDA	Stock	0.3285	0.3285	0.3285	0.3285	4000.0
2010-11-12 05:00:00	NVDA	Stock	0.3175	0.3255	0.3175	0.3255	16000.0
2010-11-12 06:00:00	NVDA	Stock	0.328	0.328	0.3263	0.3263	44000.0
2010-11-12 07:00:00	NVDA	Stock	0.3258	0.3362	0.3258	0.3295	2726960.0
2010-11-12 08:00:00	NVDA	Stock	0.33	0.3315	0.325	0.3283	13085600.0
2010-11-12 09:00:00	NVDA	Stock	0.3288	0.3408	0.325	0.3393	562971200.0
2010-11-12 10:00:00	NVDA	Stock	0.3392	0.342	0.3362	0.3378	455521520.0
2010-11-12 11:00:00	NVDA	Stock	0.3377	0.3382	0.3313	0.3325	375410600.0
2010-11-12 12:00:00	NVDA	Stock	0.3325	0.3335	0.3293	0.3325	222441200.0
2010-11-12 13:00:00	NVDA	Stock	0.3328	0.3348	0.3293	0.3325	111220480.0
2010-11-12 14:00:00	NVDA	Stock	0.3325	0.3335	0.331	0.332	122456240.0
2010-11-12 15:00:00	NVDA	Stock	0.3319	0.3342	0.3308	0.3313	228987640.0
2010-11-12 16:00:00	NVDA	Stock	0.3313	0.3356	0.3305	0.3305	10737200.0
2010-11-12 17:00:00	NVDA	Stock	0.3305	0.3318	0.33	0.3318	3464080.0
2010-11-12 18:00:00	NVDA	Stock	0.3305	0.3305	0.3288	0.33	189720.0
2010-11-12 19:00:00	NVDA	Stock	0.33	0.3303	0.33	0.33	541600.0
2010-11-12 04:00:00	AMZN	Stock	8.469	8.469	8.469	8.469	2000.0
2010-11-12 05:00:00	AMZN	Stock	8.5	8.509	8.5	8.505	10000.0
2010-11-12 06:00:00	AMZN	Stock	8.4835	8.4835	8.4835	8.4835	2000.0
2010-11-12 07:00:00	AMZN	Stock	8.5075	8.5195	8.5065	8.5065	61500.0
2010-11-12 08:00:00	AMZN	Stock	8.5195	8.5195	8.463	8.48	116500.0

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

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