PREVIEW / stock_1hour / 2002-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-07.parquet
  size:    405 KB
  rows:    19,598
  symbols: 1,505

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
2002-11-07 08:00:00	AAPL	Stock	0.3196	0.3196	0.3071	0.3071	67200.0
2002-11-07 09:00:00	AAPL	Stock	0.3064	0.3064	0.2959	0.2966	31713080.0
2002-11-07 10:00:00	AAPL	Stock	0.2964	0.2966	0.2877	0.2886	67075120.0
2002-11-07 11:00:00	AAPL	Stock	0.2884	0.2886	0.2839	0.2862	49967792.0
2002-11-07 12:00:00	AAPL	Stock	0.2863	0.2866	0.2843	0.2857	24569496.0
2002-11-07 13:00:00	AAPL	Stock	0.2855	0.2864	0.2827	0.2848	30378768.0
2002-11-07 14:00:00	AAPL	Stock	0.2852	0.2855	0.2823	0.2845	44457560.0
2002-11-07 15:00:00	AAPL	Stock	0.2845	0.2863	0.2823	0.2852	55055896.0
2002-11-07 16:00:00	AAPL	Stock	0.2857	0.288	0.2854	0.2861	6640648.0
2002-11-07 17:00:00	AAPL	Stock	0.2866	0.2866	0.2866	0.2866	16800.0
2002-11-07 18:00:00	AAPL	Stock	0.2861	0.2861	0.2861	0.2861	56000.0
2002-11-07 08:00:00	MSFT	Stock	28.15	28.495	28.1	28.495	184100.0
2002-11-07 09:00:00	MSFT	Stock	28.5	28.51	28.027	28.1675	9311688.0
2002-11-07 10:00:00	MSFT	Stock	28.175	28.295	27.9	27.92	16038966.0
2002-11-07 11:00:00	MSFT	Stock	27.92	28.0	27.833	27.915	9921486.0
2002-11-07 12:00:00	MSFT	Stock	27.915	27.965	27.78	27.885	6586970.0
2002-11-07 13:00:00	MSFT	Stock	27.885	28.045	27.78	27.99	4962498.0
2002-11-07 14:00:00	MSFT	Stock	27.99	28.095	27.865	27.89	7266340.0
2002-11-07 15:00:00	MSFT	Stock	27.89	28.06	27.76	28.005	11568718.0
2002-11-07 16:00:00	MSFT	Stock	28.005	28.08	27.87	28.04	2111082.0
2002-11-07 17:00:00	MSFT	Stock	28.02	28.02	27.9005	27.9005	26350.0
2002-11-07 18:00:00	MSFT	Stock	27.9255	27.9255	27.925	27.925	600.0
2002-11-07 08:00:00	NVDA	Stock	0.1308	0.1344	0.1292	0.13	3548040.0
2002-11-07 09:00:00	NVDA	Stock	0.13	0.134	0.1251	0.1283	241322880.0
2002-11-07 10:00:00	NVDA	Stock	0.1283	0.1304	0.1267	0.1271	245701200.0
2002-11-07 11:00:00	NVDA	Stock	0.1271	0.1272	0.1221	0.1225	260147760.0
2002-11-07 12:00:00	NVDA	Stock	0.1225	0.1252	0.1222	0.1251	134655000.0
2002-11-07 13:00:00	NVDA	Stock	0.1248	0.1267	0.1237	0.1257	81068520.0
2002-11-07 14:00:00	NVDA	Stock	0.1258	0.1263	0.1234	0.1239	101485080.0
2002-11-07 15:00:00	NVDA	Stock	0.1239	0.1246	0.1205	0.1212	290940720.0
2002-11-07 16:00:00	NVDA	Stock	0.1212	0.1235	0.1142	0.1164	144947880.0
2002-11-07 17:00:00	NVDA	Stock	0.1166	0.1215	0.1125	0.1138	82446480.0
2002-11-07 18:00:00	NVDA	Stock	0.114	0.1149	0.1129	0.1133	9954720.0
2002-11-07 08:00:00	AMZN	Stock	0.95	0.9575	0.9375	0.9415	544000.0
2002-11-07 09:00:00	AMZN	Stock	0.9444	0.955	0.94	0.9502	19767380.0
2002-11-07 10:00:00	AMZN	Stock	0.95	0.965	0.9495	0.9535	24666240.0
2002-11-07 11:00:00	AMZN	Stock	0.954	0.9555	0.951	0.9525	19098540.0
2002-11-07 12:00:00	AMZN	Stock	0.953	0.961	0.952	0.9548	8364240.0
2002-11-07 13:00:00	AMZN	Stock	0.9545	0.9575	0.9525	0.9555	6429360.0
2002-11-07 14:00:00	AMZN	Stock	0.955	0.9595	0.9525	0.9545	8843680.0
2002-11-07 15:00:00	AMZN	Stock	0.9545	0.9599	0.9495	0.956	23350760.0
2002-11-07 16:00:00	AMZN	Stock	0.956	0.9605	0.9505	0.9575	2259840.0
2002-11-07 17:00:00	AMZN	Stock	0.956	0.9625	0.953	0.953	807040.0
2002-11-07 18:00:00	AMZN	Stock	0.9595	0.9595	0.9595	0.9595	26000.0
2002-11-07 09:00:00	CL	Stock	26.7	26.8	26.65	26.655	390400.0
2002-11-07 10:00:00	CL	Stock	26.655	27.0	26.6	26.91	764000.0
2002-11-07 11:00:00	CL	Stock	26.905	26.985	26.84	26.9	487000.0
2002-11-07 12:00:00	CL	Stock	26.895	27.0	26.735	26.88	893000.0
2002-11-07 13:00:00	CL	Stock	26.875	27.025	26.855	26.91	418200.0
2002-11-07 14:00:00	CL	Stock	26.9	27.01	26.875	26.925	453000.0

> showing 50 of 19,598 rows — these rows as CSV

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