PREVIEW / stock_1hour / 2005-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-19.parquet
  size:    542 KB
  rows:    25,607
  symbols: 1,984

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-05-19 07:00:00	AAPL	Stock	1.2804	1.2804	1.2804	1.2804	11200.0
2005-05-19 08:00:00	AAPL	Stock	1.2786	1.2796	1.2736	1.275	456652.0
2005-05-19 09:00:00	AAPL	Stock	1.2779	1.3129	1.275	1.3093	121183468.0
2005-05-19 10:00:00	AAPL	Stock	1.3089	1.33	1.3043	1.3129	157825108.0
2005-05-19 11:00:00	AAPL	Stock	1.3136	1.3246	1.3071	1.3214	83635832.0
2005-05-19 12:00:00	AAPL	Stock	1.3214	1.3304	1.3164	1.3296	74761036.0
2005-05-19 13:00:00	AAPL	Stock	1.33	1.3339	1.3179	1.3193	75362140.0
2005-05-19 14:00:00	AAPL	Stock	1.3193	1.3314	1.3171	1.3271	87473876.0
2005-05-19 15:00:00	AAPL	Stock	1.3268	1.3457	1.3268	1.3407	164197964.0
2005-05-19 16:00:00	AAPL	Stock	1.3411	1.3429	1.3361	1.34	6185368.0
2005-05-19 17:00:00	AAPL	Stock	1.34	1.3446	1.3382	1.3382	389088.0
2005-05-19 18:00:00	AAPL	Stock	1.3375	1.3389	1.3371	1.3389	109200.0
2005-05-19 08:00:00	MSFT	Stock	25.65	25.75	25.65	25.75	121138.0
2005-05-19 09:00:00	MSFT	Stock	25.75	25.84	25.66	25.82	4803274.0
2005-05-19 10:00:00	MSFT	Stock	25.82	25.84	25.76	25.8	8032747.0
2005-05-19 11:00:00	MSFT	Stock	25.8	25.86	25.7	25.78	6256692.0
2005-05-19 12:00:00	MSFT	Stock	25.78	25.83	25.75	25.8	3720913.0
2005-05-19 13:00:00	MSFT	Stock	25.8	25.82	25.74	25.77	5856047.0
2005-05-19 14:00:00	MSFT	Stock	25.77	25.83	25.75	25.82	6818554.0
2005-05-19 15:00:00	MSFT	Stock	25.83	26.05	25.8	25.91	15515312.0
2005-05-19 16:00:00	MSFT	Stock	25.92	25.92	25.86	25.92	644221.0
2005-05-19 17:00:00	MSFT	Stock	25.87	25.9	25.87	25.9	5972.0
2005-05-19 18:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	150.0
2005-05-19 08:00:00	NVDA	Stock	0.2161	0.2161	0.2161	0.2161	108000.0
2005-05-19 09:00:00	NVDA	Stock	0.2161	0.2168	0.2138	0.2166	71882160.0
2005-05-19 10:00:00	NVDA	Stock	0.2167	0.2172	0.2146	0.2158	83186280.0
2005-05-19 11:00:00	NVDA	Stock	0.2158	0.2166	0.2144	0.2154	75893760.0
2005-05-19 12:00:00	NVDA	Stock	0.2154	0.2167	0.215	0.2167	67222560.0
2005-05-19 13:00:00	NVDA	Stock	0.2166	0.2168	0.2152	0.2153	32187240.0
2005-05-19 14:00:00	NVDA	Stock	0.2152	0.2158	0.2129	0.2139	57033120.0
2005-05-19 15:00:00	NVDA	Stock	0.214	0.2155	0.2135	0.2152	61148160.0
2005-05-19 16:00:00	NVDA	Stock	0.2151	0.2155	0.2127	0.2151	1548000.0
2005-05-19 09:00:00	AMZN	Stock	1.77	1.7955	1.7655	1.785	19205440.0
2005-05-19 10:00:00	AMZN	Stock	1.7855	1.7895	1.769	1.7755	21132360.0
2005-05-19 11:00:00	AMZN	Stock	1.7745	1.781	1.7695	1.778	12113520.0
2005-05-19 12:00:00	AMZN	Stock	1.778	1.7805	1.7726	1.7775	14705980.0
2005-05-19 13:00:00	AMZN	Stock	1.778	1.78	1.7715	1.772	6887240.0
2005-05-19 14:00:00	AMZN	Stock	1.7725	1.7775	1.7675	1.777	11240400.0
2005-05-19 15:00:00	AMZN	Stock	1.777	1.7795	1.77	1.7795	17115520.0
2005-05-19 16:00:00	AMZN	Stock	1.778	1.7795	1.7735	1.7795	358580.0
2005-05-19 17:00:00	AMZN	Stock	1.7795	1.7795	1.777	1.7795	161000.0
2005-05-19 09:00:00	CL	Stock	25.195	25.325	25.195	25.29	260800.0
2005-05-19 10:00:00	CL	Stock	25.29	25.375	25.255	25.27	592000.0
2005-05-19 11:00:00	CL	Stock	25.27	25.315	25.21	25.265	342000.0
2005-05-19 12:00:00	CL	Stock	25.265	25.305	25.23	25.29	257600.0
2005-05-19 13:00:00	CL	Stock	25.3	25.33	25.255	25.275	196200.0
2005-05-19 14:00:00	CL	Stock	25.28	25.355	25.25	25.305	341400.0
2005-05-19 15:00:00	CL	Stock	25.31	25.35	25.275	25.335	626800.0
2005-05-19 16:00:00	CL	Stock	25.345	25.345	25.345	25.345	1000.0

> showing 49 of 25,607 rows — these rows as CSV

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