PREVIEW / stock_1hour / 2009-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-16.parquet
  size:    807 KB
  rows:    39,911
  symbols: 3,329

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
2009-03-16 05:00:00	AAPL	Stock	3.4768	3.4768	3.4768	3.4768	25200.0
2009-03-16 06:00:00	AAPL	Stock	3.4768	3.4821	3.4768	3.4821	50400.0
2009-03-16 07:00:00	AAPL	Stock	3.4821	3.4904	3.4779	3.4904	14000.0
2009-03-16 08:00:00	AAPL	Stock	3.4836	3.4904	3.4571	3.4589	918708.0
2009-03-16 09:00:00	AAPL	Stock	3.4593	3.4643	3.3957	3.4114	82453000.0
2009-03-16 10:00:00	AAPL	Stock	3.4104	3.4211	3.3636	3.3668	102934412.0
2009-03-16 11:00:00	AAPL	Stock	3.3671	3.4421	3.3657	3.4311	80224032.0
2009-03-16 12:00:00	AAPL	Stock	3.4318	3.4782	3.4225	3.4675	83475812.0
2009-03-16 13:00:00	AAPL	Stock	3.4675	3.4704	3.3822	3.4096	169506596.0
2009-03-16 14:00:00	AAPL	Stock	3.4096	3.4411	3.3996	3.4289	88443572.0
2009-03-16 15:00:00	AAPL	Stock	3.4286	3.4454	3.4004	3.41	126289408.0
2009-03-16 16:00:00	AAPL	Stock	3.4061	3.4368	3.3946	3.4136	54548396.0
2009-03-16 17:00:00	AAPL	Stock	3.4136	3.4136	3.4136	3.4136	64400.0
2009-03-16 18:00:00	AAPL	Stock	3.4164	3.4164	3.4079	3.4161	170912.0
2009-03-16 19:00:00	AAPL	Stock	3.4154	3.425	3.4154	3.4232	242536.0
2009-03-16 04:00:00	MSFT	Stock	16.8	16.8	16.8	16.8	200.0
2009-03-16 07:00:00	MSFT	Stock	16.89	16.89	16.79	16.84	18600.0
2009-03-16 08:00:00	MSFT	Stock	16.85	16.85	16.75	16.81	62530.0
2009-03-16 09:00:00	MSFT	Stock	16.78	16.96	16.54	16.65	6289070.0
2009-03-16 10:00:00	MSFT	Stock	16.65	16.67	16.33	16.382	10441264.0
2009-03-16 11:00:00	MSFT	Stock	16.38	16.72	16.38	16.69	8094663.0
2009-03-16 12:00:00	MSFT	Stock	16.69	16.94	16.66	16.92	8485340.0
2009-03-16 13:00:00	MSFT	Stock	16.91	16.93	16.7	16.725	5712347.0
2009-03-16 14:00:00	MSFT	Stock	16.72	16.74	16.44	16.46	8585940.0
2009-03-16 15:00:00	MSFT	Stock	16.46	16.48	16.24	16.28	14846147.0
2009-03-16 16:00:00	MSFT	Stock	16.28	16.576	16.23	16.28	3535978.0
2009-03-16 17:00:00	MSFT	Stock	16.28	16.28	16.25	16.26	7350.0
2009-03-16 18:00:00	MSFT	Stock	16.28	16.3	16.25	16.28	147911.0
2009-03-16 19:00:00	MSFT	Stock	16.3	16.35	16.28	16.31	4362.0
2009-03-16 08:00:00	NVDA	Stock	0.2468	0.2475	0.2468	0.2475	244800.0
2009-03-16 09:00:00	NVDA	Stock	0.2488	0.2488	0.2425	0.2428	85051760.0
2009-03-16 10:00:00	NVDA	Stock	0.2428	0.243	0.2355	0.2385	133237520.0
2009-03-16 11:00:00	NVDA	Stock	0.2388	0.2425	0.2384	0.242	66434360.0
2009-03-16 12:00:00	NVDA	Stock	0.242	0.2465	0.2412	0.2462	63264640.0
2009-03-16 13:00:00	NVDA	Stock	0.2462	0.2465	0.2418	0.2426	73539000.0
2009-03-16 14:00:00	NVDA	Stock	0.2425	0.2428	0.239	0.239	63480160.0
2009-03-16 15:00:00	NVDA	Stock	0.2392	0.2392	0.2335	0.2358	181668720.0
2009-03-16 16:00:00	NVDA	Stock	0.2362	0.2403	0.2352	0.2355	21161480.0
2009-03-16 17:00:00	NVDA	Stock	0.2362	0.2362	0.2362	0.2362	25200.0
2009-03-16 18:00:00	NVDA	Stock	0.2315	0.2348	0.2315	0.2348	60000.0
2009-03-16 19:00:00	NVDA	Stock	0.2348	0.2348	0.2348	0.2348	12000.0
2009-03-16 07:00:00	AMZN	Stock	3.445	3.445	3.445	3.445	2000.0
2009-03-16 08:00:00	AMZN	Stock	3.4475	3.475	3.4475	3.45	21000.0
2009-03-16 09:00:00	AMZN	Stock	3.45	3.45	3.3455	3.355	21521600.0
2009-03-16 10:00:00	AMZN	Stock	3.355	3.3895	3.334	3.3405	23373700.0
2009-03-16 11:00:00	AMZN	Stock	3.341	3.4165	3.3376	3.411	21439060.0
2009-03-16 12:00:00	AMZN	Stock	3.4105	3.4648	3.3935	3.4565	22934540.0
2009-03-16 13:00:00	AMZN	Stock	3.457	3.4595	3.404	3.4195	24336600.0
2009-03-16 14:00:00	AMZN	Stock	3.4195	3.433	3.3935	3.398	18084420.0
2009-03-16 15:00:00	AMZN	Stock	3.3975	3.4045	3.3375	3.3485	36679540.0

> showing 50 of 39,911 rows — these rows as CSV

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