PREVIEW / stock_30min / 2009-12-23

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-23.parquet
  size:    1.3 MB
  rows:    72,824
  symbols: 3,450

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
2009-12-23 04:30:00	AAPL	Stock	7.1525	7.1525	7.1525	7.1525	5600.0
2009-12-23 07:00:00	AAPL	Stock	7.1857	7.1929	7.1857	7.1929	174888.0
2009-12-23 07:30:00	AAPL	Stock	7.1857	7.1889	7.1857	7.1875	26712.0
2009-12-23 08:00:00	AAPL	Stock	7.1825	7.1907	7.1725	7.1786	572404.0
2009-12-23 08:30:00	AAPL	Stock	7.1786	7.1911	7.1746	7.1893	869876.0
2009-12-23 09:00:00	AAPL	Stock	7.1896	7.1936	7.1843	7.1864	683928.0
2009-12-23 09:30:00	AAPL	Stock	7.1857	7.2143	7.1811	7.1992	60246088.0
2009-12-23 10:00:00	AAPL	Stock	7.1971	7.2104	7.1718	7.1904	46354084.0
2009-12-23 10:30:00	AAPL	Stock	7.1904	7.2146	7.1868	7.2001	37469768.0
2009-12-23 11:00:00	AAPL	Stock	7.2002	7.2061	7.1861	7.1968	29354052.0
2009-12-23 11:30:00	AAPL	Stock	7.1969	7.2104	7.1954	7.2034	12983908.0
2009-12-23 12:00:00	AAPL	Stock	7.2025	7.2107	7.1979	7.2051	14174160.0
2009-12-23 12:30:00	AAPL	Stock	7.2052	7.2136	7.1968	7.2125	14523824.0
2009-12-23 13:00:00	AAPL	Stock	7.2121	7.2279	7.2061	7.2125	26081804.0
2009-12-23 13:30:00	AAPL	Stock	7.2132	7.225	7.2129	7.2186	14985208.0
2009-12-23 14:00:00	AAPL	Stock	7.2186	7.2243	7.215	7.2214	12883556.0
2009-12-23 14:30:00	AAPL	Stock	7.2206	7.2239	7.2164	7.2189	11929624.0
2009-12-23 15:00:00	AAPL	Stock	7.2189	7.22	7.2093	7.2121	18347112.0
2009-12-23 15:30:00	AAPL	Stock	7.2129	7.2236	7.2	7.2211	34576192.0
2009-12-23 16:00:00	AAPL	Stock	7.2211	7.2275	7.1974	7.2207	4183984.0
2009-12-23 16:30:00	AAPL	Stock	7.2135	7.2261	7.2135	7.2232	288512.0
2009-12-23 17:00:00	AAPL	Stock	7.22	7.2232	7.2179	7.2232	46284.0
2009-12-23 17:30:00	AAPL	Stock	7.2214	7.2232	7.2179	7.2225	354116.0
2009-12-23 18:00:00	AAPL	Stock	7.2232	7.225	7.2179	7.2232	364000.0
2009-12-23 18:30:00	AAPL	Stock	7.2232	7.2246	7.2225	7.2225	73920.0
2009-12-23 19:00:00	AAPL	Stock	7.2214	7.2261	7.2214	7.2214	164780.0
2009-12-23 19:30:00	AAPL	Stock	7.2214	7.2225	7.2214	7.2214	91560.0
2009-12-23 05:00:00	MSFT	Stock	30.59	30.59	30.59	30.59	100.0
2009-12-23 06:00:00	MSFT	Stock	30.69	30.69	30.6	30.6	650.0
2009-12-23 07:00:00	MSFT	Stock	30.7	30.7	30.7	30.7	1800.0
2009-12-23 07:30:00	MSFT	Stock	30.7	30.8	30.7	30.8	630.0
2009-12-23 08:00:00	MSFT	Stock	30.85	30.92	30.56	30.85	27165.0
2009-12-23 08:30:00	MSFT	Stock	30.82	30.85	30.76	30.76	4100.0
2009-12-23 09:00:00	MSFT	Stock	30.76	30.78	30.7	30.7	16750.0
2009-12-23 09:30:00	MSFT	Stock	30.7	30.86	30.7	30.81	2081223.0
2009-12-23 10:00:00	MSFT	Stock	30.81	30.83	30.69	30.715	2186608.0
2009-12-23 10:30:00	MSFT	Stock	30.72	30.83	30.71	30.81	2334460.0
2009-12-23 11:00:00	MSFT	Stock	30.815	30.87	30.81	30.865	1512415.0
2009-12-23 11:30:00	MSFT	Stock	30.86	30.9	30.83	30.88	1460672.0
2009-12-23 12:00:00	MSFT	Stock	30.882	30.92	30.87	30.92	1648348.0
2009-12-23 12:30:00	MSFT	Stock	30.92	30.95	30.89	30.93	1598291.0
2009-12-23 13:00:00	MSFT	Stock	30.93	30.94	30.89	30.895	1370346.0
2009-12-23 13:30:00	MSFT	Stock	30.9	30.93	30.81	30.849	2628637.0
2009-12-23 14:00:00	MSFT	Stock	30.85	30.93	30.84	30.86	1490697.0
2009-12-23 14:30:00	MSFT	Stock	30.87	30.94	30.86	30.91	1498619.0
2009-12-23 15:00:00	MSFT	Stock	30.9	30.91	30.84	30.845	1590439.0
2009-12-23 15:30:00	MSFT	Stock	30.845	30.95	30.84	30.93	3769828.0
2009-12-23 16:00:00	MSFT	Stock	30.92	30.95	30.819	30.819	908812.0
2009-12-23 16:30:00	MSFT	Stock	30.835	30.9	30.835	30.9	7900.0
2009-12-23 17:00:00	MSFT	Stock	30.9	30.91	30.9	30.9	13556.0

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

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