PREVIEW / stock_1hour / 2006-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-22.parquet
  size:    603 KB
  rows:    29,138
  symbols: 2,215

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
2006-03-22 04:00:00	AAPL	Stock	2.2232	2.225	2.2232	2.225	19600.0
2006-03-22 05:00:00	AAPL	Stock	2.2232	2.225	2.2232	2.2232	84000.0
2006-03-22 06:00:00	AAPL	Stock	2.2286	2.25	2.2179	2.25	215320.0
2006-03-22 07:00:00	AAPL	Stock	2.2411	2.2529	2.2321	2.2436	1984892.0
2006-03-22 08:00:00	AAPL	Stock	2.2475	2.2554	2.22	2.2239	19619180.0
2006-03-22 09:00:00	AAPL	Stock	2.2239	2.2346	2.2039	2.2121	204346520.0
2006-03-22 10:00:00	AAPL	Stock	2.2121	2.2304	2.1989	2.2218	251837376.0
2006-03-22 11:00:00	AAPL	Stock	2.2214	2.2432	2.2186	2.2379	195626200.0
2006-03-22 12:00:00	AAPL	Stock	2.2375	2.2589	2.2357	2.24	137253256.0
2006-03-22 13:00:00	AAPL	Stock	2.24	2.2414	2.2182	2.2193	110049940.0
2006-03-22 14:00:00	AAPL	Stock	2.2186	2.2257	2.1882	2.2	216981352.0
2006-03-22 15:00:00	AAPL	Stock	2.1996	2.2364	2.195	2.2021	189032004.0
2006-03-22 16:00:00	AAPL	Stock	2.2025	2.2029	2.1964	2.1968	9447200.0
2006-03-22 17:00:00	AAPL	Stock	2.1982	2.205	2.1964	2.2021	587356.0
2006-03-22 18:00:00	AAPL	Stock	2.2004	2.2018	2.1975	2.2	270060.0
2006-03-22 04:00:00	MSFT	Stock	27.05	27.05	26.98	26.98	1100.0
2006-03-22 05:00:00	MSFT	Stock	26.95	27.0	26.95	27.0	700.0
2006-03-22 06:00:00	MSFT	Stock	27.0	27.05	27.0	27.05	1100.0
2006-03-22 07:00:00	MSFT	Stock	27.05	27.14	27.03	27.09	45072.0
2006-03-22 08:00:00	MSFT	Stock	27.07	27.26	27.01	27.13	3928339.0
2006-03-22 09:00:00	MSFT	Stock	27.14	27.5	26.796	26.96	30602333.0
2006-03-22 10:00:00	MSFT	Stock	26.96	27.06	26.92	26.93	26695597.0
2006-03-22 11:00:00	MSFT	Stock	26.93	27.05	26.93	27.04	15771604.0
2006-03-22 12:00:00	MSFT	Stock	27.04	27.13	26.99	27.03	18909296.0
2006-03-22 13:00:00	MSFT	Stock	27.04	27.13	26.99	27.06	12903766.0
2006-03-22 14:00:00	MSFT	Stock	27.05	27.1	26.96	27.0	8810060.0
2006-03-22 15:00:00	MSFT	Stock	27.0	27.21	26.99	27.14	24721721.0
2006-03-22 16:00:00	MSFT	Stock	27.14	27.2	25.62	27.13	605767.0
2006-03-22 17:00:00	MSFT	Stock	27.15	27.15	27.14	27.15	5210.0
2006-03-22 18:00:00	MSFT	Stock	27.15	27.15	27.14	27.15	1683.0
2006-03-22 07:00:00	NVDA	Stock	0.4147	0.4178	0.4137	0.4137	447960.0
2006-03-22 08:00:00	NVDA	Stock	0.4149	0.4158	0.4116	0.4125	11148840.0
2006-03-22 09:00:00	NVDA	Stock	0.4117	0.4145	0.4021	0.4073	307315440.0
2006-03-22 10:00:00	NVDA	Stock	0.4073	0.4077	0.4018	0.4053	286872600.0
2006-03-22 11:00:00	NVDA	Stock	0.4052	0.4117	0.4041	0.4092	133138920.0
2006-03-22 12:00:00	NVDA	Stock	0.4091	0.41	0.4047	0.4097	91736160.0
2006-03-22 13:00:00	NVDA	Stock	0.4097	0.4122	0.406	0.4102	92620320.0
2006-03-22 14:00:00	NVDA	Stock	0.4103	0.4119	0.4071	0.4094	77503200.0
2006-03-22 15:00:00	NVDA	Stock	0.4094	0.4138	0.4081	0.4113	116277000.0
2006-03-22 16:00:00	NVDA	Stock	0.4115	0.4127	0.4096	0.4111	3329520.0
2006-03-22 17:00:00	NVDA	Stock	0.4111	0.4112	0.4111	0.4111	100680.0
2006-03-22 08:00:00	AMZN	Stock	1.7985	1.7985	1.7985	1.7985	3260.0
2006-03-22 09:00:00	AMZN	Stock	1.7985	1.8195	1.7945	1.8145	9017620.0
2006-03-22 10:00:00	AMZN	Stock	1.8145	1.827	1.7975	1.7975	15124700.0
2006-03-22 11:00:00	AMZN	Stock	1.798	1.824	1.7965	1.8135	14542700.0
2006-03-22 12:00:00	AMZN	Stock	1.8135	1.8175	1.8025	1.807	5063980.0
2006-03-22 13:00:00	AMZN	Stock	1.807	1.814	1.801	1.801	7757040.0
2006-03-22 14:00:00	AMZN	Stock	1.8015	1.8025	1.7895	1.792	13094060.0
2006-03-22 15:00:00	AMZN	Stock	1.7915	1.802	1.7905	1.8	17693380.0
2006-03-22 16:00:00	AMZN	Stock	1.8	1.8	1.798	1.8	2112720.0

> showing 50 of 29,138 rows — these rows as CSV

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