PREVIEW / stock_1hour / 2009-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-15.parquet
  size:    892 KB
  rows:    43,290
  symbols: 3,379

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-09-15 07:00:00	AAPL	Stock	6.2071	6.2071	6.1879	6.2018	47600.0
2009-09-15 08:00:00	AAPL	Stock	6.2043	6.2289	6.2036	6.225	4593036.0
2009-09-15 09:00:00	AAPL	Stock	6.2275	6.2486	6.1996	6.2286	64611904.0
2009-09-15 10:00:00	AAPL	Stock	6.2275	6.25	6.2107	6.2457	69641348.0
2009-09-15 11:00:00	AAPL	Stock	6.2454	6.2689	6.2332	6.2671	58644824.0
2009-09-15 12:00:00	AAPL	Stock	6.2671	6.2732	6.2582	6.2661	27546792.0
2009-09-15 13:00:00	AAPL	Stock	6.2661	6.2686	6.2571	6.2596	35405636.0
2009-09-15 14:00:00	AAPL	Stock	6.2596	6.2632	6.2436	6.2564	36882944.0
2009-09-15 15:00:00	AAPL	Stock	6.2568	6.2679	6.2482	6.2557	62641600.0
2009-09-15 16:00:00	AAPL	Stock	6.2557	6.2601	6.2469	6.25	27044052.0
2009-09-15 17:00:00	AAPL	Stock	6.2557	6.2557	6.2496	6.2496	440860.0
2009-09-15 18:00:00	AAPL	Stock	6.2493	6.3429	6.2493	6.3304	9592576.0
2009-09-15 19:00:00	AAPL	Stock	6.3293	6.3432	6.3293	6.3393	1864044.0
2009-09-15 08:00:00	MSFT	Stock	24.95	25.0	24.91	25.0	245012.0
2009-09-15 09:00:00	MSFT	Stock	25.0	25.15	24.86	25.05	4281170.0
2009-09-15 10:00:00	MSFT	Stock	25.06	25.15	24.97	25.095	6633899.0
2009-09-15 11:00:00	MSFT	Stock	25.09	25.15	25.02	25.12	5236893.0
2009-09-15 12:00:00	MSFT	Stock	25.11	25.14	25.06	25.1	3836347.0
2009-09-15 13:00:00	MSFT	Stock	25.09	25.13	25.06	25.11	3243062.0
2009-09-15 14:00:00	MSFT	Stock	25.112	25.19	25.07	25.19	6402724.0
2009-09-15 15:00:00	MSFT	Stock	25.19	25.27	25.152	25.2	9254272.0
2009-09-15 16:00:00	MSFT	Stock	25.2	25.27	25.02	25.21	3207667.0
2009-09-15 17:00:00	MSFT	Stock	25.0	25.21	25.0	25.13	106348.0
2009-09-15 18:00:00	MSFT	Stock	25.12	25.2	25.12	25.15	2325.0
2009-09-15 19:00:00	MSFT	Stock	25.15	25.15	25.15	25.15	850.0
2009-09-15 08:00:00	NVDA	Stock	0.4013	0.405	0.4013	0.4043	1675640.0
2009-09-15 09:00:00	NVDA	Stock	0.4045	0.4105	0.4013	0.4089	67851120.0
2009-09-15 10:00:00	NVDA	Stock	0.409	0.4138	0.406	0.4125	147178520.0
2009-09-15 11:00:00	NVDA	Stock	0.4128	0.414	0.411	0.4119	65377800.0
2009-09-15 12:00:00	NVDA	Stock	0.4119	0.414	0.4112	0.4135	40068560.0
2009-09-15 13:00:00	NVDA	Stock	0.4136	0.4145	0.4125	0.4135	39292480.0
2009-09-15 14:00:00	NVDA	Stock	0.4135	0.414	0.4095	0.4095	60455680.0
2009-09-15 15:00:00	NVDA	Stock	0.4095	0.411	0.4085	0.4093	91873800.0
2009-09-15 16:00:00	NVDA	Stock	0.4095	0.4135	0.4088	0.4135	30334920.0
2009-09-15 17:00:00	NVDA	Stock	0.4095	0.4125	0.4095	0.4118	284240.0
2009-09-15 08:00:00	AMZN	Stock	4.193	4.228	4.1905	4.2275	669760.0
2009-09-15 09:00:00	AMZN	Stock	4.2375	4.2395	4.166	4.178	15477980.0
2009-09-15 10:00:00	AMZN	Stock	4.177	4.186	4.1395	4.186	17621880.0
2009-09-15 11:00:00	AMZN	Stock	4.185	4.1875	4.146	4.1725	11124380.0
2009-09-15 12:00:00	AMZN	Stock	4.1721	4.191	4.161	4.1875	7170580.0
2009-09-15 13:00:00	AMZN	Stock	4.1865	4.1975	4.1765	4.1865	6906320.0
2009-09-15 14:00:00	AMZN	Stock	4.1865	4.1865	4.166	4.1772	6886700.0
2009-09-15 15:00:00	AMZN	Stock	4.177	4.2035	4.1715	4.177	18621900.0
2009-09-15 16:00:00	AMZN	Stock	4.1765	4.183	4.175	4.1765	4143960.0
2009-09-15 17:00:00	AMZN	Stock	4.193	4.193	4.175	4.175	87340.0
2009-09-15 18:00:00	AMZN	Stock	4.175	4.175	4.175	4.175	4000.0
2009-09-15 19:00:00	AMZN	Stock	4.175	4.215	4.175	4.215	127500.0
2009-09-15 08:00:00	TLT	Stock	95.47	95.5	94.97	95.16	15391.0
2009-09-15 09:00:00	TLT	Stock	95.14	95.32	95.03	95.11	459033.0
2009-09-15 10:00:00	TLT	Stock	95.11	95.66	95.11	95.29	465587.0

> showing 50 of 43,290 rows — these rows as CSV

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