PREVIEW / stock_1hour / 2008-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-25.parquet
  size:    801 KB
  rows:    40,027
  symbols: 3,266

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-02-25 04:00:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	5600.0
2008-02-25 05:00:00	AAPL	Stock	4.2857	4.2857	4.2829	4.2836	38780.0
2008-02-25 06:00:00	AAPL	Stock	4.2804	4.2857	4.2718	4.2857	39200.0
2008-02-25 07:00:00	AAPL	Stock	4.2789	4.2811	4.2571	4.2571	252000.0
2008-02-25 08:00:00	AAPL	Stock	4.2732	4.2732	4.225	4.2375	5402012.0
2008-02-25 09:00:00	AAPL	Stock	4.2375	4.2918	4.2029	4.2036	170710120.0
2008-02-25 10:00:00	AAPL	Stock	4.2036	4.2736	4.185	4.2421	268730980.0
2008-02-25 11:00:00	AAPL	Stock	4.2418	4.2468	4.2093	4.2129	117385548.0
2008-02-25 12:00:00	AAPL	Stock	4.2121	4.2307	4.1964	4.2136	99568616.0
2008-02-25 13:00:00	AAPL	Stock	4.2136	4.2175	4.1666	4.1846	114053128.0
2008-02-25 14:00:00	AAPL	Stock	4.1836	4.2554	4.1696	4.2025	189158200.0
2008-02-25 15:00:00	AAPL	Stock	4.2014	4.2804	4.1889	4.2707	257882716.0
2008-02-25 16:00:00	AAPL	Stock	4.2696	4.2804	4.2114	4.2679	31741332.0
2008-02-25 17:00:00	AAPL	Stock	4.2679	4.2764	4.2643	4.2679	716296.0
2008-02-25 18:00:00	AAPL	Stock	4.2654	4.2714	4.2607	4.2607	647500.0
2008-02-25 19:00:00	AAPL	Stock	4.2632	4.2654	4.2518	4.2654	484512.0
2008-02-25 06:00:00	MSFT	Stock	27.75	27.85	27.75	27.85	1400.0
2008-02-25 07:00:00	MSFT	Stock	27.74	27.77	27.74	27.74	2400.0
2008-02-25 08:00:00	MSFT	Stock	27.74	27.77	27.55	27.64	84389.0
2008-02-25 09:00:00	MSFT	Stock	27.65	27.98	27.48	27.91	12007272.0
2008-02-25 10:00:00	MSFT	Stock	27.91	28.24	27.91	27.95	21109944.0
2008-02-25 11:00:00	MSFT	Stock	27.96	28.01	27.65	27.67	9884692.0
2008-02-25 12:00:00	MSFT	Stock	27.67	27.72	27.58	27.698	9567524.0
2008-02-25 13:00:00	MSFT	Stock	27.7	27.79	27.6	27.68	7887749.0
2008-02-25 14:00:00	MSFT	Stock	27.69	27.96	27.66	27.91	24688395.0
2008-02-25 15:00:00	MSFT	Stock	27.91	27.96	27.8	27.82	22209683.0
2008-02-25 16:00:00	MSFT	Stock	27.82	27.872	27.728	27.84	2507963.0
2008-02-25 17:00:00	MSFT	Stock	27.84	27.85	27.82	27.82	9960.0
2008-02-25 18:00:00	MSFT	Stock	27.82	27.82	27.76	27.79	31585.0
2008-02-25 19:00:00	MSFT	Stock	27.75	27.85	27.75	27.85	13168.0
2008-02-25 08:00:00	NVDA	Stock	0.5565	0.5565	0.5538	0.5538	273600.0
2008-02-25 09:00:00	NVDA	Stock	0.5538	0.5588	0.543	0.5475	68142280.0
2008-02-25 10:00:00	NVDA	Stock	0.5478	0.564	0.5455	0.5618	133878720.0
2008-02-25 11:00:00	NVDA	Stock	0.5615	0.5632	0.55	0.5505	93036800.0
2008-02-25 12:00:00	NVDA	Stock	0.5508	0.5538	0.5458	0.5532	61188920.0
2008-02-25 13:00:00	NVDA	Stock	0.5532	0.5552	0.5485	0.5534	61202320.0
2008-02-25 14:00:00	NVDA	Stock	0.5532	0.5632	0.5505	0.5555	95701800.0
2008-02-25 15:00:00	NVDA	Stock	0.5555	0.5638	0.5535	0.558	108892640.0
2008-02-25 16:00:00	NVDA	Stock	0.558	0.5596	0.5525	0.5588	32547760.0
2008-02-25 17:00:00	NVDA	Stock	0.5578	0.5588	0.5578	0.558	200000.0
2008-02-25 18:00:00	NVDA	Stock	0.5588	0.5595	0.5562	0.5562	172000.0
2008-02-25 19:00:00	NVDA	Stock	0.5575	0.5575	0.5575	0.5575	4000.0
2008-02-25 07:00:00	AMZN	Stock	3.6035	3.604	3.5595	3.599	22600.0
2008-02-25 08:00:00	AMZN	Stock	3.6005	3.6305	3.575	3.58	43000.0
2008-02-25 09:00:00	AMZN	Stock	3.581	3.626	3.5705	3.5845	16899440.0
2008-02-25 10:00:00	AMZN	Stock	3.5835	3.67	3.5715	3.6315	36194880.0
2008-02-25 11:00:00	AMZN	Stock	3.6315	3.641	3.6065	3.633	15610400.0
2008-02-25 12:00:00	AMZN	Stock	3.632	3.635	3.6165	3.6345	14014620.0
2008-02-25 13:00:00	AMZN	Stock	3.6335	3.635	3.5885	3.61	12873140.0
2008-02-25 14:00:00	AMZN	Stock	3.61	3.648	3.5895	3.6385	26026040.0

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

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