PREVIEW / stock_1hour / 2009-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-30.parquet
  size:    796 KB
  rows:    38,931
  symbols: 3,293

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-01-30 07:00:00	AAPL	Stock	3.3039	3.3039	3.3039	3.3039	2800.0
2009-01-30 08:00:00	AAPL	Stock	3.2946	3.3475	3.2786	3.3057	3323684.0
2009-01-30 09:00:00	AAPL	Stock	3.3057	3.3436	3.2764	3.2771	86516724.0
2009-01-30 10:00:00	AAPL	Stock	3.2768	3.2875	3.2475	3.2632	108486196.0
2009-01-30 11:00:00	AAPL	Stock	3.2629	3.2764	3.2436	3.2539	60361980.0
2009-01-30 12:00:00	AAPL	Stock	3.2543	3.2575	3.2357	3.25	50923824.0
2009-01-30 13:00:00	AAPL	Stock	3.2496	3.2736	3.2368	3.2564	70962192.0
2009-01-30 14:00:00	AAPL	Stock	3.2564	3.2707	3.2439	3.2446	59787728.0
2009-01-30 15:00:00	AAPL	Stock	3.2443	3.25	3.2146	3.2193	138709732.0
2009-01-30 16:00:00	AAPL	Stock	3.2196	3.265	3.2179	3.2445	31480652.0
2009-01-30 17:00:00	AAPL	Stock	3.2207	3.2232	3.2143	3.2175	212996.0
2009-01-30 18:00:00	AAPL	Stock	3.2175	3.225	3.2175	3.2196	185556.0
2009-01-30 19:00:00	AAPL	Stock	3.2207	3.2268	3.2189	3.2261	195132.0
2009-01-30 05:00:00	MSFT	Stock	17.59	17.59	17.59	17.59	200.0
2009-01-30 07:00:00	MSFT	Stock	17.5	17.5	17.5	17.5	100.0
2009-01-30 08:00:00	MSFT	Stock	17.65	17.8	17.59	17.68	23578.0
2009-01-30 09:00:00	MSFT	Stock	17.72	17.79	17.5	17.5	3892399.0
2009-01-30 10:00:00	MSFT	Stock	17.5	17.58	17.29	17.36	8174132.0
2009-01-30 11:00:00	MSFT	Stock	17.368	17.4	17.16	17.23	6256647.0
2009-01-30 12:00:00	MSFT	Stock	17.23	17.34	17.188	17.31	6092927.0
2009-01-30 13:00:00	MSFT	Stock	17.31	17.39	17.16	17.21	7273739.0
2009-01-30 14:00:00	MSFT	Stock	17.2	17.32	17.18	17.21	6044759.0
2009-01-30 15:00:00	MSFT	Stock	17.21	17.28	17.11	17.11	14596714.0
2009-01-30 16:00:00	MSFT	Stock	17.11	17.281	17.094	17.237	7387388.0
2009-01-30 17:00:00	MSFT	Stock	17.17	17.266	17.1	17.15	477918.0
2009-01-30 18:00:00	MSFT	Stock	17.16	17.2	17.15	17.15	11693.0
2009-01-30 19:00:00	MSFT	Stock	17.19	17.19	17.13	17.15	8260.0
2009-01-30 08:00:00	NVDA	Stock	0.2122	0.2128	0.2122	0.2128	40000.0
2009-01-30 09:00:00	NVDA	Stock	0.2072	0.211	0.2043	0.2055	43742440.0
2009-01-30 10:00:00	NVDA	Stock	0.2058	0.206	0.1985	0.201	86173720.0
2009-01-30 11:00:00	NVDA	Stock	0.201	0.2014	0.1962	0.2002	78333400.0
2009-01-30 12:00:00	NVDA	Stock	0.2002	0.2013	0.1988	0.2013	30875360.0
2009-01-30 13:00:00	NVDA	Stock	0.2013	0.2015	0.1992	0.2007	39566640.0
2009-01-30 14:00:00	NVDA	Stock	0.2007	0.2018	0.1998	0.2005	60783520.0
2009-01-30 15:00:00	NVDA	Stock	0.2005	0.2013	0.1972	0.1988	130627720.0
2009-01-30 16:00:00	NVDA	Stock	0.1988	0.2006	0.1979	0.1988	31333160.0
2009-01-30 17:00:00	NVDA	Stock	0.1988	0.1988	0.1975	0.1975	40000.0
2009-01-30 06:00:00	AMZN	Stock	2.825	2.825	2.825	2.825	20000.0
2009-01-30 07:00:00	AMZN	Stock	2.84	2.8825	2.8205	2.875	505600.0
2009-01-30 08:00:00	AMZN	Stock	2.875	2.8915	2.835	2.8575	8212240.0
2009-01-30 09:00:00	AMZN	Stock	2.8595	2.97	2.835	2.923	171772880.0
2009-01-30 10:00:00	AMZN	Stock	2.9245	2.98	2.923	2.961	148025100.0
2009-01-30 11:00:00	AMZN	Stock	2.961	2.987	2.9275	2.951	124504640.0
2009-01-30 12:00:00	AMZN	Stock	2.9508	2.9515	2.905	2.917	68689780.0
2009-01-30 13:00:00	AMZN	Stock	2.9165	2.954	2.908	2.953	65132420.0
2009-01-30 14:00:00	AMZN	Stock	2.9525	2.9575	2.9255	2.93	60920720.0
2009-01-30 15:00:00	AMZN	Stock	2.9315	2.975	2.929	2.941	129314780.0
2009-01-30 16:00:00	AMZN	Stock	2.947	2.9528	2.475	2.9528	16692780.0
2009-01-30 17:00:00	AMZN	Stock	2.955	3.0	2.941	2.951	134600.0
2009-01-30 18:00:00	AMZN	Stock	2.95	2.951	2.947	2.9475	145400.0

> showing 50 of 38,931 rows — these rows as CSV

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