PREVIEW / stock_1hour / 2007-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-18.parquet
  size:    668 KB
  rows:    31,835
  symbols: 2,490

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
2007-01-18 04:00:00	AAPL	Stock	3.3604	3.3604	3.3471	3.3536	700000.0
2007-01-18 05:00:00	AAPL	Stock	3.3507	3.3536	3.3429	3.3429	255780.0
2007-01-18 06:00:00	AAPL	Stock	3.3432	3.3432	3.3161	3.3339	540120.0
2007-01-18 07:00:00	AAPL	Stock	3.3354	3.3543	3.3232	3.325	7963648.0
2007-01-18 08:00:00	AAPL	Stock	3.3286	3.3393	3.305	3.3268	52528532.0
2007-01-18 09:00:00	AAPL	Stock	3.3271	3.3314	3.2232	3.2289	612618440.0
2007-01-18 10:00:00	AAPL	Stock	3.2296	3.2464	3.1918	3.2314	545537132.0
2007-01-18 11:00:00	AAPL	Stock	3.2314	3.2679	3.23	3.2543	322553616.0
2007-01-18 12:00:00	AAPL	Stock	3.2546	3.2614	3.2282	3.2446	189576436.0
2007-01-18 13:00:00	AAPL	Stock	3.2443	3.25	3.2164	3.2175	134508276.0
2007-01-18 14:00:00	AAPL	Stock	3.2175	3.2643	3.1986	3.2054	218142344.0
2007-01-18 15:00:00	AAPL	Stock	3.2057	3.2161	3.1807	3.1811	257648468.0
2007-01-18 16:00:00	AAPL	Stock	3.1807	3.1839	3.1607	3.1614	10719296.0
2007-01-18 17:00:00	AAPL	Stock	3.1611	3.1664	3.1607	3.1661	1879248.0
2007-01-18 18:00:00	AAPL	Stock	3.1671	3.1779	3.165	3.1657	1808268.0
2007-01-18 19:00:00	AAPL	Stock	3.1657	3.1693	3.1607	3.1646	877296.0
2007-01-18 04:00:00	MSFT	Stock	31.1	31.1	31.1	31.1	2000.0
2007-01-18 07:00:00	MSFT	Stock	31.07	31.07	31.07	31.07	900.0
2007-01-18 08:00:00	MSFT	Stock	31.03	31.09	31.02	31.03	29770.0
2007-01-18 09:00:00	MSFT	Stock	31.1	31.37	31.03	31.26	9244609.0
2007-01-18 10:00:00	MSFT	Stock	31.25	31.25	30.9	30.99	9132459.0
2007-01-18 11:00:00	MSFT	Stock	30.98	31.04	30.95	30.98	5542628.0
2007-01-18 12:00:00	MSFT	Stock	30.98	31.06	30.86	30.992	6223920.0
2007-01-18 13:00:00	MSFT	Stock	30.99	31.1	30.96	30.98	3291780.0
2007-01-18 14:00:00	MSFT	Stock	30.98	31.04	30.8	30.84	7323363.0
2007-01-18 15:00:00	MSFT	Stock	30.84	31.05	30.81	30.99	12561778.0
2007-01-18 16:00:00	MSFT	Stock	30.99	31.04	30.89	30.9	548060.0
2007-01-18 17:00:00	MSFT	Stock	30.9	31.0	30.87	30.87	359005.0
2007-01-18 18:00:00	MSFT	Stock	30.87	30.996	30.85	30.88	15296.0
2007-01-18 19:00:00	MSFT	Stock	30.88	30.93	30.85	30.89	3840.0
2007-01-18 08:00:00	NVDA	Stock	0.571	0.571	0.5667	0.57	200100.0
2007-01-18 09:00:00	NVDA	Stock	0.5672	0.5708	0.5555	0.5617	187568580.0
2007-01-18 10:00:00	NVDA	Stock	0.5615	0.5617	0.5452	0.5483	223776660.0
2007-01-18 11:00:00	NVDA	Stock	0.5482	0.5522	0.5477	0.5482	141864180.0
2007-01-18 12:00:00	NVDA	Stock	0.5482	0.5502	0.5417	0.5418	158856840.0
2007-01-18 13:00:00	NVDA	Stock	0.5418	0.5418	0.5318	0.533	225510360.0
2007-01-18 14:00:00	NVDA	Stock	0.533	0.5333	0.521	0.5237	271652820.0
2007-01-18 15:00:00	NVDA	Stock	0.5237	0.5335	0.5222	0.5278	248993760.0
2007-01-18 16:00:00	NVDA	Stock	0.528	0.5305	0.5255	0.5305	1242420.0
2007-01-18 17:00:00	NVDA	Stock	0.527	0.5292	0.5267	0.5267	160980.0
2007-01-18 18:00:00	NVDA	Stock	0.5268	0.5305	0.5268	0.5305	132000.0
2007-01-18 19:00:00	NVDA	Stock	0.5263	0.5263	0.5262	0.5262	33900.0
2007-01-18 08:00:00	AMZN	Stock	1.89	1.89	1.875	1.882	86000.0
2007-01-18 09:00:00	AMZN	Stock	1.882	1.8825	1.864	1.8705	26662560.0
2007-01-18 10:00:00	AMZN	Stock	1.87	1.8725	1.8465	1.847	50731920.0
2007-01-18 11:00:00	AMZN	Stock	1.8475	1.8525	1.8455	1.849	19461680.0
2007-01-18 12:00:00	AMZN	Stock	1.849	1.8585	1.8465	1.8505	15059500.0
2007-01-18 13:00:00	AMZN	Stock	1.851	1.856	1.85	1.852	9231380.0
2007-01-18 14:00:00	AMZN	Stock	1.8525	1.8525	1.836	1.8435	18055040.0
2007-01-18 15:00:00	AMZN	Stock	1.844	1.8585	1.837	1.85	37742040.0

> showing 50 of 31,835 rows — these rows as CSV

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