PREVIEW / stock_1hour / 2006-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-18.parquet
  size:    622 KB
  rows:    29,530
  symbols: 2,240

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-04-18 06:00:00	AAPL	Stock	2.3214	2.3214	2.3214	2.3214	2800.0
2006-04-18 07:00:00	AAPL	Stock	2.3146	2.3225	2.3079	2.3225	90048.0
2006-04-18 08:00:00	AAPL	Stock	2.3232	2.3268	2.3182	2.3229	1328992.0
2006-04-18 09:00:00	AAPL	Stock	2.3239	2.3396	2.3146	2.3304	98845012.0
2006-04-18 10:00:00	AAPL	Stock	2.3304	2.3357	2.3139	2.3246	148368612.0
2006-04-18 11:00:00	AAPL	Stock	2.3246	2.3536	2.3225	2.3532	89307680.0
2006-04-18 12:00:00	AAPL	Stock	2.3532	2.3696	2.3486	2.3586	132207040.0
2006-04-18 13:00:00	AAPL	Stock	2.36	2.3689	2.3446	2.3482	74199888.0
2006-04-18 14:00:00	AAPL	Stock	2.3482	2.3741	2.3482	2.3575	123123672.0
2006-04-18 15:00:00	AAPL	Stock	2.3571	2.3707	2.3557	2.365	110704160.0
2006-04-18 16:00:00	AAPL	Stock	2.3654	2.3821	2.3629	2.3804	2810948.0
2006-04-18 17:00:00	AAPL	Stock	2.3804	2.3871	2.3804	2.3821	1390844.0
2006-04-18 18:00:00	AAPL	Stock	2.3839	2.3854	2.3829	2.3836	240016.0
2006-04-18 06:00:00	MSFT	Stock	26.83	26.83	26.83	26.83	1000.0
2006-04-18 07:00:00	MSFT	Stock	26.82	26.87	26.81	26.84	15131.0
2006-04-18 08:00:00	MSFT	Stock	26.86	26.92	26.84	26.92	41000.0
2006-04-18 09:00:00	MSFT	Stock	26.92	27.5	26.84	26.94	3890653.0
2006-04-18 10:00:00	MSFT	Stock	26.94	26.98	26.82	26.85	6997626.0
2006-04-18 11:00:00	MSFT	Stock	26.85	27.05	26.84	27.03	8188858.0
2006-04-18 12:00:00	MSFT	Stock	27.03	27.15	27.02	27.13	5459720.0
2006-04-18 13:00:00	MSFT	Stock	27.13	27.23	27.08	27.1	5488592.0
2006-04-18 14:00:00	MSFT	Stock	27.111	27.36	27.1	27.19	8709267.0
2006-04-18 15:00:00	MSFT	Stock	27.19	27.3	27.18	27.19	14068910.0
2006-04-18 16:00:00	MSFT	Stock	27.22	27.27	27.15	27.15	135790.0
2006-04-18 17:00:00	MSFT	Stock	27.28	27.28	27.21	27.25	574.0
2006-04-18 18:00:00	MSFT	Stock	27.21	27.27	27.21	27.27	3330.0
2006-04-18 07:00:00	NVDA	Stock	0.4847	0.485	0.4833	0.485	102000.0
2006-04-18 08:00:00	NVDA	Stock	0.4868	0.4887	0.4835	0.4858	3111840.0
2006-04-18 09:00:00	NVDA	Stock	0.4858	0.4947	0.4735	0.4745	280202580.0
2006-04-18 10:00:00	NVDA	Stock	0.4745	0.476	0.4698	0.4735	265698180.0
2006-04-18 11:00:00	NVDA	Stock	0.4735	0.4783	0.4707	0.4778	137526480.0
2006-04-18 12:00:00	NVDA	Stock	0.4778	0.4802	0.4758	0.4772	105786120.0
2006-04-18 13:00:00	NVDA	Stock	0.4772	0.4802	0.4772	0.4793	83341980.0
2006-04-18 14:00:00	NVDA	Stock	0.4793	0.4845	0.4792	0.4795	141028980.0
2006-04-18 15:00:00	NVDA	Stock	0.4797	0.4842	0.4795	0.4827	114129300.0
2006-04-18 16:00:00	NVDA	Stock	0.4832	0.4837	0.4782	0.4783	3089700.0
2006-04-18 17:00:00	NVDA	Stock	0.4828	0.4833	0.4783	0.4833	666000.0
2006-04-18 18:00:00	NVDA	Stock	0.482	0.485	0.482	0.4835	31200.0
2006-04-18 08:00:00	AMZN	Stock	1.7635	1.764	1.7635	1.764	19420.0
2006-04-18 09:00:00	AMZN	Stock	1.766	1.7745	1.76	1.773	10599000.0
2006-04-18 10:00:00	AMZN	Stock	1.772	1.782	1.763	1.7635	9934320.0
2006-04-18 11:00:00	AMZN	Stock	1.7635	1.7915	1.7635	1.7875	11999260.0
2006-04-18 12:00:00	AMZN	Stock	1.787	1.8015	1.7865	1.8015	7612560.0
2006-04-18 13:00:00	AMZN	Stock	1.8015	1.811	1.792	1.793	9558520.0
2006-04-18 14:00:00	AMZN	Stock	1.793	1.807	1.7915	1.8015	14593820.0
2006-04-18 15:00:00	AMZN	Stock	1.8015	1.8225	1.801	1.814	21431940.0
2006-04-18 16:00:00	AMZN	Stock	1.8155	1.8495	1.8065	1.8375	332280.0
2006-04-18 17:00:00	AMZN	Stock	1.823	1.825	1.8225	1.8225	71000.0
2006-04-18 18:00:00	AMZN	Stock	1.82	1.8275	1.82	1.8275	12000.0
2006-04-18 09:00:00	CL	Stock	28.14	28.25	28.1	28.18	170800.0

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

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