PREVIEW / stock_1hour / 2008-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-16.parquet
  size:    815 KB
  rows:    41,313
  symbols: 3,382

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
2008-12-16 06:00:00	AAPL	Stock	3.3643	3.3643	3.3643	3.3643	5600.0
2008-12-16 07:00:00	AAPL	Stock	3.3643	3.4004	3.3214	3.375	136528.0
2008-12-16 08:00:00	AAPL	Stock	3.3786	3.4025	3.3629	3.375	3728284.0
2008-12-16 09:00:00	AAPL	Stock	3.3743	3.3786	3.3125	3.3661	146627964.0
2008-12-16 10:00:00	AAPL	Stock	3.3668	3.3693	3.3214	3.3496	141169028.0
2008-12-16 11:00:00	AAPL	Stock	3.3489	3.3929	3.3414	3.3807	88426828.0
2008-12-16 12:00:00	AAPL	Stock	3.3807	3.4011	3.3725	3.3832	75143712.0
2008-12-16 13:00:00	AAPL	Stock	3.3839	3.3918	3.3732	3.3829	57454768.0
2008-12-16 14:00:00	AAPL	Stock	3.3829	3.4457	3.3643	3.4029	179409524.0
2008-12-16 15:00:00	AAPL	Stock	3.4021	3.425	3.365	3.39	247707684.0
2008-12-16 16:00:00	AAPL	Stock	3.39	3.4104	3.2954	3.3011	86135028.0
2008-12-16 17:00:00	AAPL	Stock	3.3011	3.4084	3.2	3.3171	73366188.0
2008-12-16 18:00:00	AAPL	Stock	3.3168	3.3357	3.3007	3.3161	6079192.0
2008-12-16 19:00:00	AAPL	Stock	3.3179	3.3268	3.3039	3.3193	1893416.0
2008-12-16 05:00:00	MSFT	Stock	19.15	19.24	19.15	19.24	300.0
2008-12-16 06:00:00	MSFT	Stock	19.29	19.29	19.29	19.29	355.0
2008-12-16 07:00:00	MSFT	Stock	19.3	19.34	19.19	19.33	855.0
2008-12-16 08:00:00	MSFT	Stock	19.29	19.29	19.24	19.25	9790.0
2008-12-16 09:00:00	MSFT	Stock	19.25	19.42	19.0	19.13	8244250.0
2008-12-16 10:00:00	MSFT	Stock	19.14	19.44	19.1	19.44	11753740.0
2008-12-16 11:00:00	MSFT	Stock	19.43	19.53	19.32	19.46	8173073.0
2008-12-16 12:00:00	MSFT	Stock	19.46	19.47	19.36	19.405	4194266.0
2008-12-16 13:00:00	MSFT	Stock	19.41	19.42	19.32	19.36	5298763.0
2008-12-16 14:00:00	MSFT	Stock	19.351	19.88	19.35	19.78	18548549.0
2008-12-16 15:00:00	MSFT	Stock	19.78	20.18	19.6	20.1	29124124.0
2008-12-16 16:00:00	MSFT	Stock	20.1	20.15	19.23	20.13	9959445.0
2008-12-16 17:00:00	MSFT	Stock	20.12	20.13	19.04	20.09	340188.0
2008-12-16 18:00:00	MSFT	Stock	20.06	20.13	20.06	20.1	4594.0
2008-12-16 19:00:00	MSFT	Stock	20.12	20.14	20.08	20.1	13270.0
2008-12-16 08:00:00	NVDA	Stock	0.2095	0.2125	0.208	0.208	60000.0
2008-12-16 09:00:00	NVDA	Stock	0.211	0.2138	0.208	0.2118	48418200.0
2008-12-16 10:00:00	NVDA	Stock	0.2115	0.2155	0.211	0.2132	58802640.0
2008-12-16 11:00:00	NVDA	Stock	0.2134	0.2163	0.2118	0.216	45002160.0
2008-12-16 12:00:00	NVDA	Stock	0.216	0.216	0.213	0.2138	27950440.0
2008-12-16 13:00:00	NVDA	Stock	0.2138	0.215	0.213	0.2135	25178120.0
2008-12-16 14:00:00	NVDA	Stock	0.2135	0.22	0.2132	0.2183	100456120.0
2008-12-16 15:00:00	NVDA	Stock	0.2185	0.2225	0.216	0.221	173930840.0
2008-12-16 16:00:00	NVDA	Stock	0.222	0.2232	0.22	0.2228	2513720.0
2008-12-16 17:00:00	NVDA	Stock	0.2223	0.2223	0.2223	0.2223	22040.0
2008-12-16 18:00:00	NVDA	Stock	0.223	0.223	0.223	0.223	8000.0
2008-12-16 19:00:00	NVDA	Stock	0.2225	0.2225	0.2225	0.2225	40000.0
2008-12-16 08:00:00	AMZN	Stock	2.4975	2.522	2.473	2.48	107800.0
2008-12-16 09:00:00	AMZN	Stock	2.5	2.522	2.4645	2.509	18954020.0
2008-12-16 10:00:00	AMZN	Stock	2.5105	2.5755	2.506	2.537	20528860.0
2008-12-16 11:00:00	AMZN	Stock	2.536	2.568	2.521	2.5565	13537940.0
2008-12-16 12:00:00	AMZN	Stock	2.557	2.5585	2.5385	2.549	10849560.0
2008-12-16 13:00:00	AMZN	Stock	2.549	2.553	2.52	2.5245	14654900.0
2008-12-16 14:00:00	AMZN	Stock	2.525	2.5885	2.521	2.5715	29176620.0
2008-12-16 15:00:00	AMZN	Stock	2.572	2.648	2.553	2.624	50446960.0
2008-12-16 16:00:00	AMZN	Stock	2.6315	2.6455	2.6225	2.6225	544500.0

> showing 50 of 41,313 rows — these rows as CSV

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