PREVIEW / stock_1hour / 2008-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-13.parquet
  size:    831 KB
  rows:    39,894
  symbols: 3,329

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-13 06:00:00	AAPL	Stock	6.1221	6.1429	6.1221	6.1429	47600.0
2008-06-13 07:00:00	AAPL	Stock	6.1596	6.1604	6.1393	6.1464	214172.0
2008-06-13 08:00:00	AAPL	Stock	6.1543	6.2096	6.1071	6.1682	7598584.0
2008-06-13 09:00:00	AAPL	Stock	6.1686	6.1836	5.9039	6.0536	308852068.0
2008-06-13 10:00:00	AAPL	Stock	6.0521	6.1732	6.0179	6.1539	306849144.0
2008-06-13 11:00:00	AAPL	Stock	6.1549	6.22	6.1339	6.1786	185385060.0
2008-06-13 12:00:00	AAPL	Stock	6.1783	6.1964	6.0943	6.1136	94632944.0
2008-06-13 13:00:00	AAPL	Stock	6.1136	6.1179	6.0243	6.0447	117771780.0
2008-06-13 14:00:00	AAPL	Stock	6.0448	6.1411	6.0286	6.1389	118306776.0
2008-06-13 15:00:00	AAPL	Stock	6.1379	6.1596	6.0704	6.1532	147632156.0
2008-06-13 16:00:00	AAPL	Stock	6.1554	6.1596	6.0935	6.1561	15834140.0
2008-06-13 17:00:00	AAPL	Stock	6.1482	6.1586	6.1446	6.145	553504.0
2008-06-13 18:00:00	AAPL	Stock	6.145	6.1554	6.145	6.1511	126000.0
2008-06-13 19:00:00	AAPL	Stock	6.1511	6.1604	6.1482	6.1554	421792.0
2008-06-13 07:00:00	MSFT	Stock	28.07	28.07	28.07	28.07	190.0
2008-06-13 08:00:00	MSFT	Stock	28.5	28.5	28.15	28.34	2628885.0
2008-06-13 09:00:00	MSFT	Stock	28.34	29.13	28.31	29.1	26604871.0
2008-06-13 10:00:00	MSFT	Stock	29.1	29.57	29.09	29.16	36943424.0
2008-06-13 11:00:00	MSFT	Stock	29.165	29.42	29.15	29.28	12825310.0
2008-06-13 12:00:00	MSFT	Stock	29.29	29.34	28.99	29.04	9472695.0
2008-06-13 13:00:00	MSFT	Stock	29.03	29.07	28.89	28.94	8235995.0
2008-06-13 14:00:00	MSFT	Stock	28.95	29.0	28.77	28.98	11251377.0
2008-06-13 15:00:00	MSFT	Stock	28.97	29.07	28.91	29.05	14643985.0
2008-06-13 16:00:00	MSFT	Stock	29.06	29.4	28.75	29.05	3366954.0
2008-06-13 17:00:00	MSFT	Stock	29.05	29.05	28.98	29.02	93855.0
2008-06-13 18:00:00	MSFT	Stock	29.07	29.07	29.01	29.03	7848.0
2008-06-13 19:00:00	MSFT	Stock	29.01	29.03	29.01	29.03	4710.0
2008-06-13 08:00:00	NVDA	Stock	0.5425	0.5425	0.5425	0.5425	4000.0
2008-06-13 09:00:00	NVDA	Stock	0.5425	0.5425	0.517	0.5293	122214720.0
2008-06-13 10:00:00	NVDA	Stock	0.5293	0.5388	0.5287	0.5293	122978400.0
2008-06-13 11:00:00	NVDA	Stock	0.5295	0.5367	0.5293	0.5358	64512240.0
2008-06-13 12:00:00	NVDA	Stock	0.5355	0.5365	0.525	0.528	69439320.0
2008-06-13 13:00:00	NVDA	Stock	0.5282	0.5362	0.5225	0.5242	72741520.0
2008-06-13 14:00:00	NVDA	Stock	0.524	0.5287	0.521	0.5285	91668280.0
2008-06-13 15:00:00	NVDA	Stock	0.5285	0.533	0.5245	0.5327	127089440.0
2008-06-13 16:00:00	NVDA	Stock	0.5327	0.5327	0.5268	0.5268	27659960.0
2008-06-13 18:00:00	NVDA	Stock	0.535	0.535	0.535	0.535	4000.0
2008-06-13 19:00:00	NVDA	Stock	0.5352	0.5352	0.5352	0.5352	10000.0
2008-06-13 08:00:00	AMZN	Stock	3.8	3.825	3.8	3.825	15000.0
2008-06-13 09:00:00	AMZN	Stock	3.825	3.944	3.8245	3.9365	20358140.0
2008-06-13 10:00:00	AMZN	Stock	3.938	4.0	3.9365	3.9615	30781180.0
2008-06-13 11:00:00	AMZN	Stock	3.962	3.9915	3.9505	3.9535	9646140.0
2008-06-13 12:00:00	AMZN	Stock	3.9535	3.9865	3.9425	3.954	10860560.0
2008-06-13 13:00:00	AMZN	Stock	3.9535	3.959	3.909	3.914	8050760.0
2008-06-13 14:00:00	AMZN	Stock	3.913	3.951	3.9035	3.946	8895020.0
2008-06-13 15:00:00	AMZN	Stock	3.946	3.9835	3.9395	3.9565	23329360.0
2008-06-13 16:00:00	AMZN	Stock	3.956	3.9585	3.946	3.9585	5396940.0
2008-06-13 17:00:00	AMZN	Stock	3.9525	3.9525	3.9525	3.9525	6000.0
2008-06-13 08:00:00	TLT	Stock	89.05	89.45	88.87	89.26	66616.0
2008-06-13 09:00:00	TLT	Stock	89.38	89.41	88.8	89.25	392711.0

> showing 50 of 39,894 rows — these rows as CSV

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