PREVIEW / stock_30min / 2006-07-20

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-07-20.parquet
  size:    912 KB
  rows:    49,686
  symbols: 2,302

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
2006-07-20 04:00:00	AAPL	Stock	2.1071	2.1071	2.1071	2.1071	14000.0
2006-07-20 04:30:00	AAPL	Stock	2.1214	2.1214	2.1214	2.1214	2800.0
2006-07-20 05:00:00	AAPL	Stock	2.1218	2.1218	2.1218	2.1218	28000.0
2006-07-20 05:30:00	AAPL	Stock	2.1164	2.1164	2.1071	2.1125	98000.0
2006-07-20 06:00:00	AAPL	Stock	2.125	2.125	2.1232	2.1232	42028.0
2006-07-20 06:30:00	AAPL	Stock	2.1232	2.1264	2.1229	2.1264	44772.0
2006-07-20 07:00:00	AAPL	Stock	2.1232	2.1389	2.1179	2.135	396508.0
2006-07-20 07:30:00	AAPL	Stock	2.1339	2.1482	2.1304	2.1439	2083144.0
2006-07-20 08:00:00	AAPL	Stock	2.1436	2.1821	2.1275	2.1725	41906032.0
2006-07-20 08:30:00	AAPL	Stock	2.1732	2.185	2.1646	2.1757	27702052.0
2006-07-20 09:00:00	AAPL	Stock	2.1757	2.1875	2.1679	2.1771	34406176.0
2006-07-20 09:30:00	AAPL	Stock	2.1771	2.1846	2.1443	2.1475	436023476.0
2006-07-20 10:00:00	AAPL	Stock	2.1475	2.1693	2.1329	2.1539	237760824.0
2006-07-20 10:30:00	AAPL	Stock	2.1539	2.1825	2.1482	2.1768	174125756.0
2006-07-20 11:00:00	AAPL	Stock	2.1775	2.1832	2.1618	2.165	135440760.0
2006-07-20 11:30:00	AAPL	Stock	2.165	2.1746	2.1636	2.1675	89492620.0
2006-07-20 12:00:00	AAPL	Stock	2.1671	2.1689	2.1579	2.1629	54262012.0
2006-07-20 12:30:00	AAPL	Stock	2.1625	2.1996	2.1596	2.1868	97433868.0
2006-07-20 13:00:00	AAPL	Stock	2.1868	2.1929	2.1814	2.1868	88040680.0
2006-07-20 13:30:00	AAPL	Stock	2.1864	2.1889	2.1614	2.1714	101123176.0
2006-07-20 14:00:00	AAPL	Stock	2.1711	2.1818	2.1679	2.1736	101959116.0
2006-07-20 14:30:00	AAPL	Stock	2.1736	2.1821	2.1657	2.1768	81072936.0
2006-07-20 15:00:00	AAPL	Stock	2.1768	2.1814	2.1668	2.1718	84516012.0
2006-07-20 15:30:00	AAPL	Stock	2.1718	2.1771	2.1596	2.1618	161059836.0
2006-07-20 16:00:00	AAPL	Stock	2.1618	2.1732	2.1586	2.1682	5666556.0
2006-07-20 16:30:00	AAPL	Stock	2.1679	2.1729	2.1679	2.1721	1053696.0
2006-07-20 17:00:00	AAPL	Stock	2.1696	2.1754	2.1696	2.1754	909636.0
2006-07-20 17:30:00	AAPL	Stock	2.1729	2.175	2.1679	2.1679	746424.0
2006-07-20 18:00:00	AAPL	Stock	2.1696	2.1714	2.1679	2.1714	194320.0
2006-07-20 08:00:00	MSFT	Stock	23.49	23.54	23.45	23.5	14988.0
2006-07-20 08:30:00	MSFT	Stock	23.5	23.5	23.4	23.49	34810.0
2006-07-20 09:00:00	MSFT	Stock	23.44	23.5	23.37	23.43	205253.0
2006-07-20 09:30:00	MSFT	Stock	23.43	23.45	22.97	22.99	7220095.0
2006-07-20 10:00:00	MSFT	Stock	22.99	23.04	22.84	22.98	7646455.0
2006-07-20 10:30:00	MSFT	Stock	22.98	23.01	22.88	23.0	3879742.0
2006-07-20 11:00:00	MSFT	Stock	22.99	23.069	22.87	23.01	2809100.0
2006-07-20 11:30:00	MSFT	Stock	23.01	23.1	22.99	23.07	2532018.0
2006-07-20 12:00:00	MSFT	Stock	23.079	23.09	22.96	23.0	2698839.0
2006-07-20 12:30:00	MSFT	Stock	23.0	23.08	22.94	22.99	2475100.0
2006-07-20 13:00:00	MSFT	Stock	22.99	23.01	22.9	22.92	2986399.0
2006-07-20 13:30:00	MSFT	Stock	22.91	23.0	22.89	22.99	3276299.0
2006-07-20 14:00:00	MSFT	Stock	22.99	23.04	22.91	22.93	4015762.0
2006-07-20 14:30:00	MSFT	Stock	22.93	23.0	22.9	22.9	2645813.0
2006-07-20 15:00:00	MSFT	Stock	22.9	23.01	22.88	22.93	4584314.0
2006-07-20 15:30:00	MSFT	Stock	22.94	23.09	22.78	22.86	12005744.0
2006-07-20 16:00:00	MSFT	Stock	22.88	24.62	22.6	24.25	8062377.0
2006-07-20 16:30:00	MSFT	Stock	24.25	24.5	24.02	24.2	3695140.0
2006-07-20 17:00:00	MSFT	Stock	24.2	24.26	24.15	24.25	2931788.0
2006-07-20 17:30:00	MSFT	Stock	24.25	24.26	24.15	24.2	1000878.0
2006-07-20 18:00:00	MSFT	Stock	24.2	24.2	24.1	24.11	118675.0

> showing 50 of 49,686 rows — these rows as CSV

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