PREVIEW / stock_1hour / 2009-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-09.parquet
  size:    851 KB
  rows:    41,791
  symbols: 3,357

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-06-09 04:00:00	AAPL	Stock	5.1679	5.1679	5.1679	5.1679	2800.0
2009-06-09 06:00:00	AAPL	Stock	5.13	5.1564	5.13	5.1564	16800.0
2009-06-09 07:00:00	AAPL	Stock	5.1461	5.1654	5.1461	5.1654	500864.0
2009-06-09 08:00:00	AAPL	Stock	5.1654	5.1696	5.1321	5.1521	2021796.0
2009-06-09 09:00:00	AAPL	Stock	5.1521	5.1607	5.0714	5.1443	123735696.0
2009-06-09 10:00:00	AAPL	Stock	5.1443	5.1629	5.0407	5.0593	145922364.0
2009-06-09 11:00:00	AAPL	Stock	5.0596	5.0696	5.0196	5.0396	92924104.0
2009-06-09 12:00:00	AAPL	Stock	5.0393	5.0986	5.0368	5.0957	70264264.0
2009-06-09 13:00:00	AAPL	Stock	5.0954	5.1189	5.0871	5.117	55497540.0
2009-06-09 14:00:00	AAPL	Stock	5.1179	5.1246	5.0993	5.1111	61791940.0
2009-06-09 15:00:00	AAPL	Stock	5.1114	5.1321	5.09	5.0929	103261396.0
2009-06-09 16:00:00	AAPL	Stock	5.0971	5.1389	5.0536	5.0536	12177368.0
2009-06-09 17:00:00	AAPL	Stock	5.0575	5.0679	5.0536	5.0536	728476.0
2009-06-09 18:00:00	AAPL	Stock	5.0554	5.0971	5.0393	5.0504	776636.0
2009-06-09 19:00:00	AAPL	Stock	5.0554	5.0625	5.0536	5.0607	403004.0
2009-06-09 07:00:00	MSFT	Stock	22.09	22.1	22.09	22.1	500.0
2009-06-09 08:00:00	MSFT	Stock	22.14	22.15	22.08	22.1	8405.0
2009-06-09 09:00:00	MSFT	Stock	22.1	22.32	21.88	22.2	5767330.0
2009-06-09 10:00:00	MSFT	Stock	22.19	22.3	21.99	22.06	7331243.0
2009-06-09 11:00:00	MSFT	Stock	22.06	22.17	22.0	22.08	8141866.0
2009-06-09 12:00:00	MSFT	Stock	22.085	22.14	22.06	22.11	4588319.0
2009-06-09 13:00:00	MSFT	Stock	22.1	22.113	21.99	22.1	4211831.0
2009-06-09 14:00:00	MSFT	Stock	22.1	22.17	22.07	22.12	4238343.0
2009-06-09 15:00:00	MSFT	Stock	22.13	22.205	22.04	22.11	10079283.0
2009-06-09 16:00:00	MSFT	Stock	22.11	22.137	22.0	22.0	1703812.0
2009-06-09 17:00:00	MSFT	Stock	22.0	22.162	22.0	22.11	82715.0
2009-06-09 18:00:00	MSFT	Stock	22.08	22.094	22.05	22.094	40494.0
2009-06-09 19:00:00	MSFT	Stock	22.08	22.1	22.05	22.05	900.0
2009-06-09 09:00:00	NVDA	Stock	0.2712	0.2805	0.271	0.2765	138593640.0
2009-06-09 10:00:00	NVDA	Stock	0.2768	0.279	0.2752	0.2756	90013240.0
2009-06-09 11:00:00	NVDA	Stock	0.2758	0.2788	0.2745	0.2783	59714760.0
2009-06-09 12:00:00	NVDA	Stock	0.278	0.2838	0.2778	0.2818	115858800.0
2009-06-09 13:00:00	NVDA	Stock	0.282	0.2838	0.2818	0.2835	62057920.0
2009-06-09 14:00:00	NVDA	Stock	0.2835	0.287	0.2832	0.2855	86416920.0
2009-06-09 15:00:00	NVDA	Stock	0.2858	0.2862	0.284	0.2845	142446120.0
2009-06-09 16:00:00	NVDA	Stock	0.284	0.2875	0.2811	0.2835	26212520.0
2009-06-09 18:00:00	NVDA	Stock	0.2855	0.2855	0.2812	0.283	116360.0
2009-06-09 04:00:00	AMZN	Stock	4.3345	4.3345	4.3345	4.3345	2000.0
2009-06-09 08:00:00	AMZN	Stock	4.3575	4.36	4.32	4.33	24000.0
2009-06-09 09:00:00	AMZN	Stock	4.33	4.3715	4.3285	4.3444	10676660.0
2009-06-09 10:00:00	AMZN	Stock	4.345	4.3665	4.3085	4.328	15627140.0
2009-06-09 11:00:00	AMZN	Stock	4.328	4.3395	4.313	4.32	8596200.0
2009-06-09 12:00:00	AMZN	Stock	4.3195	4.365	4.319	4.3618	11245180.0
2009-06-09 13:00:00	AMZN	Stock	4.361	4.3725	4.34	4.3716	8632680.0
2009-06-09 14:00:00	AMZN	Stock	4.3725	4.3835	4.3395	4.35	14612220.0
2009-06-09 15:00:00	AMZN	Stock	4.35	4.3695	4.3355	4.3535	16494160.0
2009-06-09 16:00:00	AMZN	Stock	4.353	4.36	4.325	4.3575	1963560.0
2009-06-09 17:00:00	AMZN	Stock	4.338	4.345	4.337	4.345	32000.0
2009-06-09 18:00:00	AMZN	Stock	4.354	4.354	4.3425	4.3425	32080.0
2009-06-09 19:00:00	AMZN	Stock	4.3475	4.3475	4.3475	4.3475	4000.0

> showing 50 of 41,791 rows — these rows as CSV

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