PREVIEW / stock_1hour / 2010-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-11.parquet
  size:    910 KB
  rows:    44,075
  symbols: 3,454

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-08-11 05:00:00	AAPL	Stock	9.1982	9.1982	9.1696	9.1696	11200.0
2010-08-11 07:00:00	AAPL	Stock	9.1679	9.1857	9.1643	9.1804	471492.0
2010-08-11 08:00:00	AAPL	Stock	9.1829	9.1957	9.1379	9.1482	2946272.0
2010-08-11 09:00:00	AAPL	Stock	9.1504	9.1518	9.0214	9.0559	111141604.0
2010-08-11 10:00:00	AAPL	Stock	9.055	9.0779	8.9871	9.0014	89019420.0
2010-08-11 11:00:00	AAPL	Stock	9.0016	9.0089	8.9404	8.9636	102637108.0
2010-08-11 12:00:00	AAPL	Stock	8.9643	8.9689	8.9218	8.9318	73545304.0
2010-08-11 13:00:00	AAPL	Stock	8.9318	8.9875	8.9318	8.9571	57972544.0
2010-08-11 14:00:00	AAPL	Stock	8.9568	8.9814	8.9293	8.9453	57617420.0
2010-08-11 15:00:00	AAPL	Stock	8.9436	8.9693	8.9286	8.9311	100108512.0
2010-08-11 16:00:00	AAPL	Stock	8.9318	9.1194	8.8579	8.8582	17879680.0
2010-08-11 17:00:00	AAPL	Stock	8.8575	8.8575	8.8071	8.8304	2422672.0
2010-08-11 18:00:00	AAPL	Stock	8.8304	8.9354	8.8304	8.8464	931392.0
2010-08-11 19:00:00	AAPL	Stock	8.8529	8.8529	8.8286	8.8393	723660.0
2010-08-11 04:00:00	MSFT	Stock	25.0	25.0	24.86	24.86	1300.0
2010-08-11 06:00:00	MSFT	Stock	24.8	24.8	24.77	24.77	400.0
2010-08-11 07:00:00	MSFT	Stock	24.76	24.77	24.66	24.75	6965.0
2010-08-11 08:00:00	MSFT	Stock	24.73	24.81	24.7	24.71	42098.0
2010-08-11 09:00:00	MSFT	Stock	24.71	24.78	24.6	24.77	9656856.0
2010-08-11 10:00:00	MSFT	Stock	24.765	24.85	24.69	24.8	11143448.0
2010-08-11 11:00:00	MSFT	Stock	24.795	24.81	24.69	24.72	8508997.0
2010-08-11 12:00:00	MSFT	Stock	24.71	24.76	24.57	24.57	9795056.0
2010-08-11 13:00:00	MSFT	Stock	24.57	24.69	24.56	24.65	8881877.0
2010-08-11 14:00:00	MSFT	Stock	24.65	24.78	24.648	24.72	7183534.0
2010-08-11 15:00:00	MSFT	Stock	24.728	24.9	24.71	24.84	17316864.0
2010-08-11 16:00:00	MSFT	Stock	24.84	25.145	24.48	24.5	3353006.0
2010-08-11 17:00:00	MSFT	Stock	24.49	24.6	24.47	24.48	76490.0
2010-08-11 18:00:00	MSFT	Stock	24.5	24.86	24.47	24.5	23265.0
2010-08-11 19:00:00	MSFT	Stock	24.5	24.51	24.47	24.5	53202.0
2010-08-11 20:00:00	MSFT	Stock	24.74	24.74	24.74	24.74	1600.0
2010-08-11 07:00:00	NVDA	Stock	0.2275	0.2278	0.2258	0.2268	39760.0
2010-08-11 08:00:00	NVDA	Stock	0.2268	0.228	0.226	0.2265	1036440.0
2010-08-11 09:00:00	NVDA	Stock	0.2265	0.2272	0.2238	0.2248	96976680.0
2010-08-11 10:00:00	NVDA	Stock	0.2245	0.2248	0.2223	0.2235	128001440.0
2010-08-11 11:00:00	NVDA	Stock	0.2233	0.2238	0.2212	0.2235	119674720.0
2010-08-11 12:00:00	NVDA	Stock	0.2235	0.2235	0.2223	0.2223	42964080.0
2010-08-11 13:00:00	NVDA	Stock	0.2225	0.2232	0.2215	0.222	82152000.0
2010-08-11 14:00:00	NVDA	Stock	0.2223	0.2232	0.2215	0.222	91841440.0
2010-08-11 15:00:00	NVDA	Stock	0.2219	0.2228	0.2218	0.222	202373280.0
2010-08-11 16:00:00	NVDA	Stock	0.2205	0.2235	0.2203	0.2203	10268440.0
2010-08-11 17:00:00	NVDA	Stock	0.222	0.222	0.2188	0.2188	951200.0
2010-08-11 18:00:00	NVDA	Stock	0.2195	0.2198	0.2188	0.2188	523320.0
2010-08-11 19:00:00	NVDA	Stock	0.2188	0.2198	0.218	0.2188	531800.0
2010-08-11 04:00:00	AMZN	Stock	6.4675	6.4675	6.4675	6.4675	2000.0
2010-08-11 05:00:00	AMZN	Stock	6.4675	6.4675	6.4675	6.4675	2000.0
2010-08-11 06:00:00	AMZN	Stock	6.425	6.425	6.4	6.4	64000.0
2010-08-11 07:00:00	AMZN	Stock	6.4	6.4	6.373	6.373	71000.0
2010-08-11 08:00:00	AMZN	Stock	6.4035	6.434	6.4	6.4085	414900.0
2010-08-11 09:00:00	AMZN	Stock	6.413	6.4165	6.3395	6.3545	18905700.0
2010-08-11 10:00:00	AMZN	Stock	6.3545	6.367	6.292	6.2925	26158880.0

> showing 50 of 44,075 rows — these rows as CSV

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