PREVIEW / stock_1hour / 2007-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-23.parquet
  size:    690 KB
  rows:    32,408
  symbols: 2,592

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
2007-04-23 05:00:00	AAPL	Stock	3.2607	3.2607	3.2607	3.2607	2800.0
2007-04-23 07:00:00	AAPL	Stock	3.25	3.285	3.25	3.2732	672000.0
2007-04-23 08:00:00	AAPL	Stock	3.2761	3.2768	3.2489	3.2696	2438492.0
2007-04-23 09:00:00	AAPL	Stock	3.2686	3.3132	3.2646	3.3082	131288220.0
2007-04-23 10:00:00	AAPL	Stock	3.3086	3.3125	3.2709	3.3104	120870148.0
2007-04-23 11:00:00	AAPL	Stock	3.3104	3.3304	3.3075	3.3236	112779464.0
2007-04-23 12:00:00	AAPL	Stock	3.3232	3.3318	3.3207	3.3275	61503064.0
2007-04-23 13:00:00	AAPL	Stock	3.3272	3.3343	3.3125	3.3125	75482036.0
2007-04-23 14:00:00	AAPL	Stock	3.3125	3.3389	3.3089	3.3382	91654808.0
2007-04-23 15:00:00	AAPL	Stock	3.3389	3.35	3.3311	3.3407	145428416.0
2007-04-23 16:00:00	AAPL	Stock	3.3407	3.3493	3.3393	3.3464	30914604.0
2007-04-23 17:00:00	AAPL	Stock	3.345	3.3482	3.3414	3.3464	363664.0
2007-04-23 18:00:00	AAPL	Stock	3.3464	3.3482	3.3429	3.3464	310716.0
2007-04-23 19:00:00	AAPL	Stock	3.3475	3.3489	3.3429	3.3454	484036.0
2007-04-23 08:00:00	MSFT	Stock	29.0	29.1	29.0	29.02	32870.0
2007-04-23 09:00:00	MSFT	Stock	29.0	29.02	28.8	28.81	5903630.0
2007-04-23 10:00:00	MSFT	Stock	28.82	28.87	28.72	28.77	5574124.0
2007-04-23 11:00:00	MSFT	Stock	28.77	28.89	28.76	28.82	6004383.0
2007-04-23 12:00:00	MSFT	Stock	28.83	28.83	28.69	28.79	4191029.0
2007-04-23 13:00:00	MSFT	Stock	28.79	28.82	28.68	28.7	3176248.0
2007-04-23 14:00:00	MSFT	Stock	28.71	28.83	28.67	28.79	5015116.0
2007-04-23 15:00:00	MSFT	Stock	28.782	28.84	28.74	28.79	5977833.0
2007-04-23 16:00:00	MSFT	Stock	28.78	28.9	28.75	28.9	3206219.0
2007-04-23 17:00:00	MSFT	Stock	28.91	28.91	28.85	28.85	12550.0
2007-04-23 18:00:00	MSFT	Stock	28.85	28.87	28.85	28.87	3430.0
2007-04-23 19:00:00	MSFT	Stock	28.87	28.87	28.86	28.86	6300.0
2007-04-23 08:00:00	NVDA	Stock	0.5317	0.538	0.5317	0.538	300000.0
2007-04-23 09:00:00	NVDA	Stock	0.5335	0.5335	0.5243	0.526	76554660.0
2007-04-23 10:00:00	NVDA	Stock	0.526	0.528	0.5233	0.5258	96789660.0
2007-04-23 11:00:00	NVDA	Stock	0.5258	0.5262	0.522	0.5225	100412760.0
2007-04-23 12:00:00	NVDA	Stock	0.5227	0.5235	0.5215	0.5225	42107220.0
2007-04-23 13:00:00	NVDA	Stock	0.5227	0.5248	0.5213	0.523	47539020.0
2007-04-23 14:00:00	NVDA	Stock	0.523	0.5265	0.5213	0.5257	56461380.0
2007-04-23 15:00:00	NVDA	Stock	0.5255	0.5258	0.5225	0.523	100746120.0
2007-04-23 16:00:00	NVDA	Stock	0.5232	0.5367	0.5228	0.5365	8478120.0
2007-04-23 17:00:00	NVDA	Stock	0.5333	0.5333	0.53	0.5307	414000.0
2007-04-23 18:00:00	NVDA	Stock	0.5285	0.5285	0.5275	0.5283	249000.0
2007-04-23 19:00:00	NVDA	Stock	0.5283	0.5283	0.5283	0.5283	90000.0
2007-04-23 06:00:00	AMZN	Stock	2.224	2.224	2.224	2.224	2000.0
2007-04-23 07:00:00	AMZN	Stock	2.2185	2.2245	2.216	2.22	62000.0
2007-04-23 08:00:00	AMZN	Stock	2.225	2.2475	2.216	2.2205	353880.0
2007-04-23 09:00:00	AMZN	Stock	2.2175	2.2305	2.208	2.209	21521720.0
2007-04-23 10:00:00	AMZN	Stock	2.2095	2.23	2.209	2.224	21012100.0
2007-04-23 11:00:00	AMZN	Stock	2.2235	2.234	2.2195	2.226	18765660.0
2007-04-23 12:00:00	AMZN	Stock	2.226	2.226	2.2175	2.223	11275260.0
2007-04-23 13:00:00	AMZN	Stock	2.223	2.228	2.2155	2.216	13774120.0
2007-04-23 14:00:00	AMZN	Stock	2.216	2.23	2.214	2.2285	18793720.0
2007-04-23 15:00:00	AMZN	Stock	2.2285	2.2405	2.2275	2.2395	33041820.0
2007-04-23 16:00:00	AMZN	Stock	2.2385	2.2475	2.2385	2.2475	182620.0
2007-04-23 17:00:00	AMZN	Stock	2.2405	2.2495	2.24	2.24	601000.0

> showing 50 of 32,408 rows — these rows as CSV

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