PREVIEW / stock_1hour / 2009-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-08.parquet
  size:    813 KB
  rows:    40,934
  symbols: 3,299

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
2009-04-08 04:00:00	AAPL	Stock	4.0954	4.0954	4.0579	4.0579	15960.0
2009-04-08 05:00:00	AAPL	Stock	4.0643	4.0704	4.0643	4.0704	14000.0
2009-04-08 06:00:00	AAPL	Stock	4.0786	4.0786	4.0786	4.0786	14000.0
2009-04-08 07:00:00	AAPL	Stock	4.0954	4.1071	4.0954	4.0982	112000.0
2009-04-08 08:00:00	AAPL	Stock	4.0982	4.135	4.0982	4.1321	999936.0
2009-04-08 09:00:00	AAPL	Stock	4.1325	4.1711	4.1164	4.1575	59787868.0
2009-04-08 10:00:00	AAPL	Stock	4.1575	4.1596	4.0921	4.1129	86012528.0
2009-04-08 11:00:00	AAPL	Stock	4.1121	4.1389	4.1011	4.1136	62520276.0
2009-04-08 12:00:00	AAPL	Stock	4.1136	4.1607	4.1093	4.1525	47370400.0
2009-04-08 13:00:00	AAPL	Stock	4.1525	4.1529	4.1321	4.1407	38948280.0
2009-04-08 14:00:00	AAPL	Stock	4.1407	4.1418	4.1211	4.1286	56453488.0
2009-04-08 15:00:00	AAPL	Stock	4.1285	4.1557	4.1118	4.1543	87970232.0
2009-04-08 16:00:00	AAPL	Stock	4.1543	4.1621	4.1175	4.1589	6652744.0
2009-04-08 17:00:00	AAPL	Stock	4.1543	4.1643	4.1543	4.1546	157668.0
2009-04-08 18:00:00	AAPL	Stock	4.1546	4.1664	4.1543	4.1661	421876.0
2009-04-08 19:00:00	AAPL	Stock	4.1686	4.1696	4.1575	4.1575	91224.0
2009-04-08 07:00:00	MSFT	Stock	18.91	18.91	18.91	18.91	100.0
2009-04-08 08:00:00	MSFT	Stock	18.77	18.92	18.71	18.91	22655.0
2009-04-08 09:00:00	MSFT	Stock	18.91	19.28	18.9	19.27	5285866.0
2009-04-08 10:00:00	MSFT	Stock	19.27	19.31	19.02	19.09	6825095.0
2009-04-08 11:00:00	MSFT	Stock	19.09	19.47	19.068	19.41	10332088.0
2009-04-08 12:00:00	MSFT	Stock	19.415	19.62	19.29	19.58	8836668.0
2009-04-08 13:00:00	MSFT	Stock	19.58	19.59	19.4	19.415	4621487.0
2009-04-08 14:00:00	MSFT	Stock	19.416	19.42	19.21	19.24	6941582.0
2009-04-08 15:00:00	MSFT	Stock	19.25	19.26	19.14	19.2	10800308.0
2009-04-08 16:00:00	MSFT	Stock	19.2	19.44	19.15	19.22	1825940.0
2009-04-08 17:00:00	MSFT	Stock	19.19	19.27	19.19	19.22	9363.0
2009-04-08 18:00:00	MSFT	Stock	19.22	19.25	19.16	19.23	175541.0
2009-04-08 19:00:00	MSFT	Stock	19.25	19.25	19.25	19.25	580.0
2009-04-08 08:00:00	NVDA	Stock	0.2755	0.2788	0.275	0.2788	1020000.0
2009-04-08 09:00:00	NVDA	Stock	0.2785	0.2832	0.2768	0.2807	91701200.0
2009-04-08 10:00:00	NVDA	Stock	0.2811	0.283	0.2748	0.2825	156153200.0
2009-04-08 11:00:00	NVDA	Stock	0.2822	0.2858	0.2822	0.284	107334960.0
2009-04-08 12:00:00	NVDA	Stock	0.284	0.286	0.2828	0.2848	55232000.0
2009-04-08 13:00:00	NVDA	Stock	0.2848	0.2858	0.282	0.2854	74860880.0
2009-04-08 14:00:00	NVDA	Stock	0.2852	0.2855	0.282	0.283	113905640.0
2009-04-08 15:00:00	NVDA	Stock	0.2831	0.2852	0.281	0.2852	118873240.0
2009-04-08 16:00:00	NVDA	Stock	0.286	0.286	0.282	0.2852	4790800.0
2009-04-08 17:00:00	NVDA	Stock	0.2852	0.2855	0.2805	0.285	249280.0
2009-04-08 18:00:00	NVDA	Stock	0.285	0.285	0.2848	0.285	88000.0
2009-04-08 19:00:00	NVDA	Stock	0.285	0.2858	0.2848	0.2858	122760.0
2009-04-08 05:00:00	AMZN	Stock	3.738	3.738	3.738	3.738	2000.0
2009-04-08 08:00:00	AMZN	Stock	3.775	3.8125	3.7695	3.795	136920.0
2009-04-08 09:00:00	AMZN	Stock	3.8	3.8235	3.7845	3.792	9584500.0
2009-04-08 10:00:00	AMZN	Stock	3.792	3.817	3.7285	3.7455	19830500.0
2009-04-08 11:00:00	AMZN	Stock	3.7455	3.804	3.7385	3.797	14619040.0
2009-04-08 12:00:00	AMZN	Stock	3.797	3.847	3.793	3.834	12619140.0
2009-04-08 13:00:00	AMZN	Stock	3.834	3.846	3.8155	3.824	11776540.0
2009-04-08 14:00:00	AMZN	Stock	3.8245	3.838	3.7985	3.8215	15494320.0
2009-04-08 15:00:00	AMZN	Stock	3.821	3.8555	3.8015	3.8555	26524040.0

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

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