PREVIEW / stock_1hour / 2010-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-28.parquet
  size:    928 KB
  rows:    43,861
  symbols: 3,476

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-04-28 04:00:00	AAPL	Stock	9.1861	9.2746	9.1425	9.1429	222684.0
2010-04-28 05:00:00	AAPL	Stock	9.1436	9.1821	9.1114	9.1821	371952.0
2010-04-28 06:00:00	AAPL	Stock	9.1543	9.2643	9.1536	9.2643	663432.0
2010-04-28 07:00:00	AAPL	Stock	9.2679	9.3714	9.2575	9.3232	2207716.0
2010-04-28 08:00:00	AAPL	Stock	9.3325	9.4325	9.3271	9.4179	5685456.0
2010-04-28 09:00:00	AAPL	Stock	9.4196	9.4421	9.2946	9.305	113115072.0
2010-04-28 10:00:00	AAPL	Stock	9.305	9.32	9.1575	9.24	216117104.0
2010-04-28 11:00:00	AAPL	Stock	9.24	9.2971	9.2071	9.2617	103278168.0
2010-04-28 12:00:00	AAPL	Stock	9.2611	9.3218	9.2279	9.3071	52118752.0
2010-04-28 13:00:00	AAPL	Stock	9.3061	9.3721	9.2921	9.3482	52675084.0
2010-04-28 14:00:00	AAPL	Stock	9.3482	9.3854	9.2989	9.3614	85190336.0
2010-04-28 15:00:00	AAPL	Stock	9.3629	9.3786	9.2954	9.3432	91617876.0
2010-04-28 16:00:00	AAPL	Stock	9.3432	9.3553	9.2768	9.3	8990464.0
2010-04-28 17:00:00	AAPL	Stock	9.2964	9.3464	9.2964	9.3393	451052.0
2010-04-28 18:00:00	AAPL	Stock	9.3321	9.3429	9.3082	9.315	338492.0
2010-04-28 19:00:00	AAPL	Stock	9.3179	9.3214	9.3036	9.3036	384272.0
2010-04-28 04:00:00	MSFT	Stock	30.72	30.72	30.65	30.65	1715.0
2010-04-28 05:00:00	MSFT	Stock	30.64	30.64	30.56	30.56	1069.0
2010-04-28 06:00:00	MSFT	Stock	30.57	30.72	30.57	30.72	999.0
2010-04-28 07:00:00	MSFT	Stock	30.8	30.89	30.79	30.89	2538.0
2010-04-28 08:00:00	MSFT	Stock	30.83	30.94	30.83	30.94	22020.0
2010-04-28 09:00:00	MSFT	Stock	30.97	31.06	30.74	30.78	5679422.0
2010-04-28 10:00:00	MSFT	Stock	30.779	30.93	30.71	30.83	10649510.0
2010-04-28 11:00:00	MSFT	Stock	30.83	30.93	30.62	30.82	10114592.0
2010-04-28 12:00:00	MSFT	Stock	30.815	30.93	30.73	30.88	5035341.0
2010-04-28 13:00:00	MSFT	Stock	30.89	30.95	30.84	30.879	2760296.0
2010-04-28 14:00:00	MSFT	Stock	30.88	31.0	30.81	30.898	9906585.0
2010-04-28 15:00:00	MSFT	Stock	30.89	30.97	30.85	30.9	14138709.0
2010-04-28 16:00:00	MSFT	Stock	30.91	30.94	30.85	30.85	5026870.0
2010-04-28 17:00:00	MSFT	Stock	30.84	30.85	30.75	30.75	61465.0
2010-04-28 18:00:00	MSFT	Stock	30.75	30.76	30.61	30.63	28177.0
2010-04-28 19:00:00	MSFT	Stock	30.63	30.74	30.63	30.72	9341.0
2010-04-28 05:00:00	NVDA	Stock	0.3925	0.3925	0.3925	0.3925	4000.0
2010-04-28 06:00:00	NVDA	Stock	0.3878	0.3925	0.3878	0.3925	44000.0
2010-04-28 07:00:00	NVDA	Stock	0.4022	0.4022	0.4022	0.4022	72000.0
2010-04-28 08:00:00	NVDA	Stock	0.4	0.4075	0.4	0.4053	1116760.0
2010-04-28 09:00:00	NVDA	Stock	0.411	0.4125	0.4015	0.4062	51281640.0
2010-04-28 10:00:00	NVDA	Stock	0.406	0.4068	0.3975	0.3995	148404240.0
2010-04-28 11:00:00	NVDA	Stock	0.3995	0.402	0.3968	0.3982	95349560.0
2010-04-28 12:00:00	NVDA	Stock	0.3985	0.4005	0.3958	0.399	64688520.0
2010-04-28 13:00:00	NVDA	Stock	0.399	0.4008	0.3978	0.4	36266000.0
2010-04-28 14:00:00	NVDA	Stock	0.3999	0.404	0.3995	0.4032	120180520.0
2010-04-28 15:00:00	NVDA	Stock	0.4032	0.4062	0.402	0.4043	142382000.0
2010-04-28 16:00:00	NVDA	Stock	0.4045	0.4055	0.4014	0.404	4787320.0
2010-04-28 17:00:00	NVDA	Stock	0.4075	0.4075	0.4058	0.4058	50600.0
2010-04-28 18:00:00	NVDA	Stock	0.4075	0.4075	0.4075	0.4075	153600.0
2010-04-28 19:00:00	NVDA	Stock	0.4058	0.4058	0.4058	0.4058	17160.0
2010-04-28 07:00:00	AMZN	Stock	7.145	7.145	7.145	7.145	2000.0
2010-04-28 08:00:00	AMZN	Stock	7.1475	7.1475	7.101	7.145	146700.0
2010-04-28 09:00:00	AMZN	Stock	7.1465	7.1515	7.0355	7.0725	24651800.0

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

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