PREVIEW / stock_1hour / 2005-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-20.parquet
  size:    555 KB
  rows:    26,093
  symbols: 2,035

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
2005-07-20 08:00:00	AAPL	Stock	1.5321	1.5332	1.5182	1.5214	1920352.0
2005-07-20 09:00:00	AAPL	Stock	1.5214	1.5393	1.5207	1.53	98758576.0
2005-07-20 10:00:00	AAPL	Stock	1.5293	1.5357	1.5246	1.5271	80120516.0
2005-07-20 11:00:00	AAPL	Stock	1.5271	1.5364	1.5268	1.5314	38551520.0
2005-07-20 12:00:00	AAPL	Stock	1.5311	1.5346	1.5279	1.5321	20345108.0
2005-07-20 13:00:00	AAPL	Stock	1.5321	1.55	1.5307	1.5471	69589828.0
2005-07-20 14:00:00	AAPL	Stock	1.5468	1.5589	1.5454	1.5521	62669460.0
2005-07-20 15:00:00	AAPL	Stock	1.5529	1.5643	1.5511	1.5586	74726092.0
2005-07-20 16:00:00	AAPL	Stock	1.5582	1.5664	1.5561	1.5632	3507056.0
2005-07-20 17:00:00	AAPL	Stock	1.5629	1.5643	1.5607	1.5632	370244.0
2005-07-20 18:00:00	AAPL	Stock	1.5632	1.5675	1.5632	1.5675	336000.0
2005-07-20 08:00:00	MSFT	Stock	25.88	25.97	25.88	25.95	1107490.0
2005-07-20 09:00:00	MSFT	Stock	25.93	26.08	25.93	26.04	10165206.0
2005-07-20 10:00:00	MSFT	Stock	26.03	26.13	25.92	25.93	14110264.0
2005-07-20 11:00:00	MSFT	Stock	25.93	26.02	25.88	25.98	8323396.0
2005-07-20 12:00:00	MSFT	Stock	25.99	26.0	25.94	25.99	5420180.0
2005-07-20 13:00:00	MSFT	Stock	25.99	26.15	25.95	26.12	10760446.0
2005-07-20 14:00:00	MSFT	Stock	26.12	26.18	26.04	26.06	8216102.0
2005-07-20 15:00:00	MSFT	Stock	26.06	26.23	25.999	26.18	12190815.0
2005-07-20 16:00:00	MSFT	Stock	26.18	26.34	26.03	26.3	518661.0
2005-07-20 17:00:00	MSFT	Stock	26.3	26.34	26.19	26.23	320682.0
2005-07-20 18:00:00	MSFT	Stock	26.23	26.27	26.21	26.23	94526.0
2005-07-20 08:00:00	NVDA	Stock	0.2167	0.2175	0.2167	0.2175	158400.0
2005-07-20 09:00:00	NVDA	Stock	0.219	0.2204	0.2159	0.2177	85274160.0
2005-07-20 10:00:00	NVDA	Stock	0.2177	0.2207	0.217	0.2192	74613360.0
2005-07-20 11:00:00	NVDA	Stock	0.2192	0.224	0.219	0.224	78218880.0
2005-07-20 12:00:00	NVDA	Stock	0.224	0.2242	0.2232	0.224	42208800.0
2005-07-20 13:00:00	NVDA	Stock	0.2239	0.225	0.2235	0.2241	59607240.0
2005-07-20 14:00:00	NVDA	Stock	0.224	0.2257	0.2233	0.2247	97956120.0
2005-07-20 15:00:00	NVDA	Stock	0.2247	0.2254	0.2242	0.2248	76996920.0
2005-07-20 16:00:00	NVDA	Stock	0.2247	0.225	0.2244	0.225	3612960.0
2005-07-20 17:00:00	NVDA	Stock	0.2247	0.2247	0.2247	0.2247	600000.0
2005-07-20 18:00:00	NVDA	Stock	0.2249	0.2249	0.2246	0.2249	312000.0
2005-07-20 08:00:00	AMZN	Stock	1.885	1.885	1.87	1.871	59000.0
2005-07-20 09:00:00	AMZN	Stock	1.875	1.8985	1.865	1.88	20310520.0
2005-07-20 10:00:00	AMZN	Stock	1.8795	1.893	1.8735	1.882	12746100.0
2005-07-20 11:00:00	AMZN	Stock	1.8815	1.89	1.8795	1.883	9590740.0
2005-07-20 12:00:00	AMZN	Stock	1.8825	1.8855	1.878	1.884	11682600.0
2005-07-20 13:00:00	AMZN	Stock	1.884	1.895	1.884	1.8845	13783120.0
2005-07-20 14:00:00	AMZN	Stock	1.885	1.8985	1.8845	1.8895	19794640.0
2005-07-20 15:00:00	AMZN	Stock	1.89	1.9125	1.889	1.909	29598040.0
2005-07-20 16:00:00	AMZN	Stock	1.9095	1.974	1.901	1.9675	8376300.0
2005-07-20 17:00:00	AMZN	Stock	1.969	1.969	1.964	1.964	374500.0
2005-07-20 18:00:00	AMZN	Stock	1.964	1.9675	1.96	1.96	76000.0
2005-07-20 09:00:00	CL	Stock	25.675	25.76	25.645	25.6675	285400.0
2005-07-20 10:00:00	CL	Stock	25.665	25.705	25.5	25.525	502400.0
2005-07-20 11:00:00	CL	Stock	25.525	25.6	25.45	25.6	660000.0
2005-07-20 12:00:00	CL	Stock	25.6	25.6	25.55	25.585	271400.0
2005-07-20 13:00:00	CL	Stock	25.585	25.725	25.565	25.725	474000.0
2005-07-20 14:00:00	CL	Stock	25.72	25.745	25.64	25.67	399800.0

> showing 50 of 26,093 rows — these rows as CSV

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