PREVIEW / stock_1hour / 2001-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-21.parquet
  size:    361 KB
  rows:    17,071
  symbols: 1,325

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
2001-08-21 08:00:00	AAPL	Stock	0.3259	0.3259	0.3259	0.3259	5600.0
2001-08-21 09:00:00	AAPL	Stock	0.3234	0.3239	0.3209	0.3216	12510400.0
2001-08-21 10:00:00	AAPL	Stock	0.3218	0.323	0.3216	0.322	12756800.0
2001-08-21 11:00:00	AAPL	Stock	0.3221	0.3239	0.3218	0.3225	11911200.0
2001-08-21 12:00:00	AAPL	Stock	0.3225	0.3236	0.322	0.3223	7772800.0
2001-08-21 13:00:00	AAPL	Stock	0.3221	0.3229	0.3214	0.3221	13613600.0
2001-08-21 14:00:00	AAPL	Stock	0.3221	0.3229	0.3196	0.3209	41837600.0
2001-08-21 15:00:00	AAPL	Stock	0.3207	0.3221	0.3161	0.3202	60508000.0
2001-08-21 16:00:00	AAPL	Stock	0.3195	0.3204	0.3154	0.3154	12101600.0
2001-08-21 17:00:00	AAPL	Stock	0.3154	0.3198	0.3152	0.3198	28000.0
2001-08-21 08:00:00	MSFT	Stock	31.3	31.35	31.25	31.325	10800.0
2001-08-21 09:00:00	MSFT	Stock	31.35	31.56	31.31	31.536	3463400.0
2001-08-21 10:00:00	MSFT	Stock	31.545	31.58	31.365	31.465	3250800.0
2001-08-21 11:00:00	MSFT	Stock	31.455	31.6	31.4435	31.5101	3250000.0
2001-08-21 12:00:00	MSFT	Stock	31.51	31.55	31.345	31.37	2951000.0
2001-08-21 13:00:00	MSFT	Stock	31.37	31.514	31.26	31.51	2902400.0
2001-08-21 14:00:00	MSFT	Stock	31.5	31.575	31.0995	31.12	9402600.0
2001-08-21 15:00:00	MSFT	Stock	31.11	31.145	30.356	30.39	11795600.0
2001-08-21 16:00:00	MSFT	Stock	30.395	31.35	30.25	30.5	2201000.0
2001-08-21 17:00:00	MSFT	Stock	30.27	30.37	30.25	30.315	20400.0
2001-08-21 18:00:00	MSFT	Stock	30.315	30.37	30.255	30.37	4600.0
2001-08-21 08:00:00	NVDA	Stock	0.3465	0.3469	0.3465	0.3469	408000.0
2001-08-21 09:00:00	NVDA	Stock	0.3469	0.3483	0.3388	0.3412	110304000.0
2001-08-21 10:00:00	NVDA	Stock	0.341	0.35	0.3409	0.3483	131856000.0
2001-08-21 11:00:00	NVDA	Stock	0.3483	0.3538	0.3478	0.3531	79152000.0
2001-08-21 12:00:00	NVDA	Stock	0.3533	0.3562	0.353	0.3543	65736000.0
2001-08-21 13:00:00	NVDA	Stock	0.3544	0.3567	0.3542	0.3565	45960000.0
2001-08-21 14:00:00	NVDA	Stock	0.3566	0.3566	0.3448	0.3491	306624000.0
2001-08-21 15:00:00	NVDA	Stock	0.3495	0.3499	0.3389	0.3393	225312000.0
2001-08-21 16:00:00	NVDA	Stock	0.3402	0.3479	0.338	0.3392	20472000.0
2001-08-21 17:00:00	NVDA	Stock	0.3398	0.34	0.3398	0.34	312000.0
2001-08-21 18:00:00	NVDA	Stock	0.34	0.3404	0.34	0.3404	48000.0
2001-08-21 08:00:00	AMZN	Stock	0.53	0.5325	0.5202	0.5325	756000.0
2001-08-21 09:00:00	AMZN	Stock	0.5325	0.5395	0.5265	0.529	18540000.0
2001-08-21 10:00:00	AMZN	Stock	0.529	0.5355	0.5245	0.5335	16246000.0
2001-08-21 11:00:00	AMZN	Stock	0.5335	0.5385	0.5305	0.5335	11464000.0
2001-08-21 12:00:00	AMZN	Stock	0.5335	0.534	0.5245	0.5295	4770000.0
2001-08-21 13:00:00	AMZN	Stock	0.529	0.5345	0.5285	0.5325	3924000.0
2001-08-21 14:00:00	AMZN	Stock	0.5325	0.538	0.512	0.5135	12042000.0
2001-08-21 15:00:00	AMZN	Stock	0.5125	0.514	0.494	0.495	15608000.0
2001-08-21 16:00:00	AMZN	Stock	0.494	0.4945	0.491	0.4925	1994000.0
2001-08-21 17:00:00	AMZN	Stock	0.493	0.4945	0.493	0.4945	114000.0
2001-08-21 18:00:00	AMZN	Stock	0.4945	0.498	0.4945	0.498	4000.0
2001-08-21 09:00:00	CL	Stock	27.775	27.775	27.625	27.74	187200.0
2001-08-21 10:00:00	CL	Stock	27.735	27.88	27.735	27.88	329200.0
2001-08-21 11:00:00	CL	Stock	27.88	27.975	27.825	27.83	240800.0
2001-08-21 12:00:00	CL	Stock	27.83	27.975	27.805	27.955	301400.0
2001-08-21 13:00:00	CL	Stock	27.955	28.025	27.92	28.005	582600.0
2001-08-21 14:00:00	CL	Stock	28.0	28.025	27.85	27.855	379600.0
2001-08-21 15:00:00	CL	Stock	27.855	27.855	27.725	27.75	838400.0

> showing 50 of 17,071 rows — these rows as CSV

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