PREVIEW / stock_1hour / 2009-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-19.parquet
  size:    809 KB
  rows:    40,125
  symbols: 3,323

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-02-19 07:00:00	AAPL	Stock	3.3168	3.3339	3.3157	3.3214	788704.0
2009-02-19 08:00:00	AAPL	Stock	3.3261	3.3704	3.3214	3.3443	4349268.0
2009-02-19 09:00:00	AAPL	Stock	3.3421	3.3661	3.2775	3.3096	136254636.0
2009-02-19 10:00:00	AAPL	Stock	3.3096	3.3189	3.2482	3.2489	162034880.0
2009-02-19 11:00:00	AAPL	Stock	3.2482	3.2768	3.2346	3.2454	115747968.0
2009-02-19 12:00:00	AAPL	Stock	3.2454	3.2589	3.2261	3.2454	82851804.0
2009-02-19 13:00:00	AAPL	Stock	3.2454	3.2586	3.2264	3.2311	73961580.0
2009-02-19 14:00:00	AAPL	Stock	3.2311	3.2479	3.2243	3.2375	90069140.0
2009-02-19 15:00:00	AAPL	Stock	3.2375	3.3019	3.2182	3.2371	154837620.0
2009-02-19 16:00:00	AAPL	Stock	3.2371	3.2607	3.2296	3.2339	46512116.0
2009-02-19 17:00:00	AAPL	Stock	3.2393	3.2479	3.2236	3.2321	351372.0
2009-02-19 18:00:00	AAPL	Stock	3.2371	3.2393	3.2268	3.2268	20930252.0
2009-02-19 19:00:00	AAPL	Stock	3.2293	3.2336	3.225	3.225	193284.0
2009-02-19 07:00:00	MSFT	Stock	18.32	18.32	18.2	18.26	1021.0
2009-02-19 08:00:00	MSFT	Stock	18.12	18.33	18.12	18.33	371637.0
2009-02-19 09:00:00	MSFT	Stock	18.3	18.4	18.08	18.14	6248013.0
2009-02-19 10:00:00	MSFT	Stock	18.15	18.16	18.0	18.009	6472460.0
2009-02-19 11:00:00	MSFT	Stock	18.005	18.11	17.93	17.931	5082169.0
2009-02-19 12:00:00	MSFT	Stock	17.94	18.0	17.81	17.922	5118955.0
2009-02-19 13:00:00	MSFT	Stock	17.93	18.02	17.87	17.94	4104285.0
2009-02-19 14:00:00	MSFT	Stock	17.94	18.0	17.9	17.972	5627511.0
2009-02-19 15:00:00	MSFT	Stock	17.98	18.02	17.87	17.91	12140756.0
2009-02-19 16:00:00	MSFT	Stock	17.91	18.009	17.82	17.936	3178092.0
2009-02-19 17:00:00	MSFT	Stock	17.9	17.9	17.86	17.89	3340.0
2009-02-19 18:00:00	MSFT	Stock	17.91	17.91	17.87	17.9	458865.0
2009-02-19 19:00:00	MSFT	Stock	17.9	17.95	17.9	17.91	1799.0
2009-02-19 08:00:00	NVDA	Stock	0.201	0.2062	0.201	0.205	1665280.0
2009-02-19 09:00:00	NVDA	Stock	0.205	0.2068	0.199	0.2	73507760.0
2009-02-19 10:00:00	NVDA	Stock	0.1998	0.2007	0.1923	0.1923	106488200.0
2009-02-19 11:00:00	NVDA	Stock	0.1923	0.194	0.1898	0.1903	87563160.0
2009-02-19 12:00:00	NVDA	Stock	0.1905	0.1933	0.19	0.1918	68793240.0
2009-02-19 13:00:00	NVDA	Stock	0.1918	0.1938	0.1905	0.1908	62826880.0
2009-02-19 14:00:00	NVDA	Stock	0.191	0.1928	0.189	0.1896	72046720.0
2009-02-19 15:00:00	NVDA	Stock	0.1895	0.1898	0.1855	0.1855	231690720.0
2009-02-19 16:00:00	NVDA	Stock	0.186	0.1919	0.1854	0.1905	18436160.0
2009-02-19 17:00:00	NVDA	Stock	0.1875	0.1875	0.1875	0.1875	40000.0
2009-02-19 18:00:00	NVDA	Stock	0.1873	0.1873	0.1873	0.1873	40000.0
2009-02-19 19:00:00	NVDA	Stock	0.1855	0.1855	0.1855	0.1855	40000.0
2009-02-19 08:00:00	AMZN	Stock	3.1175	3.1275	3.1175	3.1275	481520.0
2009-02-19 09:00:00	AMZN	Stock	3.1275	3.209	3.1255	3.1915	23158740.0
2009-02-19 10:00:00	AMZN	Stock	3.1915	3.1977	3.1175	3.1275	21785060.0
2009-02-19 11:00:00	AMZN	Stock	3.127	3.159	3.113	3.119	12501160.0
2009-02-19 12:00:00	AMZN	Stock	3.12	3.1235	3.098	3.112	11218020.0
2009-02-19 13:00:00	AMZN	Stock	3.1125	3.145	3.105	3.126	11263860.0
2009-02-19 14:00:00	AMZN	Stock	3.1265	3.134	3.103	3.1238	15820180.0
2009-02-19 15:00:00	AMZN	Stock	3.124	3.1305	3.0835	3.0975	33639780.0
2009-02-19 16:00:00	AMZN	Stock	3.0975	3.1333	3.095	3.0975	4986580.0
2009-02-19 17:00:00	AMZN	Stock	3.0965	3.0965	3.0965	3.0965	4000.0
2009-02-19 18:00:00	AMZN	Stock	3.099	3.099	3.099	3.099	19500.0
2009-02-19 19:00:00	AMZN	Stock	3.096	3.096	3.086	3.086	28520.0

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

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