PREVIEW / stock_1hour / 2008-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-10.parquet
  size:    845 KB
  rows:    41,057
  symbols: 3,315

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-10 04:00:00	AAPL	Stock	6.2621	6.2621	6.2621	6.2621	2800.0
2008-07-10 06:00:00	AAPL	Stock	6.2757	6.29	6.2757	6.2757	68488.0
2008-07-10 07:00:00	AAPL	Stock	6.2643	6.3454	6.2564	6.3086	940520.0
2008-07-10 08:00:00	AAPL	Stock	6.3086	6.3239	6.2539	6.2629	4893644.0
2008-07-10 09:00:00	AAPL	Stock	6.2671	6.3214	6.2261	6.2761	117283096.0
2008-07-10 10:00:00	AAPL	Stock	6.2771	6.3279	6.2057	6.2968	151796120.0
2008-07-10 11:00:00	AAPL	Stock	6.2975	6.3336	6.25	6.255	83826316.0
2008-07-10 12:00:00	AAPL	Stock	6.2564	6.31	6.2189	6.2421	96049268.0
2008-07-10 13:00:00	AAPL	Stock	6.2425	6.3071	6.2379	6.2679	79473996.0
2008-07-10 14:00:00	AAPL	Stock	6.2696	6.2811	6.1204	6.1404	119856016.0
2008-07-10 15:00:00	AAPL	Stock	6.1389	6.3089	6.1339	6.3071	160277768.0
2008-07-10 16:00:00	AAPL	Stock	6.3082	6.3196	6.2129	6.3161	10952732.0
2008-07-10 17:00:00	AAPL	Stock	6.3171	6.3482	6.2451	6.3411	1873508.0
2008-07-10 18:00:00	AAPL	Stock	6.3396	6.3539	6.3396	6.3464	540652.0
2008-07-10 19:00:00	AAPL	Stock	6.3436	6.3482	6.3393	6.3479	340928.0
2008-07-10 07:00:00	MSFT	Stock	25.45	25.45	25.45	25.45	650.0
2008-07-10 08:00:00	MSFT	Stock	25.28	25.4	25.28	25.29	12270.0
2008-07-10 09:00:00	MSFT	Stock	25.29	25.67	25.12	25.34	5716000.0
2008-07-10 10:00:00	MSFT	Stock	25.34	25.46	25.01	25.27	10558181.0
2008-07-10 11:00:00	MSFT	Stock	25.26	25.44	25.192	25.38	6456102.0
2008-07-10 12:00:00	MSFT	Stock	25.371	25.55	25.371	25.42	4198494.0
2008-07-10 13:00:00	MSFT	Stock	25.42	25.53	25.4	25.44	4712781.0
2008-07-10 14:00:00	MSFT	Stock	25.44	25.48	24.98	25.01	7629061.0
2008-07-10 15:00:00	MSFT	Stock	25.02	25.46	25.01	25.45	12953728.0
2008-07-10 16:00:00	MSFT	Stock	25.46	25.5	25.06	25.49	2521409.0
2008-07-10 17:00:00	MSFT	Stock	25.49	25.52	25.313	25.52	232542.0
2008-07-10 18:00:00	MSFT	Stock	25.45	25.5	25.45	25.5	865150.0
2008-07-10 19:00:00	MSFT	Stock	25.52	25.55	25.51	25.52	6442.0
2008-07-10 20:00:00	MSFT	Stock	25.45	25.45	25.45	25.45	400.0
2008-07-10 08:00:00	NVDA	Stock	0.2958	0.2958	0.295	0.295	45600.0
2008-07-10 09:00:00	NVDA	Stock	0.2985	0.3	0.2908	0.2945	99633400.0
2008-07-10 10:00:00	NVDA	Stock	0.2945	0.3005	0.2928	0.2988	167998240.0
2008-07-10 11:00:00	NVDA	Stock	0.2988	0.3005	0.2952	0.2998	128331160.0
2008-07-10 12:00:00	NVDA	Stock	0.3	0.3005	0.2958	0.297	156665520.0
2008-07-10 13:00:00	NVDA	Stock	0.2972	0.2992	0.2952	0.2954	119048120.0
2008-07-10 14:00:00	NVDA	Stock	0.2955	0.2968	0.2895	0.2898	148011160.0
2008-07-10 15:00:00	NVDA	Stock	0.2895	0.2955	0.2892	0.2948	209546640.0
2008-07-10 16:00:00	NVDA	Stock	0.2948	0.2958	0.2927	0.2938	17204840.0
2008-07-10 17:00:00	NVDA	Stock	0.2948	0.2948	0.2938	0.2938	840480.0
2008-07-10 18:00:00	NVDA	Stock	0.2945	0.2945	0.2932	0.2938	714760.0
2008-07-10 19:00:00	NVDA	Stock	0.2932	0.2938	0.2875	0.2895	555240.0
2008-07-10 20:00:00	NVDA	Stock	0.2948	0.2948	0.2948	0.2948	552000.0
2008-07-10 07:00:00	AMZN	Stock	3.5655	3.5755	3.5655	3.5755	20800.0
2008-07-10 08:00:00	AMZN	Stock	3.5755	3.598	3.55	3.55	159000.0
2008-07-10 09:00:00	AMZN	Stock	3.55	3.5625	3.4105	3.4437	43841040.0
2008-07-10 10:00:00	AMZN	Stock	3.4455	3.5525	3.3995	3.4945	49915320.0
2008-07-10 11:00:00	AMZN	Stock	3.4944	3.55	3.488	3.5315	16879620.0
2008-07-10 12:00:00	AMZN	Stock	3.5325	3.5885	3.471	3.4755	13748080.0
2008-07-10 13:00:00	AMZN	Stock	3.4755	3.5625	3.475	3.55	16381400.0
2008-07-10 14:00:00	AMZN	Stock	3.55	3.562	3.4555	3.4745	23262980.0

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

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