PREVIEW / stock_1hour / 2001-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-12.parquet
  size:    358 KB
  rows:    16,714
  symbols: 1,282

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-03-12 08:00:00	AAPL	Stock	0.3611	0.3611	0.3527	0.3527	504000.0
2001-03-12 09:00:00	AAPL	Stock	0.3549	0.356	0.3449	0.3538	41540800.0
2001-03-12 10:00:00	AAPL	Stock	0.3538	0.3538	0.3449	0.346	28084000.0
2001-03-12 11:00:00	AAPL	Stock	0.3449	0.3493	0.3281	0.3281	118109600.0
2001-03-12 12:00:00	AAPL	Stock	0.3292	0.3404	0.3237	0.3404	76137600.0
2001-03-12 13:00:00	AAPL	Stock	0.3404	0.3438	0.3326	0.3326	38662400.0
2001-03-12 14:00:00	AAPL	Stock	0.3326	0.3426	0.3326	0.3393	22584800.0
2001-03-12 15:00:00	AAPL	Stock	0.3393	0.3415	0.327	0.3337	39144000.0
2001-03-12 16:00:00	AAPL	Stock	0.3326	0.3359	0.327	0.3326	13384000.0
2001-03-12 17:00:00	AAPL	Stock	0.3326	0.3326	0.3326	0.3326	11200.0
2001-03-12 18:00:00	AAPL	Stock	0.3304	0.3304	0.3304	0.3304	28000.0
2001-03-12 08:00:00	MSFT	Stock	27.75	28.3438	27.5625	27.75	321600.0
2001-03-12 09:00:00	MSFT	Stock	27.8125	28.0	27.1562	27.375	14761000.0
2001-03-12 10:00:00	MSFT	Stock	27.375	27.375	26.6875	26.7188	16978800.0
2001-03-12 11:00:00	MSFT	Stock	26.7188	26.75	26.0938	26.375	15688000.0
2001-03-12 12:00:00	MSFT	Stock	26.375	26.8125	26.1875	26.7812	9372600.0
2001-03-12 13:00:00	MSFT	Stock	26.7812	27.1094	26.2812	26.2812	12908200.0
2001-03-12 14:00:00	MSFT	Stock	26.2969	26.75	26.1562	26.3438	14036600.0
2001-03-12 15:00:00	MSFT	Stock	26.375	26.5312	25.8125	25.9688	22247200.0
2001-03-12 16:00:00	MSFT	Stock	25.9688	26.8125	25.7812	25.9375	2869200.0
2001-03-12 17:00:00	MSFT	Stock	25.9062	26.6094	25.7812	25.7812	81200.0
2001-03-12 18:00:00	MSFT	Stock	25.875	26.4219	25.8438	25.8594	78600.0
2001-03-12 08:00:00	NVDA	Stock	0.2039	0.2042	0.1958	0.2042	1920000.0
2001-03-12 09:00:00	NVDA	Stock	0.2042	0.2057	0.2005	0.2026	138216000.0
2001-03-12 10:00:00	NVDA	Stock	0.2029	0.2029	0.1924	0.1944	91800000.0
2001-03-12 11:00:00	NVDA	Stock	0.1945	0.199	0.1927	0.1958	69408000.0
2001-03-12 12:00:00	NVDA	Stock	0.1969	0.2023	0.1945	0.2023	51024000.0
2001-03-12 13:00:00	NVDA	Stock	0.2021	0.207	0.2013	0.2016	93528000.0
2001-03-12 14:00:00	NVDA	Stock	0.2013	0.2081	0.2005	0.2057	81648000.0
2001-03-12 15:00:00	NVDA	Stock	0.2059	0.2109	0.1992	0.201	205440000.0
2001-03-12 16:00:00	NVDA	Stock	0.201	0.2042	0.1951	0.1951	3024000.0
2001-03-12 18:00:00	NVDA	Stock	0.2	0.201	0.2	0.2	120000.0
2001-03-12 08:00:00	AMZN	Stock	0.5875	0.6	0.575	0.5844	210000.0
2001-03-12 09:00:00	AMZN	Stock	0.5844	0.5875	0.5594	0.5625	22998000.0
2001-03-12 10:00:00	AMZN	Stock	0.5625	0.5656	0.525	0.5406	32486000.0
2001-03-12 11:00:00	AMZN	Stock	0.5406	0.5438	0.5312	0.5344	11544000.0
2001-03-12 12:00:00	AMZN	Stock	0.5375	0.5531	0.5344	0.5531	9228000.0
2001-03-12 13:00:00	AMZN	Stock	0.5516	0.5594	0.5438	0.5438	8420000.0
2001-03-12 14:00:00	AMZN	Stock	0.5438	0.5469	0.5375	0.5438	9344000.0
2001-03-12 15:00:00	AMZN	Stock	0.5406	0.55	0.5312	0.5344	15260000.0
2001-03-12 16:00:00	AMZN	Stock	0.5344	0.5375	0.525	0.5344	1848000.0
2001-03-12 17:00:00	AMZN	Stock	0.5312	0.5312	0.5312	0.5312	68000.0
2001-03-12 18:00:00	AMZN	Stock	0.5375	0.5375	0.5359	0.5375	22000.0
2001-03-12 09:00:00	CL	Stock	29.125	29.2	29.0	29.15	229600.0
2001-03-12 10:00:00	CL	Stock	29.175	29.5	29.175	29.47	351800.0
2001-03-12 11:00:00	CL	Stock	29.45	29.5	29.3	29.3	397200.0
2001-03-12 12:00:00	CL	Stock	29.3	29.375	29.2	29.24	256200.0
2001-03-12 13:00:00	CL	Stock	29.25	29.25	28.875	28.9	347200.0
2001-03-12 14:00:00	CL	Stock	28.895	29.0	28.6	28.675	492000.0
2001-03-12 15:00:00	CL	Stock	28.7	28.95	28.345	28.35	692000.0

> showing 50 of 16,714 rows — these rows as CSV

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