PREVIEW / stock_1hour / 2008-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-11.parquet
  size:    783 KB
  rows:    39,833
  symbols: 3,284

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
2008-11-11 07:00:00	AAPL	Stock	3.3646	3.3818	3.3643	3.3732	59472.0
2008-11-11 08:00:00	AAPL	Stock	3.375	3.3818	3.3632	3.3714	1804572.0
2008-11-11 09:00:00	AAPL	Stock	3.3689	3.4121	3.295	3.3079	154921424.0
2008-11-11 10:00:00	AAPL	Stock	3.3071	3.3439	3.2979	3.3129	190427216.0
2008-11-11 11:00:00	AAPL	Stock	3.3125	3.3321	3.3036	3.3229	118705748.0
2008-11-11 12:00:00	AAPL	Stock	3.3221	3.3382	3.2982	3.3379	93978024.0
2008-11-11 13:00:00	AAPL	Stock	3.3382	3.3736	3.3043	3.3671	128989112.0
2008-11-11 14:00:00	AAPL	Stock	3.3671	3.4704	3.3493	3.3868	267417640.0
2008-11-11 15:00:00	AAPL	Stock	3.3864	3.4575	3.3511	3.3846	235785760.0
2008-11-11 16:00:00	AAPL	Stock	3.3846	3.3929	3.3597	3.3821	18326000.0
2008-11-11 17:00:00	AAPL	Stock	3.3864	3.3896	3.3821	3.3825	690340.0
2008-11-11 18:00:00	AAPL	Stock	3.3825	3.3921	3.3289	3.3921	459760.0
2008-11-11 19:00:00	AAPL	Stock	3.3921	3.3986	3.3886	3.3964	179060.0
2008-11-11 07:00:00	MSFT	Stock	21.31	21.31	21.22	21.22	993.0
2008-11-11 08:00:00	MSFT	Stock	21.16	21.22	21.15	21.2	35960.0
2008-11-11 09:00:00	MSFT	Stock	21.18	21.32	20.87	20.89	8875911.0
2008-11-11 10:00:00	MSFT	Stock	20.89	21.26	20.86	21.06	12408648.0
2008-11-11 11:00:00	MSFT	Stock	21.06	21.09	20.87	20.88	6958379.0
2008-11-11 12:00:00	MSFT	Stock	20.88	20.98	20.84	20.92	6445962.0
2008-11-11 13:00:00	MSFT	Stock	20.93	21.0	20.79	20.97	8833244.0
2008-11-11 14:00:00	MSFT	Stock	20.97	21.29	20.9	20.92	14036396.0
2008-11-11 15:00:00	MSFT	Stock	20.92	21.19	20.8	21.19	16552998.0
2008-11-11 16:00:00	MSFT	Stock	21.19	21.2	20.885	21.13	2465538.0
2008-11-11 17:00:00	MSFT	Stock	21.12	21.2	21.1	21.1	14156.0
2008-11-11 18:00:00	MSFT	Stock	21.11	21.11	21.02	21.1	10224.0
2008-11-11 19:00:00	MSFT	Stock	21.11	21.15	21.1	21.14	15160.0
2008-11-11 08:00:00	NVDA	Stock	0.2038	0.204	0.1992	0.1995	450400.0
2008-11-11 09:00:00	NVDA	Stock	0.1995	0.2025	0.1982	0.1995	58700440.0
2008-11-11 10:00:00	NVDA	Stock	0.1995	0.2023	0.1992	0.2005	73089840.0
2008-11-11 11:00:00	NVDA	Stock	0.2005	0.201	0.1952	0.1959	71555960.0
2008-11-11 12:00:00	NVDA	Stock	0.1958	0.2007	0.1929	0.194	68255880.0
2008-11-11 13:00:00	NVDA	Stock	0.194	0.1972	0.1934	0.1971	67236400.0
2008-11-11 14:00:00	NVDA	Stock	0.1972	0.1995	0.195	0.1955	115300440.0
2008-11-11 15:00:00	NVDA	Stock	0.1952	0.1975	0.193	0.195	108302840.0
2008-11-11 16:00:00	NVDA	Stock	0.195	0.197	0.1939	0.1958	11175160.0
2008-11-11 17:00:00	NVDA	Stock	0.1958	0.1958	0.195	0.1952	75920.0
2008-11-11 19:00:00	NVDA	Stock	0.1958	0.1968	0.1955	0.1968	92720.0
2008-11-11 08:00:00	AMZN	Stock	2.3995	2.4	2.3745	2.375	61000.0
2008-11-11 09:00:00	AMZN	Stock	2.37	2.375	2.2405	2.253	39309220.0
2008-11-11 10:00:00	AMZN	Stock	2.2525	2.3088	2.2435	2.291	34346220.0
2008-11-11 11:00:00	AMZN	Stock	2.2915	2.309	2.265	2.299	19543080.0
2008-11-11 12:00:00	AMZN	Stock	2.299	2.3205	2.284	2.3185	13729300.0
2008-11-11 13:00:00	AMZN	Stock	2.3185	2.3535	2.2858	2.3475	18757100.0
2008-11-11 14:00:00	AMZN	Stock	2.347	2.403	2.313	2.3385	36763500.0
2008-11-11 15:00:00	AMZN	Stock	2.3395	2.3655	2.2885	2.314	32427940.0
2008-11-11 16:00:00	AMZN	Stock	2.315	2.3245	2.309	2.31	1210520.0
2008-11-11 17:00:00	AMZN	Stock	2.3235	2.3235	2.315	2.315	5040.0
2008-11-11 18:00:00	AMZN	Stock	2.3345	2.335	2.3345	2.335	5400.0
2008-11-11 19:00:00	AMZN	Stock	2.3315	2.3315	2.315	2.325	26000.0
2008-11-11 09:00:00	TLT	Stock	95.16	95.5	95.13	95.36	104972.0

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

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