PREVIEW / stock_30min / 2010-02-22

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-22.parquet
  size:    1.3 MB
  rows:    72,264
  symbols: 3,472

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
2010-02-22 04:00:00	AAPL	Stock	7.21	7.21	7.21	7.21	3752.0
2010-02-22 07:00:00	AAPL	Stock	7.2021	7.225	7.2021	7.2143	73304.0
2010-02-22 07:30:00	AAPL	Stock	7.2171	7.2175	7.2171	7.2175	19600.0
2010-02-22 08:00:00	AAPL	Stock	7.2214	7.2364	7.2193	7.2293	767088.0
2010-02-22 08:30:00	AAPL	Stock	7.2268	7.2286	7.2193	7.2214	596680.0
2010-02-22 09:00:00	AAPL	Stock	7.2211	7.2321	7.2132	7.2279	1495816.0
2010-02-22 09:30:00	AAPL	Stock	7.2268	7.2321	7.1289	7.1511	86416400.0
2010-02-22 10:00:00	AAPL	Stock	7.1511	7.1539	7.1304	7.1425	46919600.0
2010-02-22 10:30:00	AAPL	Stock	7.1425	7.1664	7.1354	7.1443	30620576.0
2010-02-22 11:00:00	AAPL	Stock	7.1439	7.1482	7.125	7.1393	22323336.0
2010-02-22 11:30:00	AAPL	Stock	7.1388	7.1418	7.1171	7.125	23006536.0
2010-02-22 12:00:00	AAPL	Stock	7.125	7.1296	7.1139	7.1257	14394380.0
2010-02-22 12:30:00	AAPL	Stock	7.1268	7.1464	7.1246	7.1432	14307916.0
2010-02-22 13:00:00	AAPL	Stock	7.1436	7.1607	7.1382	7.1539	16251900.0
2010-02-22 13:30:00	AAPL	Stock	7.1539	7.1693	7.1489	7.1625	21764120.0
2010-02-22 14:00:00	AAPL	Stock	7.1629	7.1682	7.1521	7.1614	13833232.0
2010-02-22 14:30:00	AAPL	Stock	7.162	7.1825	7.1607	7.1789	21702380.0
2010-02-22 15:00:00	AAPL	Stock	7.1796	7.1964	7.1696	7.1718	22924496.0
2010-02-22 15:30:00	AAPL	Stock	7.1721	7.1757	7.1457	7.1586	43323336.0
2010-02-22 16:00:00	AAPL	Stock	7.1557	7.1821	7.1539	7.1546	4869200.0
2010-02-22 16:30:00	AAPL	Stock	7.1714	7.1714	7.155	7.1589	54320.0
2010-02-22 17:00:00	AAPL	Stock	7.1571	7.1579	7.1571	7.1579	61600.0
2010-02-22 17:30:00	AAPL	Stock	7.1579	7.1579	7.1546	7.1575	55216.0
2010-02-22 18:00:00	AAPL	Stock	7.1589	7.1589	7.1571	7.1571	101836.0
2010-02-22 18:30:00	AAPL	Stock	7.155	7.1568	7.1525	7.1525	44100.0
2010-02-22 19:00:00	AAPL	Stock	7.1507	7.1554	7.1507	7.1525	92316.0
2010-02-22 19:30:00	AAPL	Stock	7.1582	7.1586	7.1521	7.1568	94248.0
2010-02-22 08:00:00	MSFT	Stock	28.85	28.9	28.85	28.88	9422.0
2010-02-22 08:30:00	MSFT	Stock	28.88	28.89	28.85	28.85	9300.0
2010-02-22 09:00:00	MSFT	Stock	28.84	28.84	28.76	28.83	28911.0
2010-02-22 09:30:00	MSFT	Stock	28.82	28.94	28.81	28.86	3936969.0
2010-02-22 10:00:00	MSFT	Stock	28.86	28.9	28.72	28.85	5023952.0
2010-02-22 10:30:00	MSFT	Stock	28.85	28.87	28.77	28.77	2009611.0
2010-02-22 11:00:00	MSFT	Stock	28.77	28.82	28.73	28.741	2208886.0
2010-02-22 11:30:00	MSFT	Stock	28.745	28.77	28.69	28.72	1827756.0
2010-02-22 12:00:00	MSFT	Stock	28.72	28.77	28.7	28.74	1529734.0
2010-02-22 12:30:00	MSFT	Stock	28.74	28.86	28.73	28.86	1803127.0
2010-02-22 13:00:00	MSFT	Stock	28.86	28.87	28.75	28.75	1361920.0
2010-02-22 13:30:00	MSFT	Stock	28.75	28.82	28.73	28.74	2222829.0
2010-02-22 14:00:00	MSFT	Stock	28.74	28.8	28.74	28.77	2366440.0
2010-02-22 14:30:00	MSFT	Stock	28.76	28.81	28.74	28.79	2237810.0
2010-02-22 15:00:00	MSFT	Stock	28.79	28.84	28.76	28.8	2470091.0
2010-02-22 15:30:00	MSFT	Stock	28.801	28.81	28.65	28.73	4387569.0
2010-02-22 16:00:00	MSFT	Stock	28.73	28.86	28.694	28.71	1448884.0
2010-02-22 16:30:00	MSFT	Stock	28.7	28.7	28.7	28.7	4000.0
2010-02-22 17:00:00	MSFT	Stock	28.68	28.68	28.68	28.68	450.0
2010-02-22 17:30:00	MSFT	Stock	28.68	28.68	28.68	28.68	200.0
2010-02-22 18:30:00	MSFT	Stock	28.7	28.7	28.66	28.68	2000.0
2010-02-22 19:30:00	MSFT	Stock	28.66	28.66	28.65	28.65	1300.0
2010-02-22 09:00:00	NVDA	Stock	0.4162	0.4173	0.4162	0.4173	104000.0

> showing 50 of 72,264 rows — these rows as CSV

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