PREVIEW / stock_1hour / 2004-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-20.parquet
  size:    509 KB
  rows:    24,304
  symbols: 1,832

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
2004-09-20 08:00:00	AAPL	Stock	0.6607	0.6607	0.6586	0.6586	324240.0
2004-09-20 09:00:00	AAPL	Stock	0.6598	0.6646	0.6584	0.6618	27141520.0
2004-09-20 10:00:00	AAPL	Stock	0.6616	0.6743	0.6611	0.6718	43005424.0
2004-09-20 11:00:00	AAPL	Stock	0.6718	0.6782	0.6689	0.6721	37466576.0
2004-09-20 12:00:00	AAPL	Stock	0.6721	0.6736	0.6709	0.673	17418464.0
2004-09-20 13:00:00	AAPL	Stock	0.673	0.6771	0.6711	0.6729	26958232.0
2004-09-20 14:00:00	AAPL	Stock	0.673	0.675	0.6714	0.6739	26070968.0
2004-09-20 15:00:00	AAPL	Stock	0.6741	0.6759	0.673	0.6743	41936384.0
2004-09-20 16:00:00	AAPL	Stock	0.6739	0.6786	0.6734	0.6757	2150624.0
2004-09-20 17:00:00	AAPL	Stock	0.6741	0.6771	0.6741	0.675	39480.0
2004-09-20 18:00:00	AAPL	Stock	0.6741	0.6741	0.6741	0.6741	28000.0
2004-09-20 08:00:00	MSFT	Stock	27.45	27.52	27.36	27.37	37500.0
2004-09-20 09:00:00	MSFT	Stock	27.38	27.52	27.34	27.34	5415340.0
2004-09-20 10:00:00	MSFT	Stock	27.34	27.58	27.33	27.57	12788103.0
2004-09-20 11:00:00	MSFT	Stock	27.57	27.65	27.5	27.57	7419303.0
2004-09-20 12:00:00	MSFT	Stock	27.57	27.59	27.49	27.5	3529597.0
2004-09-20 13:00:00	MSFT	Stock	27.5	27.56	27.44	27.491	4350714.0
2004-09-20 14:00:00	MSFT	Stock	27.49	27.53	27.44	27.45	5797437.0
2004-09-20 15:00:00	MSFT	Stock	27.45	27.53	27.44	27.5	8839119.0
2004-09-20 16:00:00	MSFT	Stock	27.5	27.52	27.49	27.51	754420.0
2004-09-20 17:00:00	MSFT	Stock	27.52	27.52	27.48	27.48	10700.0
2004-09-20 08:00:00	NVDA	Stock	0.1217	0.1225	0.1217	0.1225	4584000.0
2004-09-20 09:00:00	NVDA	Stock	0.1217	0.1223	0.1185	0.1203	124236720.0
2004-09-20 10:00:00	NVDA	Stock	0.1204	0.1255	0.1202	0.1254	206232960.0
2004-09-20 11:00:00	NVDA	Stock	0.1254	0.1257	0.1242	0.1243	106855920.0
2004-09-20 12:00:00	NVDA	Stock	0.1244	0.1246	0.1229	0.1233	39042720.0
2004-09-20 13:00:00	NVDA	Stock	0.1233	0.1243	0.12	0.1227	69078360.0
2004-09-20 14:00:00	NVDA	Stock	0.1227	0.1227	0.1211	0.1219	86955000.0
2004-09-20 15:00:00	NVDA	Stock	0.1218	0.1227	0.1213	0.1224	118112280.0
2004-09-20 16:00:00	NVDA	Stock	0.1223	0.1229	0.1219	0.122	2920320.0
2004-09-20 17:00:00	NVDA	Stock	0.1227	0.1235	0.1223	0.1223	138000.0
2004-09-20 18:00:00	NVDA	Stock	0.1224	0.1224	0.1224	0.1224	22800.0
2004-09-20 08:00:00	AMZN	Stock	2.14	2.1485	2.135	2.136	777500.0
2004-09-20 09:00:00	AMZN	Stock	2.135	2.18	2.1305	2.1635	26313800.0
2004-09-20 10:00:00	AMZN	Stock	2.1645	2.1995	2.156	2.1895	44934040.0
2004-09-20 11:00:00	AMZN	Stock	2.189	2.197	2.1655	2.1765	23048120.0
2004-09-20 12:00:00	AMZN	Stock	2.1765	2.179	2.161	2.165	8603740.0
2004-09-20 13:00:00	AMZN	Stock	2.1655	2.178	2.146	2.1685	18824400.0
2004-09-20 14:00:00	AMZN	Stock	2.1685	2.188	2.1625	2.173	19393880.0
2004-09-20 15:00:00	AMZN	Stock	2.173	2.177	2.1585	2.162	27716820.0
2004-09-20 16:00:00	AMZN	Stock	2.163	2.1685	2.1615	2.1635	831240.0
2004-09-20 17:00:00	AMZN	Stock	2.165	2.165	2.165	2.165	4000.0
2004-09-20 08:00:00	CL	Stock	25.005	25.25	24.8	24.875	236000.0
2004-09-20 09:00:00	CL	Stock	24.9	24.96	24.045	24.08	7278600.0
2004-09-20 10:00:00	CL	Stock	24.08	24.365	24.06	24.31	7369000.0
2004-09-20 11:00:00	CL	Stock	24.32	24.4	24.27	24.29	3714600.0
2004-09-20 12:00:00	CL	Stock	24.285	24.34	24.225	24.29	2124200.0
2004-09-20 13:00:00	CL	Stock	24.295	24.345	24.24	24.27	1931800.0
2004-09-20 14:00:00	CL	Stock	24.275	24.285	24.095	24.11	3698800.0
2004-09-20 15:00:00	CL	Stock	24.11	24.16	24.045	24.115	4965600.0

> showing 50 of 24,304 rows — these rows as CSV

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