PREVIEW / stock_1hour / 2000-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-14.parquet
  size:    298 KB
  rows:    15,418
  symbols: 1,211

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-08-14 08:00:00	AAPL	Stock	0.8527	0.8527	0.8527	0.8527	44800.0
2000-08-14 09:00:00	AAPL	Stock	0.8516	0.8527	0.827	0.8292	10561600.0
2000-08-14 10:00:00	AAPL	Stock	0.8315	0.8482	0.8292	0.8438	34339200.0
2000-08-14 11:00:00	AAPL	Stock	0.8415	0.8438	0.8348	0.8393	35728000.0
2000-08-14 12:00:00	AAPL	Stock	0.8393	0.8393	0.8337	0.8343	10264800.0
2000-08-14 13:00:00	AAPL	Stock	0.8348	0.8371	0.8337	0.8359	14145600.0
2000-08-14 14:00:00	AAPL	Stock	0.8359	0.8404	0.8348	0.8393	15288000.0
2000-08-14 15:00:00	AAPL	Stock	0.8393	0.8415	0.8359	0.8398	28789600.0
2000-08-14 16:00:00	AAPL	Stock	0.8398	0.8426	0.8359	0.8359	3886400.0
2000-08-14 08:00:00	MSFT	Stock	36.2188	36.2188	36.0	36.125	2600.0
2000-08-14 09:00:00	MSFT	Stock	36.125	36.3438	36.0625	36.1875	3121000.0
2000-08-14 10:00:00	MSFT	Stock	36.1875	36.6875	36.1562	36.5312	5865400.0
2000-08-14 11:00:00	MSFT	Stock	36.5312	36.5625	36.1562	36.4062	3587200.0
2000-08-14 12:00:00	MSFT	Stock	36.4062	36.5312	35.8125	35.8125	3123200.0
2000-08-14 13:00:00	MSFT	Stock	35.8125	36.0469	35.6875	35.9375	17257600.0
2000-08-14 14:00:00	MSFT	Stock	35.9375	36.0938	35.75	36.0938	5026400.0
2000-08-14 15:00:00	MSFT	Stock	36.0625	36.25	36.0	36.125	6708800.0
2000-08-14 16:00:00	MSFT	Stock	36.125	36.1875	36.0	36.0312	1348200.0
2000-08-14 17:00:00	MSFT	Stock	35.875	36.0625	35.875	36.0625	2000.0
2000-08-14 18:00:00	MSFT	Stock	36.0625	36.0938	36.0625	36.0625	6600.0
2000-08-14 09:00:00	NVDA	Stock	0.2693	0.2729	0.2625	0.2643	24744000.0
2000-08-14 10:00:00	NVDA	Stock	0.2641	0.2745	0.2638	0.2714	19488000.0
2000-08-14 11:00:00	NVDA	Stock	0.2714	0.2719	0.2661	0.2669	9480000.0
2000-08-14 12:00:00	NVDA	Stock	0.2701	0.2708	0.2672	0.2698	6120000.0
2000-08-14 13:00:00	NVDA	Stock	0.269	0.2719	0.2672	0.2708	8064000.0
2000-08-14 14:00:00	NVDA	Stock	0.2708	0.274	0.2698	0.274	9744000.0
2000-08-14 15:00:00	NVDA	Stock	0.274	0.2742	0.2695	0.2711	24696000.0
2000-08-14 16:00:00	NVDA	Stock	0.2711	0.2711	0.2708	0.2708	480000.0
2000-08-14 18:00:00	NVDA	Stock	0.2719	0.2719	0.2719	0.2719	192000.0
2000-08-14 08:00:00	AMZN	Stock	1.6875	1.6875	1.6688	1.6812	52000.0
2000-08-14 09:00:00	AMZN	Stock	1.6797	1.6844	1.6344	1.65	17468000.0
2000-08-14 10:00:00	AMZN	Stock	1.6531	1.725	1.65	1.7125	19884000.0
2000-08-14 11:00:00	AMZN	Stock	1.7125	1.7156	1.6812	1.7	12818000.0
2000-08-14 12:00:00	AMZN	Stock	1.6969	1.7438	1.6969	1.7312	16550000.0
2000-08-14 13:00:00	AMZN	Stock	1.7281	1.75	1.725	1.7375	13282000.0
2000-08-14 14:00:00	AMZN	Stock	1.7406	1.7594	1.7375	1.7594	23414000.0
2000-08-14 15:00:00	AMZN	Stock	1.7531	1.7594	1.7344	1.7438	17556000.0
2000-08-14 16:00:00	AMZN	Stock	1.7406	1.7531	1.7312	1.7438	1550000.0
2000-08-14 17:00:00	AMZN	Stock	1.7469	1.75	1.7375	1.7375	34000.0
2000-08-14 18:00:00	AMZN	Stock	1.75	1.75	1.7219	1.7344	16000.0
2000-08-14 09:00:00	CL	Stock	27.125	27.125	26.75	26.8438	194400.0
2000-08-14 10:00:00	CL	Stock	26.8438	26.9375	26.5	26.5	213200.0
2000-08-14 11:00:00	CL	Stock	26.5312	26.7188	26.375	26.625	143800.0
2000-08-14 12:00:00	CL	Stock	26.625	26.625	26.4688	26.5625	156200.0
2000-08-14 13:00:00	CL	Stock	26.5625	26.8438	26.5625	26.7812	230800.0
2000-08-14 14:00:00	CL	Stock	26.7812	26.9062	26.6875	26.875	182600.0
2000-08-14 15:00:00	CL	Stock	26.875	27.0312	26.7812	26.9688	422400.0
2000-08-14 16:00:00	CL	Stock	26.9688	26.9688	26.9688	26.9688	20800.0
2000-08-14 17:00:00	CL	Stock	26.9688	26.9688	26.9688	26.9688	4000.0

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

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