PREVIEW / stock_1hour / 2001-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-02-27.parquet
  size:    348 KB
  rows:    16,182
  symbols: 1,273

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-02-27 08:00:00	AAPL	Stock	0.346	0.346	0.3443	0.3443	16800.0
2001-02-27 09:00:00	AAPL	Stock	0.3438	0.346	0.3371	0.3415	25480000.0
2001-02-27 10:00:00	AAPL	Stock	0.3415	0.346	0.3337	0.3371	39121600.0
2001-02-27 11:00:00	AAPL	Stock	0.3371	0.3438	0.3359	0.3426	22170400.0
2001-02-27 12:00:00	AAPL	Stock	0.3426	0.3438	0.3393	0.3404	46844000.0
2001-02-27 13:00:00	AAPL	Stock	0.3415	0.3426	0.3393	0.3415	18373600.0
2001-02-27 14:00:00	AAPL	Stock	0.3415	0.3471	0.3393	0.3449	42268800.0
2001-02-27 15:00:00	AAPL	Stock	0.346	0.3471	0.3393	0.3449	65150400.0
2001-02-27 16:00:00	AAPL	Stock	0.3449	0.3471	0.3393	0.346	77084000.0
2001-02-27 17:00:00	AAPL	Stock	0.3404	0.3404	0.3404	0.3404	5600.0
2001-02-27 08:00:00	MSFT	Stock	29.6875	29.75	29.4375	29.5	112000.0
2001-02-27 09:00:00	MSFT	Stock	29.5	30.1875	29.375	30.1562	13697200.0
2001-02-27 10:00:00	MSFT	Stock	30.1875	30.4688	29.75	30.4062	20268600.0
2001-02-27 11:00:00	MSFT	Stock	30.4062	30.5938	30.3125	30.5	14546000.0
2001-02-27 12:00:00	MSFT	Stock	30.5	30.5625	30.0938	30.1562	9801600.0
2001-02-27 13:00:00	MSFT	Stock	30.1562	30.2188	29.8125	29.9062	9204400.0
2001-02-27 14:00:00	MSFT	Stock	29.9375	30.1875	29.75	30.0312	7660600.0
2001-02-27 15:00:00	MSFT	Stock	30.0312	30.0625	29.3281	29.7188	13540400.0
2001-02-27 16:00:00	MSFT	Stock	29.7188	30.0781	29.5	29.5	3755000.0
2001-02-27 17:00:00	MSFT	Stock	29.5	29.9375	29.4688	29.6562	559000.0
2001-02-27 18:00:00	MSFT	Stock	29.5938	29.5938	29.4062	29.4062	7600.0
2001-02-27 08:00:00	NVDA	Stock	0.218	0.218	0.218	0.218	48000.0
2001-02-27 09:00:00	NVDA	Stock	0.2177	0.2245	0.2156	0.2208	77808000.0
2001-02-27 10:00:00	NVDA	Stock	0.2208	0.2234	0.2177	0.2211	90720000.0
2001-02-27 11:00:00	NVDA	Stock	0.2208	0.2234	0.2182	0.219	94584000.0
2001-02-27 12:00:00	NVDA	Stock	0.219	0.2211	0.2167	0.2172	26976000.0
2001-02-27 13:00:00	NVDA	Stock	0.2172	0.2182	0.2141	0.2146	45672000.0
2001-02-27 14:00:00	NVDA	Stock	0.2143	0.2167	0.2094	0.2115	84600000.0
2001-02-27 15:00:00	NVDA	Stock	0.2115	0.2125	0.2068	0.2078	75048000.0
2001-02-27 16:00:00	NVDA	Stock	0.2081	0.2092	0.2031	0.2031	5424000.0
2001-02-27 17:00:00	NVDA	Stock	0.2042	0.2042	0.2022	0.2022	456000.0
2001-02-27 08:00:00	AMZN	Stock	0.5969	0.5969	0.5969	0.5969	58000.0
2001-02-27 09:00:00	AMZN	Stock	0.5844	0.5938	0.5812	0.5906	18426000.0
2001-02-27 10:00:00	AMZN	Stock	0.5938	0.6	0.5844	0.5969	28376000.0
2001-02-27 11:00:00	AMZN	Stock	0.5938	0.6063	0.5906	0.6	16484000.0
2001-02-27 12:00:00	AMZN	Stock	0.5969	0.6031	0.5906	0.6	9336000.0
2001-02-27 13:00:00	AMZN	Stock	0.6	0.6	0.5906	0.5906	11078000.0
2001-02-27 14:00:00	AMZN	Stock	0.5938	0.5969	0.5812	0.5938	24350000.0
2001-02-27 15:00:00	AMZN	Stock	0.5938	0.5938	0.5844	0.5844	27184000.0
2001-02-27 16:00:00	AMZN	Stock	0.5844	0.5906	0.575	0.5875	12078000.0
2001-02-27 17:00:00	AMZN	Stock	0.5875	0.5875	0.5875	0.5875	72000.0
2001-02-27 09:00:00	CL	Stock	29.05	29.7	29.01	29.645	455000.0
2001-02-27 10:00:00	CL	Stock	29.645	29.7	29.325	29.46	452400.0
2001-02-27 11:00:00	CL	Stock	29.475	29.645	29.3	29.625	296800.0
2001-02-27 12:00:00	CL	Stock	29.625	29.645	29.475	29.525	346800.0
2001-02-27 13:00:00	CL	Stock	29.525	29.55	29.41	29.42	247000.0
2001-02-27 14:00:00	CL	Stock	29.425	29.52	29.41	29.52	319200.0
2001-02-27 15:00:00	CL	Stock	29.52	29.525	29.25	29.465	533000.0
2001-02-27 16:00:00	CL	Stock	29.465	29.465	29.375	29.375	414200.0
2001-02-27 17:00:00	CL	Stock	29.375	29.375	29.375	29.375	50000.0

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

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