PREVIEW / stock_30min / 2008-12-18

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-12-18.parquet
  size:    1.2 MB
  rows:    69,823
  symbols: 3,348

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
2008-12-18 04:30:00	AAPL	Stock	3.2111	3.2111	3.2111	3.2111	5600.0
2008-12-18 05:30:00	AAPL	Stock	3.1929	3.1929	3.1929	3.1929	2800.0
2008-12-18 06:30:00	AAPL	Stock	3.2107	3.2107	3.2107	3.2107	2800.0
2008-12-18 07:00:00	AAPL	Stock	3.2064	3.2068	3.1964	3.1964	22456.0
2008-12-18 07:30:00	AAPL	Stock	3.1961	3.2036	3.1789	3.1961	56000.0
2008-12-18 08:00:00	AAPL	Stock	3.1982	3.2032	3.1846	3.1964	714196.0
2008-12-18 08:30:00	AAPL	Stock	3.1961	3.2064	3.1893	3.2004	1059492.0
2008-12-18 09:00:00	AAPL	Stock	3.2004	3.2032	3.1889	3.1936	959448.0
2008-12-18 09:30:00	AAPL	Stock	3.1943	3.2321	3.1586	3.2186	135368940.0
2008-12-18 10:00:00	AAPL	Stock	3.22	3.2439	3.2036	3.2211	83702444.0
2008-12-18 10:30:00	AAPL	Stock	3.2211	3.2321	3.2154	3.2275	52254720.0
2008-12-18 11:00:00	AAPL	Stock	3.2272	3.2275	3.1918	3.2004	45581788.0
2008-12-18 11:30:00	AAPL	Stock	3.2011	3.2225	3.1993	3.2207	32507580.0
2008-12-18 12:00:00	AAPL	Stock	3.2214	3.2293	3.2089	3.2118	32725252.0
2008-12-18 12:30:00	AAPL	Stock	3.2117	3.2314	3.2117	3.2307	31248084.0
2008-12-18 13:00:00	AAPL	Stock	3.2307	3.2396	3.2186	3.2232	32741072.0
2008-12-18 13:30:00	AAPL	Stock	3.2225	3.23	3.2036	3.2136	47214832.0
2008-12-18 14:00:00	AAPL	Stock	3.2136	3.2275	3.1989	3.2054	56786184.0
2008-12-18 14:30:00	AAPL	Stock	3.2054	3.2161	3.1993	3.2096	59317496.0
2008-12-18 15:00:00	AAPL	Stock	3.2086	3.2161	3.1689	3.1825	82744256.0
2008-12-18 15:30:00	AAPL	Stock	3.1818	3.2118	3.1782	3.1932	108550176.0
2008-12-18 16:00:00	AAPL	Stock	3.197	3.2679	3.1939	3.2161	29698480.0
2008-12-18 16:30:00	AAPL	Stock	3.2161	3.2232	3.1939	3.2036	12332152.0
2008-12-18 17:00:00	AAPL	Stock	3.2068	3.2079	3.1964	3.2036	351876.0
2008-12-18 17:30:00	AAPL	Stock	3.2036	3.2089	3.2014	3.2036	246680.0
2008-12-18 18:00:00	AAPL	Stock	3.2036	3.2036	3.1939	3.1964	928508.0
2008-12-18 18:30:00	AAPL	Stock	3.2064	3.2064	3.1989	3.1989	22400.0
2008-12-18 19:00:00	AAPL	Stock	3.1989	3.2096	3.1989	3.2	70308.0
2008-12-18 19:30:00	AAPL	Stock	3.2096	3.2096	3.2	3.2096	234724.0
2008-12-18 07:30:00	MSFT	Stock	19.88	19.88	19.88	19.88	100.0
2008-12-18 08:00:00	MSFT	Stock	19.63	19.8	19.63	19.8	2380.0
2008-12-18 08:30:00	MSFT	Stock	19.8	19.89	19.8	19.85	4100.0
2008-12-18 09:00:00	MSFT	Stock	19.84	19.88	19.8	19.83	10934.0
2008-12-18 09:30:00	MSFT	Stock	19.84	20.02	19.72	19.81	6555632.0
2008-12-18 10:00:00	MSFT	Stock	19.802	19.93	19.77	19.79	6146401.0
2008-12-18 10:30:00	MSFT	Stock	19.79	19.86	19.788	19.826	6101468.0
2008-12-18 11:00:00	MSFT	Stock	19.82	19.85	19.75	19.79	4143280.0
2008-12-18 11:30:00	MSFT	Stock	19.79	19.86	19.77	19.86	2718986.0
2008-12-18 12:00:00	MSFT	Stock	19.86	19.87	19.77	19.79	3191247.0
2008-12-18 12:30:00	MSFT	Stock	19.78	19.82	19.77	19.77	2187287.0
2008-12-18 13:00:00	MSFT	Stock	19.78	19.8	19.71	19.72	3597732.0
2008-12-18 13:30:00	MSFT	Stock	19.73	19.75	19.47	19.48	5358857.0
2008-12-18 14:00:00	MSFT	Stock	19.48	19.58	19.36	19.44	5355500.0
2008-12-18 14:30:00	MSFT	Stock	19.44	19.52	19.35	19.448	5114928.0
2008-12-18 15:00:00	MSFT	Stock	19.45	19.45	18.99	19.02	8434563.0
2008-12-18 15:30:00	MSFT	Stock	19.02	19.34	19.0	19.31	13728945.0
2008-12-18 16:00:00	MSFT	Stock	19.33	19.754	19.205	19.36	6782139.0
2008-12-18 16:30:00	MSFT	Stock	19.44	19.44	19.3	19.3	47802.0
2008-12-18 17:00:00	MSFT	Stock	19.39	19.39	19.35	19.39	3527.0
2008-12-18 17:30:00	MSFT	Stock	19.43	19.43	19.39	19.43	2300.0

> showing 50 of 69,823 rows — these rows as CSV

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