PREVIEW / stock_30min / 2007-03-14

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-14.parquet
  size:    1.0 MB
  rows:    55,943
  symbols: 2,547

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
2007-03-14 06:30:00	AAPL	Stock	3.1389	3.1389	3.1389	3.1389	22400.0
2007-03-14 07:00:00	AAPL	Stock	3.1404	3.1475	3.1404	3.1436	114800.0
2007-03-14 07:30:00	AAPL	Stock	3.1479	3.1746	3.1475	3.1625	1367184.0
2007-03-14 08:00:00	AAPL	Stock	3.1625	3.1625	3.1468	3.1482	1168468.0
2007-03-14 08:30:00	AAPL	Stock	3.1536	3.1679	3.1536	3.1611	1451828.0
2007-03-14 09:00:00	AAPL	Stock	3.1611	3.1654	3.1589	3.1643	4393256.0
2007-03-14 09:30:00	AAPL	Stock	3.1643	3.1761	3.1575	3.1668	89178320.0
2007-03-14 10:00:00	AAPL	Stock	3.1668	3.1932	3.1604	3.1814	83029800.0
2007-03-14 10:30:00	AAPL	Stock	3.1818	3.1914	3.1746	3.1746	56942088.0
2007-03-14 11:00:00	AAPL	Stock	3.1746	3.1779	3.1661	3.1671	36947540.0
2007-03-14 11:30:00	AAPL	Stock	3.1671	3.1696	3.1536	3.16	42119476.0
2007-03-14 12:00:00	AAPL	Stock	3.16	3.1607	3.14	3.1475	59787532.0
2007-03-14 12:30:00	AAPL	Stock	3.1479	3.1571	3.1429	3.1511	51034480.0
2007-03-14 13:00:00	AAPL	Stock	3.1507	3.1868	3.1496	3.1761	74595696.0
2007-03-14 13:30:00	AAPL	Stock	3.1761	3.1889	3.1729	3.1754	45009048.0
2007-03-14 14:00:00	AAPL	Stock	3.1757	3.1879	3.1682	3.1868	44355052.0
2007-03-14 14:30:00	AAPL	Stock	3.1868	3.2011	3.1843	3.1918	59525172.0
2007-03-14 15:00:00	AAPL	Stock	3.1921	3.2089	3.1882	3.2025	53421256.0
2007-03-14 15:30:00	AAPL	Stock	3.2029	3.2143	3.1911	3.2139	65764272.0
2007-03-14 16:00:00	AAPL	Stock	3.2143	3.2225	3.2139	3.2179	3137484.0
2007-03-14 16:30:00	AAPL	Stock	3.2179	3.225	3.2164	3.2214	894208.0
2007-03-14 17:00:00	AAPL	Stock	3.2218	3.2218	3.2164	3.22	1200416.0
2007-03-14 17:30:00	AAPL	Stock	3.2211	3.2214	3.2196	3.2207	156492.0
2007-03-14 18:00:00	AAPL	Stock	3.2211	3.225	3.2207	3.2214	359492.0
2007-03-14 18:30:00	AAPL	Stock	3.2214	3.2232	3.2182	3.2232	75964.0
2007-03-14 19:00:00	AAPL	Stock	3.2214	3.2221	3.22	3.22	30632.0
2007-03-14 19:30:00	AAPL	Stock	3.22	3.225	3.22	3.2232	56840.0
2007-03-14 07:00:00	MSFT	Stock	26.63	26.63	26.63	26.63	1000.0
2007-03-14 07:30:00	MSFT	Stock	26.65	26.71	26.65	26.65	5300.0
2007-03-14 08:00:00	MSFT	Stock	26.57	26.69	26.57	26.6	4555.0
2007-03-14 08:30:00	MSFT	Stock	26.68	26.76	26.66	26.76	29236.0
2007-03-14 09:00:00	MSFT	Stock	26.74	26.86	26.74	26.81	108690.0
2007-03-14 09:30:00	MSFT	Stock	26.82	26.96	26.73	26.85	5985358.0
2007-03-14 10:00:00	MSFT	Stock	26.859	27.08	26.75	27.03	5862519.0
2007-03-14 10:30:00	MSFT	Stock	27.03	27.22	27.03	27.1	7866991.0
2007-03-14 11:00:00	MSFT	Stock	27.1	27.12	26.97	27.03	4229562.0
2007-03-14 11:30:00	MSFT	Stock	27.03	27.1	26.97	27.0	4127497.0
2007-03-14 12:00:00	MSFT	Stock	27.0	27.03	26.9	26.98	6810721.0
2007-03-14 12:30:00	MSFT	Stock	26.98	27.06	26.88	26.97	4389144.0
2007-03-14 13:00:00	MSFT	Stock	26.97	27.26	26.96	27.14	6329133.0
2007-03-14 13:30:00	MSFT	Stock	27.14	27.26	27.1	27.12	3367366.0
2007-03-14 14:00:00	MSFT	Stock	27.12	27.18	27.04	27.17	4417110.0
2007-03-14 14:30:00	MSFT	Stock	27.17	27.3	27.16	27.207	3963815.0
2007-03-14 15:00:00	MSFT	Stock	27.203	27.29	27.18	27.27	4609352.0
2007-03-14 15:30:00	MSFT	Stock	27.27	27.4	27.24	27.39	11178080.0
2007-03-14 16:00:00	MSFT	Stock	27.39	27.4	27.088	27.39	774761.0
2007-03-14 16:30:00	MSFT	Stock	27.36	27.38	27.36	27.38	1000.0
2007-03-14 17:00:00	MSFT	Stock	27.39	27.4	27.39	27.4	11421.0
2007-03-14 17:30:00	MSFT	Stock	27.4	27.4	27.38	27.38	682.0
2007-03-14 18:00:00	MSFT	Stock	27.4	27.4	27.4	27.4	5136.0

> showing 50 of 55,943 rows — these rows as CSV

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