PREVIEW / stock_1hour / 2007-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-17.parquet
  size:    790 KB
  rows:    39,238
  symbols: 3,145

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
2007-08-17 09:00:00	AAPL	Stock	4.3575	4.3964	4.2936	4.3068	245111440.0
2007-08-17 10:00:00	AAPL	Stock	4.3068	4.3389	4.2793	4.3029	221172392.0
2007-08-17 11:00:00	AAPL	Stock	4.3039	4.3389	4.2886	4.3229	113979572.0
2007-08-17 12:00:00	AAPL	Stock	4.3236	4.3357	4.3143	4.3204	71135904.0
2007-08-17 13:00:00	AAPL	Stock	4.3214	4.3725	4.3207	4.3371	109333532.0
2007-08-17 14:00:00	AAPL	Stock	4.3364	4.3657	4.3214	4.365	95884236.0
2007-08-17 15:00:00	AAPL	Stock	4.365	4.4107	4.3571	4.3593	226246552.0
2007-08-17 16:00:00	AAPL	Stock	4.3643	4.3643	4.3593	4.3593	15547728.0
2007-08-17 09:00:00	MSFT	Stock	28.09	28.2	27.86	27.94	12035278.0
2007-08-17 10:00:00	MSFT	Stock	27.94	28.05	27.82	27.97	9932322.0
2007-08-17 11:00:00	MSFT	Stock	27.98	28.19	27.84	27.993	6916454.0
2007-08-17 12:00:00	MSFT	Stock	27.992	28.05	27.85	27.985	5479830.0
2007-08-17 13:00:00	MSFT	Stock	27.98	28.24	27.98	28.041	6343435.0
2007-08-17 14:00:00	MSFT	Stock	28.04	28.04	27.83	27.86	7653296.0
2007-08-17 15:00:00	MSFT	Stock	27.85	28.25	27.83	28.25	16069289.0
2007-08-17 16:00:00	MSFT	Stock	28.23	28.25	28.23	28.25	2654735.0
2007-08-17 07:00:00	NVDA	Stock	0.7083	0.7083	0.7042	0.7042	18000.0
2007-08-17 08:00:00	NVDA	Stock	0.7008	0.734	0.7008	0.7333	3162720.0
2007-08-17 09:00:00	NVDA	Stock	0.734	0.7383	0.7065	0.716	118787820.0
2007-08-17 10:00:00	NVDA	Stock	0.7155	0.7227	0.7085	0.7173	105738180.0
2007-08-17 11:00:00	NVDA	Stock	0.7173	0.7247	0.7141	0.7207	77623020.0
2007-08-17 12:00:00	NVDA	Stock	0.7207	0.7302	0.7185	0.7248	58519140.0
2007-08-17 13:00:00	NVDA	Stock	0.7248	0.7323	0.7245	0.7305	55818780.0
2007-08-17 14:00:00	NVDA	Stock	0.7307	0.7395	0.7273	0.7387	82807620.0
2007-08-17 15:00:00	NVDA	Stock	0.7387	0.752	0.7363	0.7507	192290160.0
2007-08-17 16:00:00	NVDA	Stock	0.7513	0.7513	0.7478	0.7503	15385260.0
2007-08-17 17:00:00	NVDA	Stock	0.749	0.749	0.7488	0.7488	45000.0
2007-08-17 18:00:00	NVDA	Stock	0.7513	0.7513	0.7513	0.7513	66000.0
2007-08-17 19:00:00	NVDA	Stock	0.7498	0.7498	0.7498	0.7498	12000.0
2007-08-17 06:00:00	AMZN	Stock	3.613	3.613	3.613	3.613	2000.0
2007-08-17 08:00:00	AMZN	Stock	3.633	3.7945	3.625	3.74	1150200.0
2007-08-17 09:00:00	AMZN	Stock	3.74	3.75	3.6975	3.7005	32445720.0
2007-08-17 10:00:00	AMZN	Stock	3.699	3.7205	3.6555	3.6855	26829340.0
2007-08-17 11:00:00	AMZN	Stock	3.6835	3.7425	3.6825	3.7265	17080660.0
2007-08-17 12:00:00	AMZN	Stock	3.725	3.732	3.6955	3.702	10561780.0
2007-08-17 13:00:00	AMZN	Stock	3.702	3.7395	3.6975	3.7235	8698720.0
2007-08-17 14:00:00	AMZN	Stock	3.723	3.7325	3.704	3.715	10191340.0
2007-08-17 15:00:00	AMZN	Stock	3.714	3.752	3.711	3.751	26072320.0
2007-08-17 16:00:00	AMZN	Stock	3.7495	3.7525	3.743	3.7505	8033180.0
2007-08-17 17:00:00	AMZN	Stock	3.7535	3.7585	3.7375	3.75	632740.0
2007-08-17 18:00:00	AMZN	Stock	3.7495	3.755	3.7495	3.7535	14000.0
2007-08-17 19:00:00	AMZN	Stock	3.7535	3.7575	3.75	3.75	48700.0
2007-08-17 09:00:00	TLT	Stock	86.4	86.65	86.27	86.55	209800.0
2007-08-17 10:00:00	TLT	Stock	86.56	86.83	86.05	86.81	539100.0
2007-08-17 11:00:00	TLT	Stock	86.84	86.89	86.74	86.87	253600.0
2007-08-17 12:00:00	TLT	Stock	86.88	86.91	86.7	86.75	74800.0
2007-08-17 13:00:00	TLT	Stock	86.77	86.8	86.63	86.73	72600.0
2007-08-17 14:00:00	TLT	Stock	86.69	86.77	86.59	86.62	150900.0
2007-08-17 15:00:00	TLT	Stock	86.66	86.82	86.61	86.77	628400.0
2007-08-17 16:00:00	TLT	Stock	86.78	86.79	86.77	86.79	11900.0

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

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