PREVIEW / stock_1hour / 2008-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-15.parquet
  size:    838 KB
  rows:    40,968
  symbols: 3,365

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
2008-07-15 04:00:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-07-15 05:00:00	AAPL	Stock	6.1607	6.1607	6.1607	6.1607	2800.0
2008-07-15 06:00:00	AAPL	Stock	6.1325	6.1325	6.0911	6.0911	288400.0
2008-07-15 07:00:00	AAPL	Stock	6.1161	6.1225	6.0661	6.1054	778960.0
2008-07-15 08:00:00	AAPL	Stock	6.0868	6.1357	6.0854	6.1275	4388020.0
2008-07-15 09:00:00	AAPL	Stock	6.1286	6.1782	6.0393	6.0821	135593696.0
2008-07-15 10:00:00	AAPL	Stock	6.0821	6.0854	5.9425	6.0471	235637640.0
2008-07-15 11:00:00	AAPL	Stock	6.0479	6.1525	5.9829	6.0729	172406696.0
2008-07-15 12:00:00	AAPL	Stock	6.0739	6.205	6.0557	6.1714	144983020.0
2008-07-15 13:00:00	AAPL	Stock	6.1711	6.1957	6.0893	6.1229	87307948.0
2008-07-15 14:00:00	AAPL	Stock	6.1225	6.1607	6.0929	6.1489	87481464.0
2008-07-15 15:00:00	AAPL	Stock	6.1489	6.1882	6.0564	6.0564	143140284.0
2008-07-15 16:00:00	AAPL	Stock	6.0586	6.1286	6.05	6.1161	16979424.0
2008-07-15 17:00:00	AAPL	Stock	6.1161	6.1256	6.0921	6.0929	513100.0
2008-07-15 18:00:00	AAPL	Stock	6.0929	6.1118	6.0896	6.1	335020.0
2008-07-15 19:00:00	AAPL	Stock	6.1	6.125	6.1	6.1064	258216.0
2008-07-15 07:00:00	MSFT	Stock	24.92	25.04	24.92	24.92	1100.0
2008-07-15 08:00:00	MSFT	Stock	25.0	25.15	24.92	25.15	42880.0
2008-07-15 09:00:00	MSFT	Stock	25.1	25.48	24.92	25.41	8389155.0
2008-07-15 10:00:00	MSFT	Stock	25.42	25.9	25.18	25.793	18122852.0
2008-07-15 11:00:00	MSFT	Stock	25.8	26.4	25.76	26.04	16776384.0
2008-07-15 12:00:00	MSFT	Stock	26.05	26.34	25.95	26.219	8818208.0
2008-07-15 13:00:00	MSFT	Stock	26.21	26.35	26.04	26.29	9081771.0
2008-07-15 14:00:00	MSFT	Stock	26.3	26.56	26.21	26.492	10165370.0
2008-07-15 15:00:00	MSFT	Stock	26.5	26.64	26.1	26.14	16524009.0
2008-07-15 16:00:00	MSFT	Stock	26.149	26.35	25.297	26.15	3439361.0
2008-07-15 17:00:00	MSFT	Stock	26.25	26.25	26.2	26.24	8290.0
2008-07-15 18:00:00	MSFT	Stock	26.25	26.28	26.2	26.2	7110.0
2008-07-15 19:00:00	MSFT	Stock	26.2	26.24	26.2	26.24	570.0
2008-07-15 08:00:00	NVDA	Stock	0.2778	0.278	0.2738	0.2738	277400.0
2008-07-15 09:00:00	NVDA	Stock	0.2738	0.276	0.2688	0.2715	82974080.0
2008-07-15 10:00:00	NVDA	Stock	0.2715	0.275	0.2675	0.2718	197952080.0
2008-07-15 11:00:00	NVDA	Stock	0.2718	0.282	0.2715	0.2815	135565760.0
2008-07-15 12:00:00	NVDA	Stock	0.2815	0.2845	0.279	0.2825	127023520.0
2008-07-15 13:00:00	NVDA	Stock	0.2825	0.2872	0.2818	0.2852	104045200.0
2008-07-15 14:00:00	NVDA	Stock	0.2855	0.2872	0.2828	0.2842	154144880.0
2008-07-15 15:00:00	NVDA	Stock	0.2842	0.285	0.2792	0.2812	296781920.0
2008-07-15 16:00:00	NVDA	Stock	0.2812	0.2868	0.2788	0.2815	19305360.0
2008-07-15 17:00:00	NVDA	Stock	0.2812	0.2848	0.28	0.28	128000.0
2008-07-15 18:00:00	NVDA	Stock	0.28	0.2845	0.28	0.2845	52000.0
2008-07-15 19:00:00	NVDA	Stock	0.2845	0.287	0.2828	0.287	104000.0
2008-07-15 08:00:00	AMZN	Stock	3.2995	3.2995	3.253	3.275	54000.0
2008-07-15 09:00:00	AMZN	Stock	3.275	3.314	3.1985	3.2035	23468920.0
2008-07-15 10:00:00	AMZN	Stock	3.2045	3.2325	3.1495	3.2255	51456700.0
2008-07-15 11:00:00	AMZN	Stock	3.225	3.294	3.2015	3.26	31464120.0
2008-07-15 12:00:00	AMZN	Stock	3.26	3.373	3.2496	3.335	26059380.0
2008-07-15 13:00:00	AMZN	Stock	3.3345	3.387	3.325	3.374	26344340.0
2008-07-15 14:00:00	AMZN	Stock	3.374	3.404	3.337	3.396	21983280.0
2008-07-15 15:00:00	AMZN	Stock	3.3975	3.431	3.351	3.3515	35318420.0
2008-07-15 16:00:00	AMZN	Stock	3.3515	3.3785	3.2864	3.3515	7945460.0

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

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