PREVIEW / stock_1hour / 2007-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-27.parquet
  size:    823 KB
  rows:    40,824
  symbols: 3,225

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-11-27 04:00:00	AAPL	Stock	6.2125	6.245	6.2125	6.245	22400.0
2007-11-27 05:00:00	AAPL	Stock	6.25	6.2557	6.25	6.2557	77000.0
2007-11-27 06:00:00	AAPL	Stock	6.25	6.2568	6.25	6.2568	25116.0
2007-11-27 07:00:00	AAPL	Stock	6.2289	6.2618	6.2289	6.2321	1242388.0
2007-11-27 08:00:00	AAPL	Stock	6.2289	6.25	6.1622	6.2482	7433468.0
2007-11-27 09:00:00	AAPL	Stock	6.2486	6.2782	6.225	6.2617	157052588.0
2007-11-27 10:00:00	AAPL	Stock	6.26	6.2714	6.0718	6.2526	348307008.0
2007-11-27 11:00:00	AAPL	Stock	6.2532	6.2611	6.1911	6.1964	156751168.0
2007-11-27 12:00:00	AAPL	Stock	6.1964	6.2582	6.1904	6.2261	114340296.0
2007-11-27 13:00:00	AAPL	Stock	6.2257	6.2429	6.1521	6.1725	123328100.0
2007-11-27 14:00:00	AAPL	Stock	6.1718	6.1939	6.1164	6.1607	164536736.0
2007-11-27 15:00:00	AAPL	Stock	6.1618	6.2429	6.1411	6.2428	225980972.0
2007-11-27 16:00:00	AAPL	Stock	6.2414	6.2432	6.1859	6.2225	16258200.0
2007-11-27 17:00:00	AAPL	Stock	6.2232	6.2311	6.2232	6.2232	442540.0
2007-11-27 18:00:00	AAPL	Stock	6.2296	6.2321	6.2232	6.23	553000.0
2007-11-27 19:00:00	AAPL	Stock	6.225	6.2432	6.225	6.235	711312.0
2007-11-27 07:00:00	MSFT	Stock	33.28	33.28	33.2	33.2	2000.0
2007-11-27 08:00:00	MSFT	Stock	33.25	33.27	32.97	33.2	30263.0
2007-11-27 09:00:00	MSFT	Stock	33.2	33.5	33.15	33.32	7361524.0
2007-11-27 10:00:00	MSFT	Stock	33.32	33.6	33.04	33.5	15019485.0
2007-11-27 11:00:00	MSFT	Stock	33.5	33.55	33.31	33.32	7387442.0
2007-11-27 12:00:00	MSFT	Stock	33.32	33.48	33.25	33.35	7184614.0
2007-11-27 13:00:00	MSFT	Stock	33.36	33.41	33.14	33.25	6909040.0
2007-11-27 14:00:00	MSFT	Stock	33.25	33.26	32.68	32.9	13153580.0
2007-11-27 15:00:00	MSFT	Stock	32.9	33.28	32.78	33.04	23526855.0
2007-11-27 16:00:00	MSFT	Stock	33.0	33.201	32.8	33.201	3470155.0
2007-11-27 17:00:00	MSFT	Stock	33.05	33.362	32.96	33.02	29102.0
2007-11-27 18:00:00	MSFT	Stock	33.02	33.12	32.98	33.12	105774.0
2007-11-27 19:00:00	MSFT	Stock	33.12	33.14	33.0	33.0	1687.0
2007-11-27 08:00:00	NVDA	Stock	0.738	0.7463	0.738	0.7463	72040.0
2007-11-27 09:00:00	NVDA	Stock	0.7483	0.755	0.7428	0.7485	35705800.0
2007-11-27 10:00:00	NVDA	Stock	0.7488	0.762	0.743	0.762	60196320.0
2007-11-27 11:00:00	NVDA	Stock	0.762	0.7675	0.7568	0.7655	49114480.0
2007-11-27 12:00:00	NVDA	Stock	0.7655	0.772	0.7635	0.768	51511360.0
2007-11-27 13:00:00	NVDA	Stock	0.768	0.7713	0.7635	0.7638	47710480.0
2007-11-27 14:00:00	NVDA	Stock	0.7638	0.7645	0.75	0.7558	82970320.0
2007-11-27 15:00:00	NVDA	Stock	0.756	0.7708	0.7518	0.7692	98662200.0
2007-11-27 16:00:00	NVDA	Stock	0.7692	0.7721	0.7589	0.7637	20888160.0
2007-11-27 17:00:00	NVDA	Stock	0.7692	0.7698	0.7638	0.7675	722000.0
2007-11-27 18:00:00	NVDA	Stock	0.7638	0.7638	0.7638	0.7638	60000.0
2007-11-27 19:00:00	NVDA	Stock	0.7648	0.7648	0.7648	0.7648	6200.0
2007-11-27 08:00:00	AMZN	Stock	4.0652	4.129	4.0652	4.11	119440.0
2007-11-27 09:00:00	AMZN	Stock	4.1085	4.1729	4.1025	4.15	19227000.0
2007-11-27 10:00:00	AMZN	Stock	4.15	4.218	4.1105	4.218	28776860.0
2007-11-27 11:00:00	AMZN	Stock	4.216	4.2245	4.186	4.1948	23789360.0
2007-11-27 12:00:00	AMZN	Stock	4.195	4.2065	4.18	4.195	16184280.0
2007-11-27 13:00:00	AMZN	Stock	4.195	4.2095	4.18	4.1815	12589640.0
2007-11-27 14:00:00	AMZN	Stock	4.182	4.2	4.165	4.188	22976220.0
2007-11-27 15:00:00	AMZN	Stock	4.1878	4.2825	4.1805	4.2785	43108180.0
2007-11-27 16:00:00	AMZN	Stock	4.2795	4.2815	4.069	4.2459	1674140.0

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

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