PREVIEW / stock_1hour / 2008-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-01.parquet
  size:    828 KB
  rows:    40,821
  symbols: 3,260

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-02-01 04:00:00	AAPL	Stock	4.8593	4.8593	4.8282	4.8568	43148.0
2008-02-01 05:00:00	AAPL	Stock	4.8568	4.8611	4.8536	4.8536	88760.0
2008-02-01 06:00:00	AAPL	Stock	4.8543	4.9261	4.8536	4.9143	181440.0
2008-02-01 07:00:00	AAPL	Stock	4.9075	4.9107	4.8696	4.8929	1493716.0
2008-02-01 08:00:00	AAPL	Stock	4.8929	4.9107	4.8343	4.8661	10024672.0
2008-02-01 09:00:00	AAPL	Stock	4.8643	4.875	4.7968	4.8221	137883760.0
2008-02-01 10:00:00	AAPL	Stock	4.8214	4.8782	4.725	4.7329	262167024.0
2008-02-01 11:00:00	AAPL	Stock	4.7329	4.7911	4.7207	4.7887	130720520.0
2008-02-01 12:00:00	AAPL	Stock	4.7889	4.7911	4.7582	4.7711	77139468.0
2008-02-01 13:00:00	AAPL	Stock	4.7711	4.8075	4.77	4.7739	102651976.0
2008-02-01 14:00:00	AAPL	Stock	4.7736	4.8143	4.7679	4.79	119482972.0
2008-02-01 15:00:00	AAPL	Stock	4.79	4.7957	4.7631	4.7754	144308976.0
2008-02-01 16:00:00	AAPL	Stock	4.7743	4.7941	4.7707	4.7743	24165036.0
2008-02-01 17:00:00	AAPL	Stock	4.775	4.7827	4.7743	4.7807	194124.0
2008-02-01 18:00:00	AAPL	Stock	4.7775	4.7775	4.7682	4.7696	312144.0
2008-02-01 19:00:00	AAPL	Stock	4.7696	4.7814	4.7696	4.7761	254380.0
2008-02-01 05:00:00	MSFT	Stock	32.6	32.6	32.6	32.6	600.0
2008-02-01 06:00:00	MSFT	Stock	31.68	32.7	31.65	31.8	135616.0
2008-02-01 07:00:00	MSFT	Stock	31.79	31.85	30.35	30.9	4764277.0
2008-02-01 08:00:00	MSFT	Stock	30.94	31.64	30.287	31.31	14376391.0
2008-02-01 09:00:00	MSFT	Stock	31.32	33.25	30.82	31.11	61399476.0
2008-02-01 10:00:00	MSFT	Stock	31.1	31.17	29.59	30.5	55776493.0
2008-02-01 11:00:00	MSFT	Stock	30.5	31.1	30.48	30.65	28926554.0
2008-02-01 12:00:00	MSFT	Stock	30.642	30.65	30.25	30.39	29906708.0
2008-02-01 13:00:00	MSFT	Stock	30.39	30.58	30.38	30.4	21143303.0
2008-02-01 14:00:00	MSFT	Stock	30.4	30.65	30.36	30.56	17721817.0
2008-02-01 15:00:00	MSFT	Stock	30.56	30.73	30.37	30.45	51474018.0
2008-02-01 16:00:00	MSFT	Stock	30.45	31.3	30.42	30.52	5643065.0
2008-02-01 17:00:00	MSFT	Stock	30.52	32.6	30.45	30.55	182840.0
2008-02-01 18:00:00	MSFT	Stock	30.57	30.64	30.53	30.55	139219.0
2008-02-01 19:00:00	MSFT	Stock	30.54	30.57	30.52	30.54	18797.0
2008-02-01 08:00:00	NVDA	Stock	0.624	0.6325	0.6188	0.625	263200.0
2008-02-01 09:00:00	NVDA	Stock	0.625	0.637	0.6082	0.6295	54918960.0
2008-02-01 10:00:00	NVDA	Stock	0.6295	0.6525	0.628	0.633	133473760.0
2008-02-01 11:00:00	NVDA	Stock	0.633	0.6468	0.6305	0.6455	49187680.0
2008-02-01 12:00:00	NVDA	Stock	0.6455	0.6463	0.6408	0.6452	43314280.0
2008-02-01 13:00:00	NVDA	Stock	0.6452	0.6568	0.6452	0.6522	62202800.0
2008-02-01 14:00:00	NVDA	Stock	0.652	0.6675	0.65	0.6658	75009640.0
2008-02-01 15:00:00	NVDA	Stock	0.6658	0.675	0.664	0.6725	126781080.0
2008-02-01 16:00:00	NVDA	Stock	0.6725	0.6725	0.6504	0.6715	31271520.0
2008-02-01 17:00:00	NVDA	Stock	0.6718	0.6718	0.6698	0.6698	162800.0
2008-02-01 18:00:00	NVDA	Stock	0.6698	0.6718	0.6698	0.6718	18000.0
2008-02-01 19:00:00	NVDA	Stock	0.6698	0.67	0.6698	0.67	48000.0
2008-02-01 05:00:00	AMZN	Stock	3.9	3.9	3.9	3.9	2000.0
2008-02-01 07:00:00	AMZN	Stock	3.94	4.012	3.925	4.005	556160.0
2008-02-01 08:00:00	AMZN	Stock	4.006	4.015	3.95	3.9625	2654180.0
2008-02-01 09:00:00	AMZN	Stock	3.963	3.97	3.8165	3.844	51502020.0
2008-02-01 10:00:00	AMZN	Stock	3.8445	3.875	3.707	3.731	81710880.0
2008-02-01 11:00:00	AMZN	Stock	3.731	3.75	3.669	3.6875	44733340.0
2008-02-01 12:00:00	AMZN	Stock	3.6875	3.952	3.6685	3.6993	30333140.0

> showing 50 of 40,821 rows — these rows as CSV

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