PREVIEW / stock_1hour / 2010-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-30.parquet
  size:    893 KB
  rows:    42,515
  symbols: 3,471

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-07-30 05:00:00	AAPL	Stock	9.1982	9.1982	9.1982	9.1982	2800.0
2010-07-30 06:00:00	AAPL	Stock	9.185	9.185	9.185	9.185	52920.0
2010-07-30 07:00:00	AAPL	Stock	9.1846	9.2075	9.1782	9.185	51800.0
2010-07-30 08:00:00	AAPL	Stock	9.1846	9.1893	9.1439	9.1514	3224172.0
2010-07-30 09:00:00	AAPL	Stock	9.1514	9.1643	9.1036	9.1318	80091508.0
2010-07-30 10:00:00	AAPL	Stock	9.1354	9.2582	9.1304	9.2286	100227512.0
2010-07-30 11:00:00	AAPL	Stock	9.2271	9.2425	9.1839	9.2205	43499876.0
2010-07-30 12:00:00	AAPL	Stock	9.2207	9.245	9.1929	9.2379	30505384.0
2010-07-30 13:00:00	AAPL	Stock	9.2371	9.2446	9.1536	9.1581	37144016.0
2010-07-30 14:00:00	AAPL	Stock	9.1579	9.2161	9.1504	9.1932	41941564.0
2010-07-30 15:00:00	AAPL	Stock	9.1925	9.275	9.1804	9.1889	88545324.0
2010-07-30 16:00:00	AAPL	Stock	9.1857	9.2533	9.1525	9.1857	22281756.0
2010-07-30 17:00:00	AAPL	Stock	9.1843	9.2054	9.1789	9.1821	273924.0
2010-07-30 18:00:00	AAPL	Stock	9.1793	9.1875	9.1714	9.1714	161840.0
2010-07-30 19:00:00	AAPL	Stock	9.1714	9.1786	9.1714	9.1786	70336.0
2010-07-30 07:00:00	MSFT	Stock	26.0	26.0	25.95	25.95	2300.0
2010-07-30 08:00:00	MSFT	Stock	25.9	26.03	25.72	25.84	134183.0
2010-07-30 09:00:00	MSFT	Stock	25.83	25.84	25.35	25.46	15185180.0
2010-07-30 10:00:00	MSFT	Stock	25.46	25.62	25.43	25.51	12234733.0
2010-07-30 11:00:00	MSFT	Stock	25.505	25.72	25.5	25.69	9297828.0
2010-07-30 12:00:00	MSFT	Stock	25.69	25.739	25.54	25.55	6233698.0
2010-07-30 13:00:00	MSFT	Stock	25.55	25.59	25.49	25.55	7325525.0
2010-07-30 14:00:00	MSFT	Stock	25.55	25.72	25.53	25.67	6104437.0
2010-07-30 15:00:00	MSFT	Stock	25.67	25.84	25.65	25.8	18323046.0
2010-07-30 16:00:00	MSFT	Stock	25.8	25.84	25.612	25.77	7511784.0
2010-07-30 17:00:00	MSFT	Stock	25.77	25.8	25.77	25.8	2350.0
2010-07-30 18:00:00	MSFT	Stock	25.8	25.81	25.8	25.81	18575.0
2010-07-30 19:00:00	MSFT	Stock	25.78	25.79	25.78	25.78	1900.0
2010-07-30 07:00:00	NVDA	Stock	0.2265	0.2265	0.2258	0.2258	128000.0
2010-07-30 08:00:00	NVDA	Stock	0.2275	0.2275	0.2258	0.226	1176200.0
2010-07-30 09:00:00	NVDA	Stock	0.226	0.2288	0.223	0.2285	175091640.0
2010-07-30 10:00:00	NVDA	Stock	0.2285	0.2338	0.228	0.2324	234210600.0
2010-07-30 11:00:00	NVDA	Stock	0.2325	0.2332	0.23	0.231	119475040.0
2010-07-30 12:00:00	NVDA	Stock	0.2312	0.2315	0.2298	0.231	59288680.0
2010-07-30 13:00:00	NVDA	Stock	0.2311	0.232	0.2283	0.2285	86640080.0
2010-07-30 14:00:00	NVDA	Stock	0.2285	0.23	0.228	0.228	94766720.0
2010-07-30 15:00:00	NVDA	Stock	0.228	0.2315	0.2278	0.2295	190855280.0
2010-07-30 16:00:00	NVDA	Stock	0.2298	0.2305	0.2288	0.2298	22474600.0
2010-07-30 18:00:00	NVDA	Stock	0.23	0.231	0.2285	0.231	422320.0
2010-07-30 19:00:00	NVDA	Stock	0.2303	0.2305	0.2303	0.2305	52000.0
2010-07-30 08:00:00	AMZN	Stock	5.8135	5.8135	5.778	5.785	70500.0
2010-07-30 09:00:00	AMZN	Stock	5.7825	5.8005	5.7255	5.7555	17821160.0
2010-07-30 10:00:00	AMZN	Stock	5.7525	5.8825	5.7525	5.8655	28761180.0
2010-07-30 11:00:00	AMZN	Stock	5.865	5.8925	5.8365	5.8907	21075720.0
2010-07-30 12:00:00	AMZN	Stock	5.8905	5.903	5.869	5.8945	11215760.0
2010-07-30 13:00:00	AMZN	Stock	5.8949	5.908	5.8265	5.8325	11599180.0
2010-07-30 14:00:00	AMZN	Stock	5.8325	5.884	5.826	5.877	15249580.0
2010-07-30 15:00:00	AMZN	Stock	5.877	5.937	5.8715	5.8945	28399180.0
2010-07-30 16:00:00	AMZN	Stock	5.8945	5.9136	5.8554	5.9	7133400.0
2010-07-30 17:00:00	AMZN	Stock	5.9	5.9	5.88	5.8975	192680.0

> showing 50 of 42,515 rows — these rows as CSV

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