PREVIEW / stock_1hour / 2006-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-11.parquet
  size:    587 KB
  rows:    27,685
  symbols: 2,169

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-01-11 04:00:00	AAPL	Stock	2.9089	2.9107	2.9089	2.9107	78400.0
2006-01-11 05:00:00	AAPL	Stock	2.9143	2.9161	2.9143	2.9143	124096.0
2006-01-11 06:00:00	AAPL	Stock	2.9161	2.9232	2.9111	2.9232	95200.0
2006-01-11 07:00:00	AAPL	Stock	2.9232	2.9364	2.9232	2.925	947436.0
2006-01-11 08:00:00	AAPL	Stock	2.9286	3.0057	2.9271	2.9804	59118696.0
2006-01-11 09:00:00	AAPL	Stock	2.9796	3.0	2.9596	2.9857	335560400.0
2006-01-11 10:00:00	AAPL	Stock	2.9857	2.9893	2.9496	2.9639	300123880.0
2006-01-11 11:00:00	AAPL	Stock	2.9636	2.9864	2.9575	2.9775	151007192.0
2006-01-11 12:00:00	AAPL	Stock	2.9775	3.0061	2.9729	3.0057	143107356.0
2006-01-11 13:00:00	AAPL	Stock	3.0054	3.0064	2.9829	2.9864	137255972.0
2006-01-11 14:00:00	AAPL	Stock	2.9868	3.0286	2.9864	3.0193	168984480.0
2006-01-11 15:00:00	AAPL	Stock	3.0193	3.0193	2.9943	2.9971	176081780.0
2006-01-11 16:00:00	AAPL	Stock	2.9982	3.0	2.9893	2.9893	5039300.0
2006-01-11 17:00:00	AAPL	Stock	2.9879	3.0068	2.9821	2.9939	2119712.0
2006-01-11 18:00:00	AAPL	Stock	2.9929	2.9939	2.9921	2.9921	335076.0
2006-01-11 07:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	300.0
2006-01-11 08:00:00	MSFT	Stock	26.95	27.03	26.95	27.0	5487.0
2006-01-11 09:00:00	MSFT	Stock	27.02	27.05	26.9	27.03	5536016.0
2006-01-11 10:00:00	MSFT	Stock	27.03	27.19	26.99	27.08	9723275.0
2006-01-11 11:00:00	MSFT	Stock	27.07	27.25	27.06	27.2	9130270.0
2006-01-11 12:00:00	MSFT	Stock	27.2	27.26	27.12	27.24	8509840.0
2006-01-11 13:00:00	MSFT	Stock	27.24	27.27	27.16	27.2	8562248.0
2006-01-11 14:00:00	MSFT	Stock	27.2	27.39	27.18	27.35	10171154.0
2006-01-11 15:00:00	MSFT	Stock	27.35	27.38	27.19	27.28	16684743.0
2006-01-11 16:00:00	MSFT	Stock	27.29	27.43	27.26	27.3	463883.0
2006-01-11 17:00:00	MSFT	Stock	27.29	27.3	27.29	27.29	947.0
2006-01-11 18:00:00	MSFT	Stock	27.29	27.29	27.25	27.29	2705.0
2006-01-11 09:00:00	NVDA	Stock	0.3518	0.3539	0.3497	0.3515	43313640.0
2006-01-11 10:00:00	NVDA	Stock	0.3516	0.3597	0.35	0.3569	109028400.0
2006-01-11 11:00:00	NVDA	Stock	0.3571	0.3592	0.3557	0.3575	66302640.0
2006-01-11 12:00:00	NVDA	Stock	0.3575	0.3613	0.3575	0.3606	68126640.0
2006-01-11 13:00:00	NVDA	Stock	0.3606	0.3617	0.3591	0.3613	105876960.0
2006-01-11 14:00:00	NVDA	Stock	0.3615	0.3642	0.3608	0.3639	107023080.0
2006-01-11 15:00:00	NVDA	Stock	0.3639	0.3646	0.3613	0.3625	109252440.0
2006-01-11 16:00:00	NVDA	Stock	0.3624	0.3627	0.3618	0.3627	444000.0
2006-01-11 17:00:00	NVDA	Stock	0.3627	0.3633	0.3627	0.3627	168000.0
2006-01-11 18:00:00	NVDA	Stock	0.3633	0.3633	0.3626	0.3626	63000.0
2006-01-11 07:00:00	AMZN	Stock	2.2835	2.2835	2.2835	2.2835	4260.0
2006-01-11 08:00:00	AMZN	Stock	2.2825	2.283	2.27	2.2825	32240.0
2006-01-11 09:00:00	AMZN	Stock	2.285	2.285	2.229	2.2295	34013460.0
2006-01-11 10:00:00	AMZN	Stock	2.2295	2.2485	2.2225	2.2375	30877400.0
2006-01-11 11:00:00	AMZN	Stock	2.2376	2.246	2.2255	2.2415	18185220.0
2006-01-11 12:00:00	AMZN	Stock	2.241	2.2425	2.226	2.226	9703740.0
2006-01-11 13:00:00	AMZN	Stock	2.226	2.241	2.213	2.2325	16698020.0
2006-01-11 14:00:00	AMZN	Stock	2.2325	2.25	2.2295	2.249	21619440.0
2006-01-11 15:00:00	AMZN	Stock	2.2485	2.259	2.2425	2.245	35547980.0
2006-01-11 16:00:00	AMZN	Stock	2.243	2.2485	2.243	2.2465	145660.0
2006-01-11 17:00:00	AMZN	Stock	2.2415	2.2415	2.225	2.225	22000.0
2006-01-11 18:00:00	AMZN	Stock	2.241	2.241	2.241	2.241	2000.0
2006-01-11 09:00:00	CL	Stock	27.425	27.585	27.405	27.425	240200.0

> showing 50 of 27,685 rows — these rows as CSV

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