PREVIEW / stock_1hour / 2007-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-04.parquet
  size:    765 KB
  rows:    37,406
  symbols: 3,040

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
2007-06-04 09:00:00	AAPL	Stock	4.2368	4.3089	4.2107	4.2989	162155168.0
2007-06-04 10:00:00	AAPL	Stock	4.2993	4.3282	4.2804	4.3079	197908732.0
2007-06-04 11:00:00	AAPL	Stock	4.3079	4.3164	4.2839	4.2964	101325728.0
2007-06-04 12:00:00	AAPL	Stock	4.2964	4.3014	4.2286	4.2771	84169176.0
2007-06-04 13:00:00	AAPL	Stock	4.2771	4.2846	4.2696	4.2764	56964544.0
2007-06-04 14:00:00	AAPL	Stock	4.2757	4.3	4.2729	4.2929	86707292.0
2007-06-04 15:00:00	AAPL	Stock	4.2925	4.3446	4.2918	4.3332	180311096.0
2007-06-04 16:00:00	AAPL	Stock	4.3325	4.3332	4.3321	4.3332	3367756.0
2007-06-04 09:00:00	MSFT	Stock	30.42	30.53	30.4	30.43	4185373.0
2007-06-04 10:00:00	MSFT	Stock	30.43	30.66	30.42	30.5	6717807.0
2007-06-04 11:00:00	MSFT	Stock	30.5	30.66	30.45	30.648	4861201.0
2007-06-04 12:00:00	MSFT	Stock	30.64	30.73	30.57	30.73	3137420.0
2007-06-04 13:00:00	MSFT	Stock	30.72	30.76	30.64	30.7	4009558.0
2007-06-04 14:00:00	MSFT	Stock	30.7	30.75	30.69	30.74	4704874.0
2007-06-04 15:00:00	MSFT	Stock	30.74	30.76	30.668	30.69	6973461.0
2007-06-04 16:00:00	MSFT	Stock	30.69	30.715	30.69	30.715	703906.0
2007-06-04 09:00:00	NVDA	Stock	0.575	0.5847	0.5735	0.583	38460960.0
2007-06-04 10:00:00	NVDA	Stock	0.5827	0.5878	0.5798	0.5837	66493500.0
2007-06-04 11:00:00	NVDA	Stock	0.5838	0.5873	0.5833	0.5847	31850640.0
2007-06-04 12:00:00	NVDA	Stock	0.5847	0.5852	0.5827	0.5842	30871380.0
2007-06-04 13:00:00	NVDA	Stock	0.584	0.5842	0.5805	0.5817	24062220.0
2007-06-04 14:00:00	NVDA	Stock	0.5818	0.5845	0.5813	0.582	39917580.0
2007-06-04 15:00:00	NVDA	Stock	0.5818	0.5865	0.5818	0.5842	58773540.0
2007-06-04 16:00:00	NVDA	Stock	0.5842	0.5845	0.5842	0.5842	4554180.0
2007-06-04 06:00:00	AMZN	Stock	3.421	3.421	3.421	3.421	6000.0
2007-06-04 07:00:00	AMZN	Stock	3.4175	3.4175	3.4	3.4	22000.0
2007-06-04 08:00:00	AMZN	Stock	3.4125	3.4125	3.4	3.4	76460.0
2007-06-04 09:00:00	AMZN	Stock	3.4045	3.434	3.386	3.3905	26356520.0
2007-06-04 10:00:00	AMZN	Stock	3.3905	3.427	3.3825	3.413	31820880.0
2007-06-04 11:00:00	AMZN	Stock	3.4135	3.435	3.4055	3.4195	16032840.0
2007-06-04 12:00:00	AMZN	Stock	3.419	3.45	3.418	3.4425	17794680.0
2007-06-04 13:00:00	AMZN	Stock	3.442	3.4475	3.427	3.431	8600760.0
2007-06-04 14:00:00	AMZN	Stock	3.431	3.471	3.4295	3.4665	26216540.0
2007-06-04 15:00:00	AMZN	Stock	3.466	3.5325	3.466	3.5205	95554820.0
2007-06-04 16:00:00	AMZN	Stock	3.523	3.5255	3.5205	3.522	1273240.0
2007-06-04 17:00:00	AMZN	Stock	3.523	3.523	3.516	3.519	482520.0
2007-06-04 18:00:00	AMZN	Stock	3.5215	3.5245	3.5195	3.52	107620.0
2007-06-04 19:00:00	AMZN	Stock	3.519	3.525	3.519	3.525	83640.0
2007-06-04 09:00:00	TLT	Stock	85.83	85.84	85.67	85.73	114900.0
2007-06-04 10:00:00	TLT	Stock	85.73	85.94	85.71	85.9	166700.0
2007-06-04 11:00:00	TLT	Stock	85.91	85.94	85.85	85.92	43100.0
2007-06-04 12:00:00	TLT	Stock	85.89	85.92	85.8	85.83	61000.0
2007-06-04 13:00:00	TLT	Stock	85.8	85.93	85.79	85.9	108500.0
2007-06-04 14:00:00	TLT	Stock	85.9	86.02	85.89	86.01	288600.0
2007-06-04 15:00:00	TLT	Stock	86.01	86.02	85.95	86.0	85500.0
2007-06-04 16:00:00	TLT	Stock	85.98	85.98	85.98	85.98	4700.0
2007-06-04 09:00:00	CL	Stock	33.55	33.55	33.435	33.51	273606.0
2007-06-04 10:00:00	CL	Stock	33.515	33.565	33.505	33.565	290460.0
2007-06-04 11:00:00	CL	Stock	33.555	33.59	33.5	33.505	324564.0
2007-06-04 12:00:00	CL	Stock	33.504	33.64	33.475	33.615	445800.0

> showing 50 of 37,406 rows — these rows as CSV

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