PREVIEW / stock_30min / 2010-02-19

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-19.parquet
  size:    1.3 MB
  rows:    72,216
  symbols: 3,443

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-19 04:30:00	AAPL	Stock	7.1821	7.1821	7.1821	7.1821	5600.0
2010-02-19 06:30:00	AAPL	Stock	7.1921	7.1964	7.1921	7.1964	15960.0
2010-02-19 07:00:00	AAPL	Stock	7.1946	7.2232	7.1946	7.2071	70672.0
2010-02-19 07:30:00	AAPL	Stock	7.2136	7.2232	7.2136	7.2232	28000.0
2010-02-19 08:00:00	AAPL	Stock	7.22	7.22	7.1875	7.205	639520.0
2010-02-19 08:30:00	AAPL	Stock	7.205	7.2411	7.2036	7.2325	2438828.0
2010-02-19 09:00:00	AAPL	Stock	7.2361	7.2364	7.2093	7.21	657720.0
2010-02-19 09:30:00	AAPL	Stock	7.2111	7.23	7.1993	7.1993	52205468.0
2010-02-19 10:00:00	AAPL	Stock	7.1993	7.2239	7.1825	7.2121	47691224.0
2010-02-19 10:30:00	AAPL	Stock	7.2125	7.2232	7.2046	7.2086	21343784.0
2010-02-19 11:00:00	AAPL	Stock	7.2089	7.2418	7.2086	7.2407	28797104.0
2010-02-19 11:30:00	AAPL	Stock	7.2407	7.2518	7.2221	7.2496	29445052.0
2010-02-19 12:00:00	AAPL	Stock	7.2496	7.2571	7.2314	7.2404	26977216.0
2010-02-19 12:30:00	AAPL	Stock	7.2404	7.2432	7.2295	7.2407	12767832.0
2010-02-19 13:00:00	AAPL	Stock	7.2411	7.2464	7.2157	7.2193	20624828.0
2010-02-19 13:30:00	AAPL	Stock	7.2193	7.23	7.2086	7.2196	13844516.0
2010-02-19 14:00:00	AAPL	Stock	7.22	7.2229	7.2107	7.2157	16184868.0
2010-02-19 14:30:00	AAPL	Stock	7.2157	7.2221	7.2071	7.2082	17420368.0
2010-02-19 15:00:00	AAPL	Stock	7.2082	7.2086	7.1839	7.1889	34771912.0
2010-02-19 15:30:00	AAPL	Stock	7.1887	7.205	7.1887	7.2014	52086776.0
2010-02-19 16:00:00	AAPL	Stock	7.1986	7.2243	7.1968	7.1986	10025568.0
2010-02-19 16:30:00	AAPL	Stock	7.1884	7.1993	7.1884	7.1964	356496.0
2010-02-19 17:00:00	AAPL	Stock	7.1936	7.1961	7.1929	7.1929	57400.0
2010-02-19 17:30:00	AAPL	Stock	7.1929	7.1946	7.1914	7.1946	149240.0
2010-02-19 18:00:00	AAPL	Stock	7.1957	7.1996	7.1946	7.1946	81200.0
2010-02-19 18:30:00	AAPL	Stock	7.1957	7.1996	7.1957	7.1968	82964.0
2010-02-19 19:00:00	AAPL	Stock	7.1982	7.1996	7.1982	7.1982	46228.0
2010-02-19 19:30:00	AAPL	Stock	7.1975	7.2	7.1957	7.1964	84924.0
2010-02-19 20:00:00	AAPL	Stock	7.2368	7.2368	7.2368	7.2368	36400.0
2010-02-19 04:00:00	MSFT	Stock	28.94	28.94	28.94	28.94	400.0
2010-02-19 07:00:00	MSFT	Stock	28.7	28.73	28.67	28.73	4000.0
2010-02-19 07:30:00	MSFT	Stock	28.72	28.82	28.71	28.82	9929.0
2010-02-19 08:00:00	MSFT	Stock	28.75	28.75	28.71	28.73	14835.0
2010-02-19 08:30:00	MSFT	Stock	28.73	28.86	28.73	28.85	24958.0
2010-02-19 09:00:00	MSFT	Stock	28.85	28.969	28.78	28.78	35050.0
2010-02-19 09:30:00	MSFT	Stock	28.79	28.92	28.73	28.75	9426885.0
2010-02-19 10:00:00	MSFT	Stock	28.75	28.81	28.69	28.77	4352855.0
2010-02-19 10:30:00	MSFT	Stock	28.77	28.82	28.7	28.8	1963648.0
2010-02-19 11:00:00	MSFT	Stock	28.791	28.91	28.77	28.88	2297761.0
2010-02-19 11:30:00	MSFT	Stock	28.88	28.89	28.81	28.87	1833207.0
2010-02-19 12:00:00	MSFT	Stock	28.873	28.91	28.79	28.817	2287374.0
2010-02-19 12:30:00	MSFT	Stock	28.81	28.83	28.74	28.83	1885102.0
2010-02-19 13:00:00	MSFT	Stock	28.825	28.91	28.82	28.86	2693556.0
2010-02-19 13:30:00	MSFT	Stock	28.86	28.89	28.79	28.84	2174134.0
2010-02-19 14:00:00	MSFT	Stock	28.841	28.85	28.79	28.815	1361219.0
2010-02-19 14:30:00	MSFT	Stock	28.815	28.85	28.79	28.8	2103944.0
2010-02-19 15:00:00	MSFT	Stock	28.792	28.81	28.7	28.72	2607463.0
2010-02-19 15:30:00	MSFT	Stock	28.724	28.81	28.72	28.77	6443422.0
2010-02-19 16:00:00	MSFT	Stock	28.78	28.797	28.69	28.73	2524783.0
2010-02-19 16:30:00	MSFT	Stock	28.73	28.83	28.71	28.8	36911.0

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

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