PREVIEW / stock_1hour / 2000-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-11-07.parquet
  size:    303 KB
  rows:    15,672
  symbols: 1,238

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
2000-11-07 08:00:00	AAPL	Stock	0.3783	0.3828	0.3783	0.3783	162400.0
2000-11-07 09:00:00	AAPL	Stock	0.3828	0.3839	0.3717	0.3761	26314400.0
2000-11-07 10:00:00	AAPL	Stock	0.3761	0.3817	0.3728	0.3817	42873600.0
2000-11-07 11:00:00	AAPL	Stock	0.3806	0.3895	0.3795	0.3817	69854400.0
2000-11-07 12:00:00	AAPL	Stock	0.385	0.385	0.3795	0.3817	27081600.0
2000-11-07 13:00:00	AAPL	Stock	0.3817	0.3839	0.3783	0.3795	31561600.0
2000-11-07 14:00:00	AAPL	Stock	0.3795	0.3817	0.3783	0.3795	30564800.0
2000-11-07 15:00:00	AAPL	Stock	0.3795	0.3817	0.3778	0.3806	54174400.0
2000-11-07 16:00:00	AAPL	Stock	0.3795	0.3834	0.3795	0.3795	4183200.0
2000-11-07 17:00:00	AAPL	Stock	0.3806	0.3806	0.3795	0.3795	257600.0
2000-11-07 18:00:00	AAPL	Stock	0.3783	0.3795	0.3772	0.3783	140000.0
2000-11-07 08:00:00	MSFT	Stock	34.9531	34.9531	34.3438	34.875	52800.0
2000-11-07 09:00:00	MSFT	Stock	34.75	35.3125	34.75	35.125	9788400.0
2000-11-07 10:00:00	MSFT	Stock	35.1562	35.8125	34.9219	35.7188	15354400.0
2000-11-07 11:00:00	MSFT	Stock	35.7188	35.9375	35.5938	35.625	16335200.0
2000-11-07 12:00:00	MSFT	Stock	35.625	35.875	35.5938	35.75	7943400.0
2000-11-07 13:00:00	MSFT	Stock	35.75	35.75	35.375	35.375	11705800.0
2000-11-07 14:00:00	MSFT	Stock	35.4062	35.5312	35.1562	35.2188	11442800.0
2000-11-07 15:00:00	MSFT	Stock	35.2188	35.375	34.9688	35.25	22980200.0
2000-11-07 16:00:00	MSFT	Stock	35.2812	35.625	35.0	35.375	3216400.0
2000-11-07 17:00:00	MSFT	Stock	35.375	35.625	35.3438	35.5625	95400.0
2000-11-07 18:00:00	MSFT	Stock	35.5938	35.7188	35.5625	35.6875	55600.0
2000-11-07 09:00:00	NVDA	Stock	0.3151	0.3167	0.3005	0.3072	37872000.0
2000-11-07 10:00:00	NVDA	Stock	0.3073	0.3073	0.2961	0.2997	60816000.0
2000-11-07 11:00:00	NVDA	Stock	0.299	0.3	0.2917	0.294	58296000.0
2000-11-07 12:00:00	NVDA	Stock	0.2945	0.2982	0.2924	0.294	13920000.0
2000-11-07 13:00:00	NVDA	Stock	0.2938	0.2958	0.2911	0.2917	17232000.0
2000-11-07 14:00:00	NVDA	Stock	0.2938	0.2938	0.2875	0.2922	20952000.0
2000-11-07 15:00:00	NVDA	Stock	0.2924	0.2997	0.2891	0.2982	32040000.0
2000-11-07 16:00:00	NVDA	Stock	0.2984	0.2984	0.2917	0.2958	1584000.0
2000-11-07 08:00:00	AMZN	Stock	1.8062	1.8219	1.8	1.8219	10000.0
2000-11-07 09:00:00	AMZN	Stock	1.8219	1.8438	1.7781	1.8156	9714000.0
2000-11-07 10:00:00	AMZN	Stock	1.8188	1.9	1.7875	1.8953	21148000.0
2000-11-07 11:00:00	AMZN	Stock	1.8938	1.9719	1.8938	1.9406	17954000.0
2000-11-07 12:00:00	AMZN	Stock	1.9406	1.9438	1.9062	1.9062	11236000.0
2000-11-07 13:00:00	AMZN	Stock	1.9062	1.9188	1.8875	1.8969	10566000.0
2000-11-07 14:00:00	AMZN	Stock	1.8969	1.9094	1.8594	1.8688	12616000.0
2000-11-07 15:00:00	AMZN	Stock	1.8656	1.8688	1.8312	1.8406	16792000.0
2000-11-07 16:00:00	AMZN	Stock	1.8406	1.8859	1.8406	1.85	2758000.0
2000-11-07 17:00:00	AMZN	Stock	1.8469	1.8531	1.8469	1.8516	50000.0
2000-11-07 18:00:00	AMZN	Stock	1.8594	1.8594	1.8594	1.8594	2000.0
2000-11-07 09:00:00	CL	Stock	29.225	29.4	29.1	29.175	586400.0
2000-11-07 10:00:00	CL	Stock	29.2	29.225	28.97	28.98	307400.0
2000-11-07 11:00:00	CL	Stock	28.965	29.02	28.81	28.88	267800.0
2000-11-07 12:00:00	CL	Stock	28.88	29.125	28.88	28.915	204600.0
2000-11-07 13:00:00	CL	Stock	28.92	29.095	28.9	29.065	188600.0
2000-11-07 14:00:00	CL	Stock	29.08	29.095	28.825	29.0	452400.0
2000-11-07 15:00:00	CL	Stock	29.0	29.5	28.95	29.31	612800.0
2000-11-07 16:00:00	CL	Stock	29.4	29.425	29.095	29.095	65800.0

> showing 49 of 15,672 rows — these rows as CSV

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