PREVIEW / stock_1hour / 2007-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-21.parquet
  size:    663 KB
  rows:    31,741
  symbols: 2,532

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-02-21 07:00:00	AAPL	Stock	3.0686	3.0821	3.0679	3.0807	314748.0
2007-02-21 08:00:00	AAPL	Stock	3.0814	3.0821	3.0607	3.0714	4459672.0
2007-02-21 09:00:00	AAPL	Stock	3.0721	3.1339	3.07	3.1246	199476340.0
2007-02-21 10:00:00	AAPL	Stock	3.125	3.1643	3.1229	3.1593	261803416.0
2007-02-21 11:00:00	AAPL	Stock	3.1589	3.1771	3.1504	3.1725	160738088.0
2007-02-21 12:00:00	AAPL	Stock	3.1721	3.1754	3.1636	3.1718	78742580.0
2007-02-21 13:00:00	AAPL	Stock	3.1718	3.1957	3.1707	3.1786	146492192.0
2007-02-21 14:00:00	AAPL	Stock	3.1786	3.1896	3.1668	3.1886	126051968.0
2007-02-21 15:00:00	AAPL	Stock	3.1889	3.1961	3.175	3.1857	161734944.0
2007-02-21 16:00:00	AAPL	Stock	3.1854	3.1875	3.1825	3.1832	2979452.0
2007-02-21 17:00:00	AAPL	Stock	3.1832	3.1857	3.1821	3.1836	378812.0
2007-02-21 18:00:00	AAPL	Stock	3.1854	3.1857	3.1821	3.1854	296940.0
2007-02-21 19:00:00	AAPL	Stock	3.1839	3.1854	3.1818	3.1854	409668.0
2007-02-21 08:00:00	MSFT	Stock	28.7	28.81	28.7	28.73	41630.0
2007-02-21 09:00:00	MSFT	Stock	28.73	28.98	28.7	28.93	8370522.0
2007-02-21 10:00:00	MSFT	Stock	28.93	29.18	28.91	29.12	9643834.0
2007-02-21 11:00:00	MSFT	Stock	29.12	29.12	28.9	29.08	8561320.0
2007-02-21 12:00:00	MSFT	Stock	29.08	29.15	28.99	29.1	6735560.0
2007-02-21 13:00:00	MSFT	Stock	29.1	29.22	29.1	29.14	6790424.0
2007-02-21 14:00:00	MSFT	Stock	29.14	29.23	29.13	29.23	6934613.0
2007-02-21 15:00:00	MSFT	Stock	29.22	29.39	29.2	29.34	15888196.0
2007-02-21 16:00:00	MSFT	Stock	29.35	29.44	29.31	29.34	668662.0
2007-02-21 17:00:00	MSFT	Stock	29.35	29.35	29.33	29.35	36623.0
2007-02-21 18:00:00	MSFT	Stock	29.35	29.38	29.34	29.38	11041.0
2007-02-21 19:00:00	MSFT	Stock	29.38	29.4	29.33	29.33	3216.0
2007-02-21 08:00:00	NVDA	Stock	0.5502	0.5502	0.55	0.55	72000.0
2007-02-21 09:00:00	NVDA	Stock	0.548	0.5515	0.5405	0.5423	67886280.0
2007-02-21 10:00:00	NVDA	Stock	0.5423	0.5442	0.5373	0.5393	110669160.0
2007-02-21 11:00:00	NVDA	Stock	0.5395	0.5432	0.5365	0.5378	150227940.0
2007-02-21 12:00:00	NVDA	Stock	0.5378	0.5408	0.5368	0.54	64931940.0
2007-02-21 13:00:00	NVDA	Stock	0.5402	0.5403	0.537	0.539	56055060.0
2007-02-21 14:00:00	NVDA	Stock	0.5388	0.5418	0.5378	0.5407	65977500.0
2007-02-21 15:00:00	NVDA	Stock	0.5405	0.5425	0.5395	0.5422	100333560.0
2007-02-21 16:00:00	NVDA	Stock	0.542	0.5492	0.5415	0.5463	2855640.0
2007-02-21 17:00:00	NVDA	Stock	0.5458	0.5463	0.5442	0.545	212820.0
2007-02-21 18:00:00	NVDA	Stock	0.5448	0.5448	0.5447	0.5447	47820.0
2007-02-21 09:00:00	AMZN	Stock	2.0645	2.065	2.0505	2.0564	11245520.0
2007-02-21 10:00:00	AMZN	Stock	2.0564	2.061	2.046	2.0585	17230920.0
2007-02-21 11:00:00	AMZN	Stock	2.058	2.066	2.0495	2.0615	14436440.0
2007-02-21 12:00:00	AMZN	Stock	2.0615	2.0645	2.053	2.06	7524120.0
2007-02-21 13:00:00	AMZN	Stock	2.06	2.061	2.0525	2.0565	6677320.0
2007-02-21 14:00:00	AMZN	Stock	2.0565	2.0615	2.0525	2.0588	10277920.0
2007-02-21 15:00:00	AMZN	Stock	2.0588	2.064	2.0555	2.063	17345200.0
2007-02-21 16:00:00	AMZN	Stock	2.061	2.064	2.0605	2.064	555980.0
2007-02-21 17:00:00	AMZN	Stock	2.063	2.063	2.063	2.063	20000.0
2007-02-21 19:00:00	AMZN	Stock	2.065	2.065	2.065	2.065	4000.0
2007-02-21 09:00:00	CL	Stock	34.285	34.36	34.25	34.3	254600.0
2007-02-21 10:00:00	CL	Stock	34.29	34.35	34.265	34.325	320400.0
2007-02-21 11:00:00	CL	Stock	34.325	34.325	34.25	34.27	264800.0
2007-02-21 12:00:00	CL	Stock	34.265	34.325	34.24	34.305	212000.0

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

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