PREVIEW / stock_1hour / 2005-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-08.parquet
  size:    544 KB
  rows:    25,437
  symbols: 1,933

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-02-08 08:00:00	AAPL	Stock	1.4096	1.4096	1.407	1.407	242200.0
2005-02-08 09:00:00	AAPL	Stock	1.407	1.4284	1.3893	1.428	110599384.0
2005-02-08 10:00:00	AAPL	Stock	1.428	1.4455	1.4241	1.4423	240768360.0
2005-02-08 11:00:00	AAPL	Stock	1.4423	1.4532	1.4396	1.4413	164397912.0
2005-02-08 12:00:00	AAPL	Stock	1.4411	1.4464	1.4354	1.4414	99610112.0
2005-02-08 13:00:00	AAPL	Stock	1.4414	1.4482	1.4368	1.4416	85292088.0
2005-02-08 14:00:00	AAPL	Stock	1.4414	1.4455	1.438	1.4411	80840368.0
2005-02-08 15:00:00	AAPL	Stock	1.4414	1.4448	1.4371	1.4445	96629960.0
2005-02-08 16:00:00	AAPL	Stock	1.4446	1.4446	1.4343	1.4421	3412584.0
2005-02-08 17:00:00	AAPL	Stock	1.4423	1.4432	1.4421	1.4429	294168.0
2005-02-08 18:00:00	AAPL	Stock	1.4443	1.4448	1.4429	1.4448	150360.0
2005-02-08 08:00:00	MSFT	Stock	26.18	26.19	26.15	26.17	25595.0
2005-02-08 09:00:00	MSFT	Stock	26.16	26.24	26.11	26.21	7601498.0
2005-02-08 10:00:00	MSFT	Stock	26.21	26.3	26.17	26.22	9000366.0
2005-02-08 11:00:00	MSFT	Stock	26.22	26.3	26.2	26.28	7420800.0
2005-02-08 12:00:00	MSFT	Stock	26.28	26.28	26.16	26.22	5934166.0
2005-02-08 13:00:00	MSFT	Stock	26.22	26.34	26.17	26.27	6800166.0
2005-02-08 14:00:00	MSFT	Stock	26.27	26.31	26.23	26.28	8467244.0
2005-02-08 15:00:00	MSFT	Stock	26.28	26.31	26.23	26.24	11133659.0
2005-02-08 16:00:00	MSFT	Stock	26.24	26.26	26.11	26.23	2245104.0
2005-02-08 17:00:00	MSFT	Stock	26.23	26.252	26.21	26.24	77819.0
2005-02-08 18:00:00	MSFT	Stock	26.25	26.26	26.24	26.25	6700.0
2005-02-08 08:00:00	NVDA	Stock	0.2115	0.2115	0.2115	0.2115	240000.0
2005-02-08 09:00:00	NVDA	Stock	0.2121	0.2149	0.2103	0.2143	62620680.0
2005-02-08 10:00:00	NVDA	Stock	0.2145	0.2178	0.2143	0.2156	119160000.0
2005-02-08 11:00:00	NVDA	Stock	0.2157	0.2167	0.2139	0.2154	79100760.0
2005-02-08 12:00:00	NVDA	Stock	0.2153	0.2156	0.214	0.2143	61542000.0
2005-02-08 13:00:00	NVDA	Stock	0.2144	0.216	0.2142	0.215	29197320.0
2005-02-08 14:00:00	NVDA	Stock	0.215	0.2156	0.2142	0.2147	23469360.0
2005-02-08 15:00:00	NVDA	Stock	0.2148	0.215	0.2137	0.2143	62628480.0
2005-02-08 16:00:00	NVDA	Stock	0.2142	0.2146	0.2142	0.2144	6581040.0
2005-02-08 17:00:00	NVDA	Stock	0.2126	0.2129	0.2125	0.2125	120000.0
2005-02-08 08:00:00	AMZN	Stock	1.785	1.785	1.77	1.77	172740.0
2005-02-08 09:00:00	AMZN	Stock	1.7665	1.81	1.7665	1.808	25423180.0
2005-02-08 10:00:00	AMZN	Stock	1.808	1.816	1.8005	1.816	45548420.0
2005-02-08 11:00:00	AMZN	Stock	1.8145	1.8246	1.8145	1.82	36250760.0
2005-02-08 12:00:00	AMZN	Stock	1.8205	1.8205	1.8095	1.815	19390980.0
2005-02-08 13:00:00	AMZN	Stock	1.8145	1.821	1.8125	1.8185	10271820.0
2005-02-08 14:00:00	AMZN	Stock	1.819	1.824	1.818	1.8235	17378300.0
2005-02-08 15:00:00	AMZN	Stock	1.8235	1.826	1.8095	1.815	35244060.0
2005-02-08 16:00:00	AMZN	Stock	1.815	1.8175	1.813	1.8175	600480.0
2005-02-08 17:00:00	AMZN	Stock	1.8175	1.82	1.816	1.816	54400.0
2005-02-08 18:00:00	AMZN	Stock	1.816	1.8235	1.816	1.8235	18000.0
2005-02-08 09:00:00	CL	Stock	27.59	27.625	27.55	27.595	1011600.0
2005-02-08 10:00:00	CL	Stock	27.595	27.65	27.52	27.575	1048400.0
2005-02-08 11:00:00	CL	Stock	27.57	27.57	27.43	27.43	513600.0
2005-02-08 12:00:00	CL	Stock	27.43	27.44	27.335	27.41	484600.0
2005-02-08 13:00:00	CL	Stock	27.45	27.45	27.385	27.385	587600.0
2005-02-08 14:00:00	CL	Stock	27.38	27.47	27.38	27.435	763400.0
2005-02-08 15:00:00	CL	Stock	27.43	27.49	27.425	27.455	1140800.0

> showing 50 of 25,437 rows — these rows as CSV

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