PREVIEW / stock_1hour / 2009-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-06.parquet
  size:    840 KB
  rows:    40,851
  symbols: 3,341

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-07-06 08:00:00	AAPL	Stock	4.9679	4.9814	4.9375	4.9536	1352736.0
2009-07-06 09:00:00	AAPL	Stock	4.9536	4.9739	4.875	4.8771	111471304.0
2009-07-06 10:00:00	AAPL	Stock	4.8775	4.9064	4.8661	4.9057	117998216.0
2009-07-06 11:00:00	AAPL	Stock	4.9057	4.9143	4.8864	4.8889	45250660.0
2009-07-06 12:00:00	AAPL	Stock	4.8886	4.9032	4.8718	4.8782	39202184.0
2009-07-06 13:00:00	AAPL	Stock	4.8778	4.9064	4.8736	4.895	40123216.0
2009-07-06 14:00:00	AAPL	Stock	4.8954	4.9307	4.8914	4.9243	49712544.0
2009-07-06 15:00:00	AAPL	Stock	4.9243	4.9593	4.9154	4.9504	79992388.0
2009-07-06 16:00:00	AAPL	Stock	4.9504	4.9821	4.9007	4.9679	9630908.0
2009-07-06 17:00:00	AAPL	Stock	4.9504	4.9786	4.9504	4.9729	194852.0
2009-07-06 18:00:00	AAPL	Stock	4.9732	4.9764	4.9504	4.9764	630868.0
2009-07-06 19:00:00	AAPL	Stock	4.9721	4.9721	4.965	4.9689	86828.0
2009-07-06 20:00:00	AAPL	Stock	4.8939	4.8939	4.8939	4.8939	162400.0
2009-07-06 07:00:00	MSFT	Stock	23.11	23.24	23.11	23.24	652.0
2009-07-06 08:00:00	MSFT	Stock	23.22	23.28	23.11	23.23	25087.0
2009-07-06 09:00:00	MSFT	Stock	23.23	23.28	23.0	23.15	6587430.0
2009-07-06 10:00:00	MSFT	Stock	23.155	23.23	22.87	23.03	9729312.0
2009-07-06 11:00:00	MSFT	Stock	23.02	23.07	22.95	22.97	4910570.0
2009-07-06 12:00:00	MSFT	Stock	22.96	23.05	22.92	23.01	4684738.0
2009-07-06 13:00:00	MSFT	Stock	23.01	23.11	23.01	23.07	4909275.0
2009-07-06 14:00:00	MSFT	Stock	23.07	23.2	23.06	23.2	5683795.0
2009-07-06 15:00:00	MSFT	Stock	23.2	23.25	23.05	23.2	9751673.0
2009-07-06 16:00:00	MSFT	Stock	23.2	23.23	23.078	23.17	1597450.0
2009-07-06 17:00:00	MSFT	Stock	23.2	23.22	23.18	23.22	12385.0
2009-07-06 18:00:00	MSFT	Stock	23.22	23.22	23.18	23.2	6225.0
2009-07-06 19:00:00	MSFT	Stock	23.2	23.2	23.18	23.2	1826.0
2009-07-06 20:00:00	MSFT	Stock	23.02	23.02	23.02	23.02	252312.0
2009-07-06 07:00:00	NVDA	Stock	0.2712	0.2712	0.2712	0.2712	30000.0
2009-07-06 08:00:00	NVDA	Stock	0.2668	0.275	0.2668	0.2675	402440.0
2009-07-06 09:00:00	NVDA	Stock	0.269	0.2725	0.2665	0.269	133500200.0
2009-07-06 10:00:00	NVDA	Stock	0.269	0.2704	0.2592	0.2618	150913840.0
2009-07-06 11:00:00	NVDA	Stock	0.2618	0.2632	0.2612	0.2615	62628080.0
2009-07-06 12:00:00	NVDA	Stock	0.2612	0.263	0.2603	0.2611	39363920.0
2009-07-06 13:00:00	NVDA	Stock	0.2612	0.264	0.2605	0.2618	76634720.0
2009-07-06 14:00:00	NVDA	Stock	0.2618	0.2628	0.2605	0.2612	82872240.0
2009-07-06 15:00:00	NVDA	Stock	0.261	0.264	0.261	0.2638	175081600.0
2009-07-06 16:00:00	NVDA	Stock	0.2635	0.2643	0.2624	0.2638	14018080.0
2009-07-06 17:00:00	NVDA	Stock	0.2638	0.2638	0.2638	0.2638	31040.0
2009-07-06 19:00:00	NVDA	Stock	0.2625	0.2625	0.2625	0.2625	4000.0
2009-07-06 20:00:00	NVDA	Stock	0.2605	0.2605	0.2605	0.2605	44640.0
2009-07-06 08:00:00	AMZN	Stock	3.95	3.95	3.915	3.915	203000.0
2009-07-06 09:00:00	AMZN	Stock	3.924	3.9445	3.8885	3.905	24775440.0
2009-07-06 10:00:00	AMZN	Stock	3.905	3.91	3.827	3.8492	31640600.0
2009-07-06 11:00:00	AMZN	Stock	3.849	3.876	3.8385	3.841	20620280.0
2009-07-06 12:00:00	AMZN	Stock	3.841	3.873	3.8375	3.868	11465660.0
2009-07-06 13:00:00	AMZN	Stock	3.868	3.894	3.8635	3.87	10964340.0
2009-07-06 14:00:00	AMZN	Stock	3.87	3.8995	3.866	3.892	14662560.0
2009-07-06 15:00:00	AMZN	Stock	3.892	3.9135	3.8855	3.903	29721580.0
2009-07-06 16:00:00	AMZN	Stock	3.9045	3.9325	3.8596	3.932	545940.0
2009-07-06 17:00:00	AMZN	Stock	3.924	3.9325	3.905	3.9235	37160.0

> showing 50 of 40,851 rows — these rows as CSV

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