PREVIEW / stock_1hour / 2008-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-30.parquet
  size:    819 KB
  rows:    41,957
  symbols: 3,338

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-10-30 04:00:00	AAPL	Stock	3.8214	3.8214	3.8214	3.8214	2800.0
2008-10-30 06:00:00	AAPL	Stock	3.8564	3.8571	3.8564	3.8571	25200.0
2008-10-30 07:00:00	AAPL	Stock	3.8571	3.875	3.8286	3.8571	487788.0
2008-10-30 08:00:00	AAPL	Stock	3.8571	3.8729	3.8318	3.8496	5457676.0
2008-10-30 09:00:00	AAPL	Stock	3.85	3.9357	3.8432	3.9093	209378652.0
2008-10-30 10:00:00	AAPL	Stock	3.91	3.9432	3.8693	3.8986	309694280.0
2008-10-30 11:00:00	AAPL	Stock	3.8993	3.9464	3.8804	3.8954	217204316.0
2008-10-30 12:00:00	AAPL	Stock	3.8957	3.9571	3.8929	3.9186	191091152.0
2008-10-30 13:00:00	AAPL	Stock	3.9189	3.9893	3.9107	3.9786	169696520.0
2008-10-30 14:00:00	AAPL	Stock	3.9789	4.0068	3.9693	3.9871	210689080.0
2008-10-30 15:00:00	AAPL	Stock	3.9871	4.0043	3.9114	3.9661	302541232.0
2008-10-30 16:00:00	AAPL	Stock	3.9707	3.9875	3.7543	3.9736	14746816.0
2008-10-30 17:00:00	AAPL	Stock	3.9746	3.9821	3.9657	3.9821	1052408.0
2008-10-30 18:00:00	AAPL	Stock	3.9786	3.9875	3.9657	3.9786	690928.0
2008-10-30 19:00:00	AAPL	Stock	3.9775	3.9786	3.9639	3.9639	512456.0
2008-10-30 07:00:00	MSFT	Stock	23.6	23.6	23.5	23.5	1100.0
2008-10-30 08:00:00	MSFT	Stock	23.57	23.69	23.47	23.68	51316.0
2008-10-30 09:00:00	MSFT	Stock	23.68	23.88	23.55	23.64	8682792.0
2008-10-30 10:00:00	MSFT	Stock	23.63	23.75	23.08	23.17	12340562.0
2008-10-30 11:00:00	MSFT	Stock	23.16	23.42	22.69	22.848	12098524.0
2008-10-30 12:00:00	MSFT	Stock	22.84	23.08	22.8	22.95	7295362.0
2008-10-30 13:00:00	MSFT	Stock	22.958	23.26	22.9	23.08	8438504.0
2008-10-30 14:00:00	MSFT	Stock	23.08	23.33	23.05	23.19	10406808.0
2008-10-30 15:00:00	MSFT	Stock	23.19	23.41	22.39	22.63	30055008.0
2008-10-30 16:00:00	MSFT	Stock	22.68	23.715	22.629	22.75	3651802.0
2008-10-30 17:00:00	MSFT	Stock	22.63	22.81	22.63	22.79	115229.0
2008-10-30 18:00:00	MSFT	Stock	22.63	22.84	22.63	22.84	48471.0
2008-10-30 19:00:00	MSFT	Stock	22.84	22.85	22.76	22.8	6275.0
2008-10-30 08:00:00	NVDA	Stock	0.213	0.221	0.213	0.2183	578320.0
2008-10-30 09:00:00	NVDA	Stock	0.2175	0.22	0.2105	0.2112	74198160.0
2008-10-30 10:00:00	NVDA	Stock	0.2112	0.2118	0.2025	0.206	118392520.0
2008-10-30 11:00:00	NVDA	Stock	0.206	0.2163	0.2027	0.2064	100774480.0
2008-10-30 12:00:00	NVDA	Stock	0.2062	0.211	0.205	0.2072	73648600.0
2008-10-30 13:00:00	NVDA	Stock	0.2072	0.214	0.207	0.214	60994840.0
2008-10-30 14:00:00	NVDA	Stock	0.214	0.2175	0.2138	0.2152	63343560.0
2008-10-30 15:00:00	NVDA	Stock	0.2152	0.2168	0.2108	0.2158	153690040.0
2008-10-30 16:00:00	NVDA	Stock	0.2158	0.2175	0.2078	0.2168	1523840.0
2008-10-30 17:00:00	NVDA	Stock	0.2158	0.2163	0.2158	0.2163	381960.0
2008-10-30 18:00:00	NVDA	Stock	0.2158	0.2165	0.2158	0.2165	125960.0
2008-10-30 19:00:00	NVDA	Stock	0.215	0.215	0.215	0.215	65360.0
2008-10-30 04:00:00	AMZN	Stock	2.865	2.865	2.865	2.865	6000.0
2008-10-30 08:00:00	AMZN	Stock	2.906	2.94	2.905	2.9125	477560.0
2008-10-30 09:00:00	AMZN	Stock	2.9195	2.9945	2.9195	2.949	36160180.0
2008-10-30 10:00:00	AMZN	Stock	2.948	2.958	2.865	2.8755	30077280.0
2008-10-30 11:00:00	AMZN	Stock	2.876	2.9131	2.767	2.775	37221080.0
2008-10-30 12:00:00	AMZN	Stock	2.776	2.8355	2.7745	2.809	23029520.0
2008-10-30 13:00:00	AMZN	Stock	2.8085	2.8485	2.7975	2.821	17800260.0
2008-10-30 14:00:00	AMZN	Stock	2.8195	2.8715	2.8145	2.835	20828740.0
2008-10-30 15:00:00	AMZN	Stock	2.837	2.865	2.754	2.8285	52469800.0
2008-10-30 16:00:00	AMZN	Stock	2.8355	2.8536	2.8165	2.825	3410580.0

> showing 50 of 41,957 rows — these rows as CSV

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