PREVIEW / stock_1hour / 2006-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-19.parquet
  size:    595 KB
  rows:    28,320
  symbols: 2,175

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-19 05:00:00	AAPL	Stock	2.85	2.85	2.85	2.85	2800.0
2006-01-19 06:00:00	AAPL	Stock	2.8518	2.8518	2.8518	2.8518	11200.0
2006-01-19 07:00:00	AAPL	Stock	2.8482	2.8918	2.8482	2.8779	1770440.0
2006-01-19 08:00:00	AAPL	Stock	2.8757	2.95	2.8527	2.9214	63870772.0
2006-01-19 09:00:00	AAPL	Stock	2.9211	2.9214	2.8643	2.8964	323328012.0
2006-01-19 10:00:00	AAPL	Stock	2.8961	2.9164	2.84	2.8554	423395980.0
2006-01-19 11:00:00	AAPL	Stock	2.8554	2.8764	2.8121	2.8375	279090672.0
2006-01-19 12:00:00	AAPL	Stock	2.8375	2.8743	2.8304	2.8689	164150560.0
2006-01-19 13:00:00	AAPL	Stock	2.8686	2.8739	2.8561	2.8571	109814432.0
2006-01-19 14:00:00	AAPL	Stock	2.8571	2.8586	2.8371	2.8375	117479180.0
2006-01-19 15:00:00	AAPL	Stock	2.8371	2.8468	2.8214	2.8239	190374548.0
2006-01-19 16:00:00	AAPL	Stock	2.8239	2.8364	2.8214	2.8321	5216176.0
2006-01-19 17:00:00	AAPL	Stock	2.8332	2.8429	2.8246	2.835	1300208.0
2006-01-19 18:00:00	AAPL	Stock	2.835	2.8375	2.8336	2.8339	270676.0
2006-01-19 08:00:00	MSFT	Stock	27.0	27.0	26.88	26.89	207900.0
2006-01-19 09:00:00	MSFT	Stock	26.89	26.98	26.83	26.95	5559328.0
2006-01-19 10:00:00	MSFT	Stock	26.94	27.05	26.93	26.97	8061434.0
2006-01-19 11:00:00	MSFT	Stock	26.97	27.04	26.92	27.03	6569658.0
2006-01-19 12:00:00	MSFT	Stock	27.03	27.11	26.96	27.09	8970103.0
2006-01-19 13:00:00	MSFT	Stock	27.1	27.19	27.08	27.18	7211303.0
2006-01-19 14:00:00	MSFT	Stock	27.18	27.24	27.02	27.04	8977863.0
2006-01-19 15:00:00	MSFT	Stock	27.05	27.07	26.97	27.01	10313016.0
2006-01-19 16:00:00	MSFT	Stock	27.0	27.02	27.0	27.0	2428124.0
2006-01-19 17:00:00	MSFT	Stock	26.96	27.0	26.95	27.0	9031.0
2006-01-19 18:00:00	MSFT	Stock	26.98	27.0	26.95	26.95	4850.0
2006-01-19 08:00:00	NVDA	Stock	0.3651	0.3651	0.3608	0.3608	321000.0
2006-01-19 09:00:00	NVDA	Stock	0.3608	0.3699	0.3583	0.3672	113721120.0
2006-01-19 10:00:00	NVDA	Stock	0.3675	0.3745	0.3672	0.3718	240793320.0
2006-01-19 11:00:00	NVDA	Stock	0.372	0.3758	0.3715	0.3755	121511640.0
2006-01-19 12:00:00	NVDA	Stock	0.3755	0.3796	0.3738	0.3785	128655240.0
2006-01-19 13:00:00	NVDA	Stock	0.3785	0.3805	0.3778	0.3792	70624920.0
2006-01-19 14:00:00	NVDA	Stock	0.3792	0.3795	0.3762	0.3785	77848440.0
2006-01-19 15:00:00	NVDA	Stock	0.3784	0.3784	0.3742	0.376	104980560.0
2006-01-19 16:00:00	NVDA	Stock	0.3763	0.3771	0.375	0.3771	2511000.0
2006-01-19 17:00:00	NVDA	Stock	0.3756	0.3756	0.3754	0.3754	291480.0
2006-01-19 08:00:00	AMZN	Stock	2.219	2.2435	2.205	2.22	487000.0
2006-01-19 09:00:00	AMZN	Stock	2.216	2.249	2.214	2.243	21960300.0
2006-01-19 10:00:00	AMZN	Stock	2.244	2.255	2.241	2.2445	17767000.0
2006-01-19 11:00:00	AMZN	Stock	2.244	2.247	2.231	2.2415	11101260.0
2006-01-19 12:00:00	AMZN	Stock	2.2415	2.2585	2.238	2.2525	9114000.0
2006-01-19 13:00:00	AMZN	Stock	2.253	2.262	2.239	2.2405	8995520.0
2006-01-19 14:00:00	AMZN	Stock	2.24	2.244	2.2255	2.2315	10032640.0
2006-01-19 15:00:00	AMZN	Stock	2.2315	2.2315	2.215	2.222	21047680.0
2006-01-19 16:00:00	AMZN	Stock	2.2235	2.2235	2.2175	2.2225	291880.0
2006-01-19 17:00:00	AMZN	Stock	2.22	2.225	2.22	2.225	66780.0
2006-01-19 09:00:00	CL	Stock	26.77	27.4	26.77	27.34	491000.0
2006-01-19 10:00:00	CL	Stock	27.345	27.385	27.25	27.26	714800.0
2006-01-19 11:00:00	CL	Stock	27.27	27.33	27.265	27.325	525000.0
2006-01-19 12:00:00	CL	Stock	27.33	27.4	27.305	27.399	657600.0
2006-01-19 13:00:00	CL	Stock	27.395	27.45	27.375	27.41	465600.0

> showing 50 of 28,320 rows — these rows as CSV

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