PREVIEW / stock_1hour / 2005-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-15.parquet
  size:    560 KB
  rows:    26,402
  symbols: 1,990

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
2005-06-15 07:00:00	AAPL	Stock	1.3	1.3068	1.2964	1.2964	36540.0
2005-06-15 08:00:00	AAPL	Stock	1.3018	1.3107	1.2946	1.3064	4371388.0
2005-06-15 09:00:00	AAPL	Stock	1.3057	1.3321	1.3036	1.3207	128236472.0
2005-06-15 10:00:00	AAPL	Stock	1.3207	1.3232	1.2975	1.2982	130833080.0
2005-06-15 11:00:00	AAPL	Stock	1.2982	1.3096	1.2964	1.2982	60899496.0
2005-06-15 12:00:00	AAPL	Stock	1.2982	1.3039	1.2971	1.3032	38272528.0
2005-06-15 13:00:00	AAPL	Stock	1.3032	1.3146	1.2982	1.3104	48492864.0
2005-06-15 14:00:00	AAPL	Stock	1.3104	1.3179	1.3079	1.315	47981696.0
2005-06-15 15:00:00	AAPL	Stock	1.315	1.3261	1.3114	1.3257	87492776.0
2005-06-15 16:00:00	AAPL	Stock	1.3261	1.3264	1.3196	1.3236	3797948.0
2005-06-15 17:00:00	AAPL	Stock	1.3218	1.3261	1.3218	1.3225	3323572.0
2005-06-15 18:00:00	AAPL	Stock	1.3214	1.3236	1.3211	1.3218	106540.0
2005-06-15 07:00:00	MSFT	Stock	25.41	25.41	25.41	25.41	100.0
2005-06-15 08:00:00	MSFT	Stock	25.36	25.42	25.36	25.42	33092.0
2005-06-15 09:00:00	MSFT	Stock	25.43	25.43	25.32	25.34	5591295.0
2005-06-15 10:00:00	MSFT	Stock	25.33	25.35	25.21	25.24	9476915.0
2005-06-15 11:00:00	MSFT	Stock	25.24	25.28	25.16	25.17	6307466.0
2005-06-15 12:00:00	MSFT	Stock	25.17	25.18	25.11	25.151	5595344.0
2005-06-15 13:00:00	MSFT	Stock	25.15	25.21	25.12	25.15	5488532.0
2005-06-15 14:00:00	MSFT	Stock	25.15	25.23	25.13	25.19	6293254.0
2005-06-15 15:00:00	MSFT	Stock	25.18	25.28	25.12	25.27	10614393.0
2005-06-15 16:00:00	MSFT	Stock	25.26	25.27	25.24	25.26	303414.0
2005-06-15 17:00:00	MSFT	Stock	25.25	25.26	25.25	25.26	2679.0
2005-06-15 18:00:00	MSFT	Stock	25.26	25.26	25.26	25.26	3000.0
2005-06-15 08:00:00	NVDA	Stock	0.2208	0.2254	0.2208	0.2226	637920.0
2005-06-15 09:00:00	NVDA	Stock	0.2229	0.2235	0.2172	0.2195	200556000.0
2005-06-15 10:00:00	NVDA	Stock	0.2195	0.2196	0.2157	0.2174	310289280.0
2005-06-15 11:00:00	NVDA	Stock	0.2174	0.2216	0.216	0.216	362682360.0
2005-06-15 12:00:00	NVDA	Stock	0.2161	0.2191	0.2147	0.2189	218719800.0
2005-06-15 13:00:00	NVDA	Stock	0.2189	0.2197	0.2149	0.2186	120633960.0
2005-06-15 14:00:00	NVDA	Stock	0.2186	0.222	0.2186	0.2208	182606040.0
2005-06-15 15:00:00	NVDA	Stock	0.2209	0.2246	0.2207	0.2235	256704600.0
2005-06-15 16:00:00	NVDA	Stock	0.2236	0.2237	0.223	0.223	2081040.0
2005-06-15 17:00:00	NVDA	Stock	0.2234	0.2242	0.2232	0.224	1695600.0
2005-06-15 18:00:00	NVDA	Stock	0.224	0.224	0.224	0.224	114000.0
2005-06-15 08:00:00	AMZN	Stock	1.7555	1.758	1.7555	1.758	12000.0
2005-06-15 09:00:00	AMZN	Stock	1.7585	1.7705	1.75	1.75	13585820.0
2005-06-15 10:00:00	AMZN	Stock	1.7495	1.75	1.726	1.7315	18554100.0
2005-06-15 11:00:00	AMZN	Stock	1.731	1.742	1.728	1.7405	12105320.0
2005-06-15 12:00:00	AMZN	Stock	1.7405	1.7405	1.732	1.735	8396640.0
2005-06-15 13:00:00	AMZN	Stock	1.7345	1.743	1.731	1.733	11107780.0
2005-06-15 14:00:00	AMZN	Stock	1.7331	1.747	1.73	1.747	16601620.0
2005-06-15 15:00:00	AMZN	Stock	1.746	1.764	1.7435	1.762	21436260.0
2005-06-15 16:00:00	AMZN	Stock	1.762	1.7675	1.758	1.7675	438780.0
2005-06-15 17:00:00	AMZN	Stock	1.7625	1.764	1.7625	1.764	316500.0
2005-06-15 09:00:00	CL	Stock	24.875	24.875	24.685	24.725	309200.0
2005-06-15 10:00:00	CL	Stock	24.725	24.745	24.61	24.615	483000.0
2005-06-15 11:00:00	CL	Stock	24.615	24.675	24.6	24.643	321400.0
2005-06-15 12:00:00	CL	Stock	24.635	24.645	24.59	24.605	169400.0
2005-06-15 13:00:00	CL	Stock	24.605	24.65	24.58	24.62	201000.0

> showing 50 of 26,402 rows — these rows as CSV

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