PREVIEW / stock_1hour / 2008-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-16.parquet
  size:    832 KB
  rows:    40,091
  symbols: 3,305

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-06-16 04:00:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-06-16 05:00:00	AAPL	Stock	6.1711	6.1711	6.1429	6.1429	11200.0
2008-06-16 06:00:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-06-16 07:00:00	AAPL	Stock	6.1893	6.2036	6.175	6.1782	545300.0
2008-06-16 08:00:00	AAPL	Stock	6.1782	6.1943	6.1193	6.1429	4365312.0
2008-06-16 09:00:00	AAPL	Stock	6.1389	6.1871	6.0664	6.105	135251872.0
2008-06-16 10:00:00	AAPL	Stock	6.1054	6.1779	6.0382	6.1168	186676868.0
2008-06-16 11:00:00	AAPL	Stock	6.1175	6.1964	6.1	6.1779	149759848.0
2008-06-16 12:00:00	AAPL	Stock	6.1779	6.2496	6.1539	6.2286	104667136.0
2008-06-16 13:00:00	AAPL	Stock	6.2296	6.3536	6.2107	6.335	152737620.0
2008-06-16 14:00:00	AAPL	Stock	6.3361	6.3482	6.2946	6.3457	117917884.0
2008-06-16 15:00:00	AAPL	Stock	6.3454	6.3464	6.2861	6.3139	138012616.0
2008-06-16 16:00:00	AAPL	Stock	6.3157	6.318	6.204	6.3139	12976264.0
2008-06-16 17:00:00	AAPL	Stock	6.3114	6.3189	6.3107	6.3186	708036.0
2008-06-16 18:00:00	AAPL	Stock	6.3182	6.3193	6.315	6.315	209412.0
2008-06-16 19:00:00	AAPL	Stock	6.3189	6.3239	6.3157	6.3204	215712.0
2008-06-16 20:00:00	AAPL	Stock	6.155	6.155	6.155	6.155	164640.0
2008-06-16 07:00:00	MSFT	Stock	28.9	28.9	28.9	28.9	10130.0
2008-06-16 08:00:00	MSFT	Stock	29.05	29.13	28.98	29.07	128141.0
2008-06-16 09:00:00	MSFT	Stock	29.03	29.09	28.64	28.87	8659880.0
2008-06-16 10:00:00	MSFT	Stock	28.86	29.11	28.76	29.01	12108288.0
2008-06-16 11:00:00	MSFT	Stock	29.0	29.11	28.83	28.9	10380981.0
2008-06-16 12:00:00	MSFT	Stock	28.9	28.91	28.77	28.811	5351089.0
2008-06-16 13:00:00	MSFT	Stock	28.815	29.05	28.79	28.97	6927714.0
2008-06-16 14:00:00	MSFT	Stock	28.96	28.97	28.83	28.842	6765496.0
2008-06-16 15:00:00	MSFT	Stock	28.85	29.05	28.78	28.91	14775766.0
2008-06-16 16:00:00	MSFT	Stock	28.91	29.01	28.8	28.84	5711355.0
2008-06-16 17:00:00	MSFT	Stock	28.93	28.93	28.85	28.88	13554.0
2008-06-16 18:00:00	MSFT	Stock	28.88	28.88	28.8	28.88	3390.0
2008-06-16 19:00:00	MSFT	Stock	28.85	28.88	28.85	28.88	1942.0
2008-06-16 20:00:00	MSFT	Stock	28.87	28.87	28.87	28.87	1034.0
2008-06-16 09:00:00	NVDA	Stock	0.5327	0.5327	0.5213	0.5247	85970960.0
2008-06-16 10:00:00	NVDA	Stock	0.5247	0.5315	0.524	0.5312	85710720.0
2008-06-16 11:00:00	NVDA	Stock	0.531	0.532	0.5253	0.5255	74099120.0
2008-06-16 12:00:00	NVDA	Stock	0.5255	0.5268	0.5213	0.5238	58951760.0
2008-06-16 13:00:00	NVDA	Stock	0.524	0.53	0.5213	0.5265	109717640.0
2008-06-16 14:00:00	NVDA	Stock	0.5262	0.5265	0.5228	0.5262	58335440.0
2008-06-16 15:00:00	NVDA	Stock	0.5262	0.5272	0.5242	0.5253	117057240.0
2008-06-16 16:00:00	NVDA	Stock	0.525	0.5269	0.5239	0.5255	11990080.0
2008-06-16 17:00:00	NVDA	Stock	0.5232	0.5255	0.5232	0.525	67120.0
2008-06-16 18:00:00	NVDA	Stock	0.526	0.5295	0.526	0.5285	87560.0
2008-06-16 19:00:00	NVDA	Stock	0.5262	0.5275	0.5262	0.5262	127960.0
2008-06-16 20:00:00	NVDA	Stock	0.528	0.528	0.528	0.528	10680.0
2008-06-16 09:00:00	AMZN	Stock	3.9385	3.9915	3.9205	3.9855	10373880.0
2008-06-16 10:00:00	AMZN	Stock	3.986	4.0625	3.9725	4.0595	20081520.0
2008-06-16 11:00:00	AMZN	Stock	4.0585	4.0585	4.012	4.0425	11677240.0
2008-06-16 12:00:00	AMZN	Stock	4.0425	4.057	4.0265	4.0445	8209200.0
2008-06-16 13:00:00	AMZN	Stock	4.045	4.0965	4.035	4.0905	15969000.0
2008-06-16 14:00:00	AMZN	Stock	4.092	4.1265	4.0845	4.1125	16828320.0
2008-06-16 15:00:00	AMZN	Stock	4.112	4.112	4.078	4.086	23972600.0

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

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