PREVIEW / stock_1hour / 2007-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-14.parquet
  size:    746 KB
  rows:    36,913
  symbols: 3,090

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-09-14 09:00:00	AAPL	Stock	4.8775	4.9268	4.8643	4.9118	90510364.0
2007-09-14 10:00:00	AAPL	Stock	4.9118	4.9636	4.9064	4.9471	140606844.0
2007-09-14 11:00:00	AAPL	Stock	4.9471	4.9546	4.9225	4.9418	75177060.0
2007-09-14 12:00:00	AAPL	Stock	4.9421	4.9536	4.92	4.9257	42461160.0
2007-09-14 13:00:00	AAPL	Stock	4.9257	4.9386	4.9196	4.9361	44894780.0
2007-09-14 14:00:00	AAPL	Stock	4.9364	4.9443	4.9254	4.9317	51212336.0
2007-09-14 15:00:00	AAPL	Stock	4.9314	4.9589	4.9261	4.9532	93706396.0
2007-09-14 16:00:00	AAPL	Stock	4.9557	4.9575	4.9525	4.9575	15229788.0
2007-09-14 09:00:00	MSFT	Stock	28.98	28.99	28.88	28.95	2208464.0
2007-09-14 10:00:00	MSFT	Stock	28.953	29.06	28.95	28.97	4839979.0
2007-09-14 11:00:00	MSFT	Stock	28.97	29.03	28.92	28.97	3350514.0
2007-09-14 12:00:00	MSFT	Stock	28.97	29.02	28.95	28.96	2750233.0
2007-09-14 13:00:00	MSFT	Stock	28.96	29.03	28.95	28.99	2397425.0
2007-09-14 14:00:00	MSFT	Stock	29.0	29.01	28.95	28.971	3406911.0
2007-09-14 15:00:00	MSFT	Stock	28.98	29.11	28.97	29.04	7208022.0
2007-09-14 16:00:00	MSFT	Stock	29.04	29.04	29.04	29.04	3076643.0
2007-09-14 07:00:00	NVDA	Stock	0.8273	0.8273	0.8273	0.8273	4000.0
2007-09-14 08:00:00	NVDA	Stock	0.8238	0.8248	0.8175	0.8175	340920.0
2007-09-14 09:00:00	NVDA	Stock	0.818	0.824	0.8095	0.8168	82904040.0
2007-09-14 10:00:00	NVDA	Stock	0.8168	0.8175	0.8102	0.8118	96676160.0
2007-09-14 11:00:00	NVDA	Stock	0.8115	0.8125	0.8038	0.811	69294800.0
2007-09-14 12:00:00	NVDA	Stock	0.8113	0.814	0.8058	0.8078	40019600.0
2007-09-14 13:00:00	NVDA	Stock	0.8078	0.8132	0.8072	0.8098	38959200.0
2007-09-14 14:00:00	NVDA	Stock	0.8098	0.8102	0.8052	0.8058	45671680.0
2007-09-14 15:00:00	NVDA	Stock	0.8058	0.8068	0.8052	0.8062	73855120.0
2007-09-14 16:00:00	NVDA	Stock	0.8062	0.8062	0.8025	0.8058	23811280.0
2007-09-14 17:00:00	NVDA	Stock	0.8058	0.808	0.8058	0.8058	126800.0
2007-09-14 18:00:00	NVDA	Stock	0.803	0.803	0.803	0.803	40000.0
2007-09-14 19:00:00	NVDA	Stock	0.8072	0.8078	0.8072	0.8078	52400.0
2007-09-14 07:00:00	AMZN	Stock	4.3165	4.349	4.285	4.325	65100.0
2007-09-14 08:00:00	AMZN	Stock	4.325	4.3375	4.3205	4.3205	690380.0
2007-09-14 09:00:00	AMZN	Stock	4.321	4.3715	4.3155	4.353	13693280.0
2007-09-14 10:00:00	AMZN	Stock	4.3535	4.4045	4.3535	4.3805	18663740.0
2007-09-14 11:00:00	AMZN	Stock	4.379	4.385	4.3705	4.375	5692480.0
2007-09-14 12:00:00	AMZN	Stock	4.375	4.377	4.341	4.349	5932340.0
2007-09-14 13:00:00	AMZN	Stock	4.3485	4.3615	4.341	4.358	6292480.0
2007-09-14 14:00:00	AMZN	Stock	4.3575	4.386	4.341	4.3505	7278140.0
2007-09-14 15:00:00	AMZN	Stock	4.351	4.39	4.349	4.3885	14039800.0
2007-09-14 16:00:00	AMZN	Stock	4.3845	4.4	4.384	4.3895	3667360.0
2007-09-14 17:00:00	AMZN	Stock	4.3875	4.3875	4.3875	4.3875	2000.0
2007-09-14 18:00:00	AMZN	Stock	4.3865	4.3875	4.3855	4.3855	24000.0
2007-09-14 19:00:00	AMZN	Stock	4.3855	4.39	4.3855	4.3855	38880.0
2007-09-14 09:00:00	TLT	Stock	90.58	90.59	90.46	90.53	344300.0
2007-09-14 10:00:00	TLT	Stock	90.53	90.56	89.79	89.94	451800.0
2007-09-14 11:00:00	TLT	Stock	89.93	89.98	89.67	89.7	138900.0
2007-09-14 12:00:00	TLT	Stock	89.69	89.79	89.62	89.74	101700.0
2007-09-14 13:00:00	TLT	Stock	89.76	89.83	89.66	89.8	37100.0
2007-09-14 14:00:00	TLT	Stock	89.8	90.07	89.8	90.01	79570.0
2007-09-14 15:00:00	TLT	Stock	90.01	90.06	89.92	90.0	67000.0
2007-09-14 16:00:00	TLT	Stock	90.0	90.01	89.91	89.91	1900.0

> showing 50 of 36,913 rows — these rows as CSV

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