PREVIEW / stock_1hour / 2001-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-06.parquet
  size:    364 KB
  rows:    17,116
  symbols: 1,328

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-09-06 08:00:00	AAPL	Stock	0.3312	0.3312	0.3295	0.3295	621600.0
2001-09-06 09:00:00	AAPL	Stock	0.327	0.3373	0.3263	0.3321	42274400.0
2001-09-06 10:00:00	AAPL	Stock	0.3329	0.338	0.327	0.33	46110400.0
2001-09-06 11:00:00	AAPL	Stock	0.33	0.33	0.3254	0.3266	26678400.0
2001-09-06 12:00:00	AAPL	Stock	0.3268	0.3277	0.3236	0.3263	29114400.0
2001-09-06 13:00:00	AAPL	Stock	0.3259	0.3286	0.3227	0.3245	18636800.0
2001-09-06 14:00:00	AAPL	Stock	0.3245	0.3248	0.3202	0.3223	25810400.0
2001-09-06 15:00:00	AAPL	Stock	0.3223	0.3232	0.3152	0.3164	47426400.0
2001-09-06 16:00:00	AAPL	Stock	0.3164	0.322	0.3149	0.322	6927200.0
2001-09-06 17:00:00	AAPL	Stock	0.3164	0.32	0.3164	0.32	3612000.0
2001-09-06 08:00:00	MSFT	Stock	28.8	28.8	28.125	28.14	1438800.0
2001-09-06 09:00:00	MSFT	Stock	28.17	28.34	28.1	28.245	10591800.0
2001-09-06 10:00:00	MSFT	Stock	28.23	29.195	27.975	28.756	34574000.0
2001-09-06 11:00:00	MSFT	Stock	28.765	28.77	28.355	28.6	10101600.0
2001-09-06 12:00:00	MSFT	Stock	28.6	28.9	28.29	28.785	10137000.0
2001-09-06 13:00:00	MSFT	Stock	28.79	28.91	28.525	28.7755	9558200.0
2001-09-06 14:00:00	MSFT	Stock	28.7845	28.7845	28.335	28.4	9852600.0
2001-09-06 15:00:00	MSFT	Stock	28.39	28.415	27.95	28.005	15012600.0
2001-09-06 16:00:00	MSFT	Stock	28.025	28.7	27.86	28.285	3974000.0
2001-09-06 17:00:00	MSFT	Stock	28.01	28.355	28.01	28.3	601200.0
2001-09-06 18:00:00	MSFT	Stock	28.425	28.425	28.005	28.35	68800.0
2001-09-06 08:00:00	NVDA	Stock	0.3313	0.3313	0.3279	0.3304	2424000.0
2001-09-06 09:00:00	NVDA	Stock	0.3295	0.3329	0.3269	0.3293	284640000.0
2001-09-06 10:00:00	NVDA	Stock	0.3293	0.3375	0.3279	0.3344	324024000.0
2001-09-06 11:00:00	NVDA	Stock	0.3344	0.3353	0.328	0.3307	169368000.0
2001-09-06 12:00:00	NVDA	Stock	0.3307	0.3335	0.3284	0.333	142968000.0
2001-09-06 13:00:00	NVDA	Stock	0.3331	0.3388	0.3325	0.3381	280488000.0
2001-09-06 14:00:00	NVDA	Stock	0.338	0.338	0.3309	0.3333	245208000.0
2001-09-06 15:00:00	NVDA	Stock	0.3333	0.3346	0.3202	0.3217	373800000.0
2001-09-06 16:00:00	NVDA	Stock	0.3217	0.326	0.3209	0.325	40488000.0
2001-09-06 17:00:00	NVDA	Stock	0.3241	0.3258	0.3217	0.325	3120000.0
2001-09-06 08:00:00	AMZN	Stock	0.382	0.3875	0.38	0.383	96000.0
2001-09-06 09:00:00	AMZN	Stock	0.3835	0.4	0.3805	0.3875	25184000.0
2001-09-06 10:00:00	AMZN	Stock	0.3875	0.4025	0.3835	0.3995	31408000.0
2001-09-06 11:00:00	AMZN	Stock	0.3995	0.4	0.3935	0.396	14376000.0
2001-09-06 12:00:00	AMZN	Stock	0.396	0.396	0.39	0.395	11864000.0
2001-09-06 13:00:00	AMZN	Stock	0.3946	0.3955	0.3905	0.394	14542000.0
2001-09-06 14:00:00	AMZN	Stock	0.394	0.3985	0.3915	0.398	9868000.0
2001-09-06 15:00:00	AMZN	Stock	0.398	0.4095	0.395	0.407	18464000.0
2001-09-06 16:00:00	AMZN	Stock	0.407	0.41	0.3885	0.4065	5478000.0
2001-09-06 17:00:00	AMZN	Stock	0.4075	0.41	0.4065	0.4065	624000.0
2001-09-06 18:00:00	AMZN	Stock	0.404	0.4065	0.404	0.4065	38000.0
2001-09-06 09:00:00	CL	Stock	27.865	28.075	27.8	27.84	436200.0
2001-09-06 10:00:00	CL	Stock	27.83	28.06	27.755	28.06	472200.0
2001-09-06 11:00:00	CL	Stock	28.075	28.2	28.005	28.06	341600.0
2001-09-06 12:00:00	CL	Stock	28.055	28.055	27.875	28.025	542000.0
2001-09-06 13:00:00	CL	Stock	28.025	28.13	28.025	28.025	404600.0
2001-09-06 14:00:00	CL	Stock	28.03	28.17	27.925	28.125	404400.0
2001-09-06 15:00:00	CL	Stock	28.125	28.175	28.075	28.155	906000.0
2001-09-06 16:00:00	CL	Stock	28.155	28.155	28.155	28.155	105400.0

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

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