PREVIEW / stock_1hour / 2005-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-20.parquet
  size:    566 KB
  rows:    26,643
  symbols: 2,091

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
2005-10-20 08:00:00	AAPL	Stock	1.9464	1.9596	1.9464	1.9554	1007580.0
2005-10-20 09:00:00	AAPL	Stock	1.9557	1.9986	1.9411	1.9768	242568396.0
2005-10-20 10:00:00	AAPL	Stock	1.9768	1.9957	1.9496	1.9889	248023664.0
2005-10-20 11:00:00	AAPL	Stock	1.9889	1.9939	1.9721	1.9925	124950868.0
2005-10-20 12:00:00	AAPL	Stock	1.9925	2.0136	1.9861	1.9968	193546108.0
2005-10-20 13:00:00	AAPL	Stock	1.9964	2.0089	1.9943	2.0068	92154748.0
2005-10-20 14:00:00	AAPL	Stock	2.0068	2.0179	1.9943	1.9998	166210996.0
2005-10-20 15:00:00	AAPL	Stock	1.9996	2.0082	1.9764	2.0029	264108572.0
2005-10-20 16:00:00	AAPL	Stock	2.0054	2.0229	1.9654	2.0161	6336960.0
2005-10-20 17:00:00	AAPL	Stock	2.0179	2.0271	2.0054	2.025	3366664.0
2005-10-20 18:00:00	AAPL	Stock	2.025	2.0289	2.025	2.025	589960.0
2005-10-20 08:00:00	MSFT	Stock	25.1	25.1	24.98	25.03	27090.0
2005-10-20 09:00:00	MSFT	Stock	25.03	25.13	24.97	25.03	5213375.0
2005-10-20 10:00:00	MSFT	Stock	25.03	25.09	24.93	24.95	8564292.0
2005-10-20 11:00:00	MSFT	Stock	24.95	25.0	24.93	24.97	6767089.0
2005-10-20 12:00:00	MSFT	Stock	24.96	25.04	24.92	24.93	5910358.0
2005-10-20 13:00:00	MSFT	Stock	24.94	24.96	24.87	24.91	6059373.0
2005-10-20 14:00:00	MSFT	Stock	24.91	24.91	24.81	24.88	6644788.0
2005-10-20 15:00:00	MSFT	Stock	24.88	24.91	24.74	24.79	15350380.0
2005-10-20 16:00:00	MSFT	Stock	24.79	24.99	24.78	24.8	493613.0
2005-10-20 17:00:00	MSFT	Stock	24.79	25.07	24.79	24.8	868886.0
2005-10-20 18:00:00	MSFT	Stock	24.82	24.82	24.81	24.81	15400.0
2005-10-20 09:00:00	NVDA	Stock	0.2632	0.2685	0.2621	0.2654	39932520.0
2005-10-20 10:00:00	NVDA	Stock	0.2652	0.2687	0.2639	0.2676	66637800.0
2005-10-20 11:00:00	NVDA	Stock	0.2677	0.2683	0.2662	0.2681	33888720.0
2005-10-20 12:00:00	NVDA	Stock	0.2681	0.2687	0.2669	0.2684	28418880.0
2005-10-20 13:00:00	NVDA	Stock	0.2684	0.2702	0.2683	0.2689	38874840.0
2005-10-20 14:00:00	NVDA	Stock	0.2689	0.2691	0.2667	0.2667	33171960.0
2005-10-20 15:00:00	NVDA	Stock	0.2667	0.2673	0.2635	0.2647	106965720.0
2005-10-20 16:00:00	NVDA	Stock	0.2646	0.2657	0.2646	0.2652	1218960.0
2005-10-20 17:00:00	NVDA	Stock	0.2647	0.2647	0.2647	0.2647	1873920.0
2005-10-20 08:00:00	AMZN	Stock	2.2745	2.275	2.2745	2.275	10000.0
2005-10-20 09:00:00	AMZN	Stock	2.275	2.3035	2.275	2.2845	17878660.0
2005-10-20 10:00:00	AMZN	Stock	2.284	2.2875	2.268	2.2825	15137600.0
2005-10-20 11:00:00	AMZN	Stock	2.283	2.2895	2.273	2.274	10901840.0
2005-10-20 12:00:00	AMZN	Stock	2.2745	2.284	2.2575	2.2749	11369020.0
2005-10-20 13:00:00	AMZN	Stock	2.274	2.291	2.271	2.276	9854060.0
2005-10-20 14:00:00	AMZN	Stock	2.2745	2.2805	2.261	2.2655	19951900.0
2005-10-20 15:00:00	AMZN	Stock	2.2655	2.2725	2.234	2.2505	28276800.0
2005-10-20 16:00:00	AMZN	Stock	2.2505	2.2845	2.2495	2.2815	1192200.0
2005-10-20 17:00:00	AMZN	Stock	2.275	2.285	2.27	2.2825	145160.0
2005-10-20 18:00:00	AMZN	Stock	2.2825	2.2825	2.28	2.28	4000.0
2005-10-20 09:00:00	CL	Stock	26.31	26.445	26.24	26.295	204800.0
2005-10-20 10:00:00	CL	Stock	26.3	26.38	26.15	26.275	318400.0
2005-10-20 11:00:00	CL	Stock	26.28	26.365	26.19	26.29	242800.0
2005-10-20 12:00:00	CL	Stock	26.305	26.35	26.23	26.335	271200.0
2005-10-20 13:00:00	CL	Stock	26.325	26.36	26.165	26.255	244000.0
2005-10-20 14:00:00	CL	Stock	26.245	26.27	26.125	26.22	261800.0
2005-10-20 15:00:00	CL	Stock	26.215	26.26	26.005	26.06	786000.0
2005-10-20 16:00:00	CL	Stock	26.055	26.055	26.055	26.055	800.0

> showing 50 of 26,643 rows — these rows as CSV

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