PREVIEW / stock_1hour / 2010-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-05.parquet
  size:    944 KB
  rows:    45,893
  symbols: 3,511

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-05 04:00:00	AAPL	Stock	11.3393	11.3393	11.3393	11.3393	11200.0
2010-11-05 05:00:00	AAPL	Stock	11.3136	11.3136	11.3136	11.3136	2800.0
2010-11-05 06:00:00	AAPL	Stock	11.2932	11.3043	11.29	11.29	36120.0
2010-11-05 07:00:00	AAPL	Stock	11.29	11.3314	11.29	11.3275	171360.0
2010-11-05 08:00:00	AAPL	Stock	11.3221	11.3925	11.3214	11.3489	8057924.0
2010-11-05 09:00:00	AAPL	Stock	11.3489	11.4132	11.3321	11.3639	79829092.0
2010-11-05 10:00:00	AAPL	Stock	11.3639	11.3959	11.3511	11.365	58044112.0
2010-11-05 11:00:00	AAPL	Stock	11.3646	11.3704	11.3393	11.3396	38279556.0
2010-11-05 12:00:00	AAPL	Stock	11.3393	11.365	11.3357	11.3614	24562636.0
2010-11-05 13:00:00	AAPL	Stock	11.3611	11.3786	11.3604	11.3656	22652924.0
2010-11-05 14:00:00	AAPL	Stock	11.3671	11.3689	11.3254	11.3529	33225248.0
2010-11-05 15:00:00	AAPL	Stock	11.3532	11.3593	11.3125	11.3261	78134672.0
2010-11-05 16:00:00	AAPL	Stock	11.3236	11.3566	11.3061	11.335	12680276.0
2010-11-05 17:00:00	AAPL	Stock	11.3311	11.3336	11.3254	11.3286	109816.0
2010-11-05 18:00:00	AAPL	Stock	11.3318	11.3393	11.3261	11.3375	409472.0
2010-11-05 19:00:00	AAPL	Stock	11.3393	11.355	11.3382	11.3546	360332.0
2010-11-05 07:00:00	MSFT	Stock	27.13	27.13	27.05	27.05	2100.0
2010-11-05 08:00:00	MSFT	Stock	27.09	27.25	27.04	27.17	144892.0
2010-11-05 09:00:00	MSFT	Stock	27.17	27.21	26.86	26.88	10375098.0
2010-11-05 10:00:00	MSFT	Stock	26.88	26.9	26.63	26.66	23501010.0
2010-11-05 11:00:00	MSFT	Stock	26.665	26.73	26.53	26.63	16018396.0
2010-11-05 12:00:00	MSFT	Stock	26.64	26.86	26.62	26.84	7591869.0
2010-11-05 13:00:00	MSFT	Stock	26.839	26.91	26.81	26.81	4213201.0
2010-11-05 14:00:00	MSFT	Stock	26.818	26.86	26.65	26.665	7917030.0
2010-11-05 15:00:00	MSFT	Stock	26.67	26.85	26.65	26.84	16668108.0
2010-11-05 16:00:00	MSFT	Stock	26.84	26.855	26.68	26.8	3116402.0
2010-11-05 17:00:00	MSFT	Stock	26.82	26.85	26.82	26.84	9487.0
2010-11-05 18:00:00	MSFT	Stock	26.83	26.85	26.81	26.85	25513.0
2010-11-05 19:00:00	MSFT	Stock	26.85	26.85	26.84	26.85	3242.0
2010-11-05 07:00:00	NVDA	Stock	0.3138	0.3138	0.3128	0.3128	8000.0
2010-11-05 08:00:00	NVDA	Stock	0.3125	0.3155	0.311	0.315	2317200.0
2010-11-05 09:00:00	NVDA	Stock	0.3143	0.315	0.3108	0.3135	133765600.0
2010-11-05 10:00:00	NVDA	Stock	0.3133	0.318	0.3133	0.3157	146751160.0
2010-11-05 11:00:00	NVDA	Stock	0.3155	0.3175	0.313	0.313	107390040.0
2010-11-05 12:00:00	NVDA	Stock	0.313	0.314	0.3125	0.3136	73795040.0
2010-11-05 13:00:00	NVDA	Stock	0.3136	0.3145	0.3135	0.3145	33669960.0
2010-11-05 14:00:00	NVDA	Stock	0.3145	0.315	0.3133	0.3141	88255840.0
2010-11-05 15:00:00	NVDA	Stock	0.3141	0.3158	0.314	0.315	126990280.0
2010-11-05 16:00:00	NVDA	Stock	0.315	0.3153	0.3137	0.315	3531760.0
2010-11-05 17:00:00	NVDA	Stock	0.315	0.3153	0.3138	0.3138	124000.0
2010-11-05 18:00:00	NVDA	Stock	0.3138	0.315	0.3138	0.315	159440.0
2010-11-05 19:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	4000.0
2010-11-05 04:00:00	AMZN	Stock	8.499	8.499	8.499	8.499	2000.0
2010-11-05 06:00:00	AMZN	Stock	8.4095	8.4095	8.4095	8.4095	2000.0
2010-11-05 07:00:00	AMZN	Stock	8.409	8.415	8.409	8.415	8000.0
2010-11-05 08:00:00	AMZN	Stock	8.401	8.475	8.4	8.45	331280.0
2010-11-05 09:00:00	AMZN	Stock	8.444	8.535	8.4295	8.5175	18612140.0
2010-11-05 10:00:00	AMZN	Stock	8.5175	8.54	8.49	8.525	12552520.0
2010-11-05 11:00:00	AMZN	Stock	8.5245	8.5825	8.51	8.5455	14158280.0
2010-11-05 12:00:00	AMZN	Stock	8.5435	8.576	8.5335	8.5565	8744060.0

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

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