PREVIEW / stock_1hour / 2006-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-04.parquet
  size:    585 KB
  rows:    27,757
  symbols: 2,175

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
2006-01-04 07:00:00	AAPL	Stock	2.6696	2.6786	2.6696	2.6786	16800.0
2006-01-04 08:00:00	AAPL	Stock	2.6779	2.6857	2.67	2.6789	2997680.0
2006-01-04 09:00:00	AAPL	Stock	2.6786	2.7136	2.6725	2.6786	143680656.0
2006-01-04 10:00:00	AAPL	Stock	2.6786	2.6946	2.6607	2.6725	145334672.0
2006-01-04 11:00:00	AAPL	Stock	2.6725	2.6893	2.6643	2.6843	68446140.0
2006-01-04 12:00:00	AAPL	Stock	2.6843	2.6843	2.6711	2.6746	45466400.0
2006-01-04 13:00:00	AAPL	Stock	2.675	2.6839	2.6679	2.68	47150544.0
2006-01-04 14:00:00	AAPL	Stock	2.68	2.6821	2.6639	2.6686	53205376.0
2006-01-04 15:00:00	AAPL	Stock	2.6689	2.6821	2.6668	2.6779	93375268.0
2006-01-04 16:00:00	AAPL	Stock	2.6775	2.6787	2.6714	2.6729	2283288.0
2006-01-04 17:00:00	AAPL	Stock	2.6732	2.6775	2.6718	2.6732	2294796.0
2006-01-04 18:00:00	AAPL	Stock	2.6725	2.675	2.6725	2.675	136920.0
2006-01-04 07:00:00	MSFT	Stock	26.83	26.83	26.83	26.83	200.0
2006-01-04 08:00:00	MSFT	Stock	26.78	26.83	26.77	26.79	23307.0
2006-01-04 09:00:00	MSFT	Stock	26.78	26.97	26.77	26.92	8875614.0
2006-01-04 10:00:00	MSFT	Stock	26.922	26.98	26.88	26.95	9960047.0
2006-01-04 11:00:00	MSFT	Stock	26.96	27.08	26.89	27.018	9401000.0
2006-01-04 12:00:00	MSFT	Stock	27.02	27.08	26.95	26.99	5418333.0
2006-01-04 13:00:00	MSFT	Stock	26.99	27.0	26.91	26.94	4623005.0
2006-01-04 14:00:00	MSFT	Stock	26.94	27.0	26.87	26.97	6911572.0
2006-01-04 15:00:00	MSFT	Stock	26.98	27.01	26.93	26.99	10723325.0
2006-01-04 16:00:00	MSFT	Stock	26.99	27.0	26.932	26.98	260836.0
2006-01-04 17:00:00	MSFT	Stock	26.96	26.99	26.95	26.99	16056.0
2006-01-04 08:00:00	NVDA	Stock	0.3145	0.3145	0.3145	0.3145	24000.0
2006-01-04 09:00:00	NVDA	Stock	0.3187	0.3223	0.3176	0.3214	67665360.0
2006-01-04 10:00:00	NVDA	Stock	0.3215	0.3272	0.3212	0.3262	127170840.0
2006-01-04 11:00:00	NVDA	Stock	0.3262	0.3267	0.324	0.3259	38115240.0
2006-01-04 12:00:00	NVDA	Stock	0.3259	0.327	0.3252	0.3254	28535880.0
2006-01-04 13:00:00	NVDA	Stock	0.3252	0.3252	0.3231	0.3234	33545040.0
2006-01-04 14:00:00	NVDA	Stock	0.3235	0.3272	0.3219	0.3271	58951080.0
2006-01-04 15:00:00	NVDA	Stock	0.3271	0.3278	0.3247	0.3273	85999320.0
2006-01-04 16:00:00	NVDA	Stock	0.3274	0.3291	0.3246	0.3274	8868960.0
2006-01-04 17:00:00	NVDA	Stock	0.3255	0.3283	0.3255	0.3283	8104440.0
2006-01-04 08:00:00	AMZN	Stock	2.395	2.4	2.366	2.3725	37400.0
2006-01-04 09:00:00	AMZN	Stock	2.3785	2.382	2.3525	2.36	15953760.0
2006-01-04 10:00:00	AMZN	Stock	2.36	2.381	2.355	2.38	25701060.0
2006-01-04 11:00:00	AMZN	Stock	2.38	2.3865	2.3655	2.3735	19552300.0
2006-01-04 12:00:00	AMZN	Stock	2.3735	2.382	2.3565	2.361	11113420.0
2006-01-04 13:00:00	AMZN	Stock	2.3605	2.3615	2.3345	2.349	24673720.0
2006-01-04 14:00:00	AMZN	Stock	2.349	2.3725	2.337	2.345	18997380.0
2006-01-04 15:00:00	AMZN	Stock	2.344	2.367	2.343	2.3625	23700860.0
2006-01-04 16:00:00	AMZN	Stock	2.3625	2.3675	2.359	2.3625	4268440.0
2006-01-04 17:00:00	AMZN	Stock	2.3625	2.3625	2.3625	2.3625	18960.0
2006-01-04 09:00:00	CL	Stock	27.42	27.595	27.42	27.585	360800.0
2006-01-04 10:00:00	CL	Stock	27.585	27.62	27.535	27.565	541400.0
2006-01-04 11:00:00	CL	Stock	27.57	27.615	27.545	27.56	519400.0
2006-01-04 12:00:00	CL	Stock	27.555	27.575	27.43	27.44	363600.0
2006-01-04 13:00:00	CL	Stock	27.435	27.56	27.415	27.525	376000.0
2006-01-04 14:00:00	CL	Stock	27.525	27.655	27.445	27.64	537400.0
2006-01-04 15:00:00	CL	Stock	27.655	27.83	27.62	27.78	937800.0

> showing 50 of 27,757 rows — these rows as CSV

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