PREVIEW / stock_1hour / 2006-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-04.parquet
  size:    656 KB
  rows:    30,974
  symbols: 2,473

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-12-04 06:00:00	AAPL	Stock	3.2718	3.2718	3.2646	3.2646	22400.0
2006-12-04 07:00:00	AAPL	Stock	3.2607	3.2725	3.2607	3.2725	15400.0
2006-12-04 08:00:00	AAPL	Stock	3.2643	3.2846	3.2611	3.2782	3537548.0
2006-12-04 09:00:00	AAPL	Stock	3.2786	3.2829	3.2411	3.25	115082884.0
2006-12-04 10:00:00	AAPL	Stock	3.25	3.2739	3.2321	3.2478	157384752.0
2006-12-04 11:00:00	AAPL	Stock	3.2479	3.2639	3.2432	3.25	83537048.0
2006-12-04 12:00:00	AAPL	Stock	3.2496	3.2557	3.2411	3.2486	49695716.0
2006-12-04 13:00:00	AAPL	Stock	3.2485	3.2757	3.2454	3.27	82129180.0
2006-12-04 14:00:00	AAPL	Stock	3.27	3.28	3.2607	3.2779	72791796.0
2006-12-04 15:00:00	AAPL	Stock	3.2775	3.2875	3.2511	3.2543	137785564.0
2006-12-04 16:00:00	AAPL	Stock	3.2532	3.2712	3.2507	3.2536	1432900.0
2006-12-04 17:00:00	AAPL	Stock	3.2536	3.2546	3.2525	3.2532	289716.0
2006-12-04 18:00:00	AAPL	Stock	3.2543	3.2543	3.2518	3.2529	268688.0
2006-12-04 19:00:00	AAPL	Stock	3.2529	3.2536	3.2507	3.2536	291844.0
2006-12-04 08:00:00	MSFT	Stock	29.18	29.18	29.1	29.1	39986.0
2006-12-04 09:00:00	MSFT	Stock	29.12	29.37	29.11	29.28	6581557.0
2006-12-04 10:00:00	MSFT	Stock	29.28	29.44	29.26	29.37	11382005.0
2006-12-04 11:00:00	MSFT	Stock	29.37	29.44	29.33	29.35	5821444.0
2006-12-04 12:00:00	MSFT	Stock	29.353	29.39	29.34	29.39	2944795.0
2006-12-04 13:00:00	MSFT	Stock	29.39	29.41	29.33	29.33	5836326.0
2006-12-04 14:00:00	MSFT	Stock	29.33	29.51	29.33	29.5	8930309.0
2006-12-04 15:00:00	MSFT	Stock	29.51	29.52	29.31	29.33	10643272.0
2006-12-04 16:00:00	MSFT	Stock	29.33	29.399	29.27	29.29	108924.0
2006-12-04 17:00:00	MSFT	Stock	29.3	29.32	29.3	29.3	5660.0
2006-12-04 18:00:00	MSFT	Stock	29.33	29.33	29.33	29.33	11782.0
2006-12-04 19:00:00	MSFT	Stock	29.33	29.33	29.3	29.3	3098.0
2006-12-04 07:00:00	NVDA	Stock	0.5973	0.5973	0.5973	0.5973	90000.0
2006-12-04 08:00:00	NVDA	Stock	0.599	0.599	0.5908	0.598	817080.0
2006-12-04 09:00:00	NVDA	Stock	0.5983	0.605	0.5965	0.6025	62962860.0
2006-12-04 10:00:00	NVDA	Stock	0.6023	0.6123	0.6015	0.6123	109903860.0
2006-12-04 11:00:00	NVDA	Stock	0.6123	0.6185	0.6115	0.6157	110661960.0
2006-12-04 12:00:00	NVDA	Stock	0.6157	0.6217	0.6153	0.6213	67687500.0
2006-12-04 13:00:00	NVDA	Stock	0.6215	0.624	0.6175	0.6227	71754060.0
2006-12-04 14:00:00	NVDA	Stock	0.6228	0.6228	0.618	0.6202	68014500.0
2006-12-04 15:00:00	NVDA	Stock	0.6202	0.6203	0.614	0.6163	114350640.0
2006-12-04 16:00:00	NVDA	Stock	0.6157	0.6169	0.6153	0.6169	1368000.0
2006-12-04 17:00:00	NVDA	Stock	0.6158	0.6183	0.6157	0.6183	408780.0
2006-12-04 18:00:00	NVDA	Stock	0.6163	0.6163	0.6157	0.6157	193020.0
2006-12-04 19:00:00	NVDA	Stock	0.6167	0.6167	0.6153	0.6165	102540.0
2006-12-04 08:00:00	AMZN	Stock	1.9705	1.9705	1.9705	1.9705	23460.0
2006-12-04 09:00:00	AMZN	Stock	1.9635	1.9705	1.9565	1.959	19158680.0
2006-12-04 10:00:00	AMZN	Stock	1.9595	1.967	1.951	1.9565	31469320.0
2006-12-04 11:00:00	AMZN	Stock	1.9565	1.9695	1.9515	1.9545	28152640.0
2006-12-04 12:00:00	AMZN	Stock	1.954	1.9575	1.9435	1.947	20842920.0
2006-12-04 13:00:00	AMZN	Stock	1.9475	1.974	1.947	1.9614	29466160.0
2006-12-04 14:00:00	AMZN	Stock	1.9615	1.9725	1.956	1.961	16260540.0
2006-12-04 15:00:00	AMZN	Stock	1.961	1.962	1.948	1.955	26342960.0
2006-12-04 16:00:00	AMZN	Stock	1.953	1.9587	1.953	1.9542	782000.0
2006-12-04 17:00:00	AMZN	Stock	1.9535	1.9535	1.9535	1.9535	38000.0
2006-12-04 18:00:00	AMZN	Stock	1.955	1.955	1.955	1.955	18280.0

> showing 50 of 30,974 rows — these rows as CSV

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