PREVIEW / stock_30min / 2008-11-19

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-19.parquet
  size:    1.2 MB
  rows:    68,951
  symbols: 3,320

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-11-19 07:00:00	AAPL	Stock	3.2093	3.2107	3.2093	3.2107	30520.0
2008-11-19 07:30:00	AAPL	Stock	3.2079	3.2079	3.2018	3.2036	153664.0
2008-11-19 08:00:00	AAPL	Stock	3.1918	3.1918	3.175	3.1793	525896.0
2008-11-19 08:30:00	AAPL	Stock	3.1832	3.1925	3.1596	3.1618	1405264.0
2008-11-19 09:00:00	AAPL	Stock	3.1629	3.2036	3.1629	3.1986	1942612.0
2008-11-19 09:30:00	AAPL	Stock	3.1979	3.2489	3.1875	3.2239	134473640.0
2008-11-19 10:00:00	AAPL	Stock	3.2239	3.2707	3.2179	3.2482	125016136.0
2008-11-19 10:30:00	AAPL	Stock	3.2482	3.2511	3.1968	3.2071	90879432.0
2008-11-19 11:00:00	AAPL	Stock	3.2068	3.2293	3.1864	3.1936	75257616.0
2008-11-19 11:30:00	AAPL	Stock	3.1936	3.2011	3.1596	3.1743	73564512.0
2008-11-19 12:00:00	AAPL	Stock	3.1743	3.1871	3.1529	3.1614	49860552.0
2008-11-19 12:30:00	AAPL	Stock	3.1614	3.1893	3.1561	3.1868	52278408.0
2008-11-19 13:00:00	AAPL	Stock	3.1864	3.1989	3.1454	3.1457	52724504.0
2008-11-19 13:30:00	AAPL	Stock	3.1461	3.1821	3.1346	3.1661	59096520.0
2008-11-19 14:00:00	AAPL	Stock	3.1671	3.1707	3.1414	3.1554	66403540.0
2008-11-19 14:30:00	AAPL	Stock	3.1561	3.1954	3.14	3.1861	86109856.0
2008-11-19 15:00:00	AAPL	Stock	3.1861	3.2064	3.1482	3.1593	104877724.0
2008-11-19 15:30:00	AAPL	Stock	3.1593	3.1661	3.0793	3.0793	159740784.0
2008-11-19 16:00:00	AAPL	Stock	3.0793	3.2375	3.0789	3.0911	22608936.0
2008-11-19 16:30:00	AAPL	Stock	3.0911	3.1555	3.0818	3.0846	4765572.0
2008-11-19 17:00:00	AAPL	Stock	3.0857	3.0893	3.0836	3.0836	254380.0
2008-11-19 17:30:00	AAPL	Stock	3.0836	3.0893	3.0829	3.0889	342496.0
2008-11-19 18:00:00	AAPL	Stock	3.0893	3.0929	3.0825	3.0825	190988.0
2008-11-19 18:30:00	AAPL	Stock	3.0875	3.0875	3.0825	3.0825	72968.0
2008-11-19 19:00:00	AAPL	Stock	3.085	3.0875	3.0768	3.0768	156492.0
2008-11-19 19:30:00	AAPL	Stock	3.0804	3.0829	3.0768	3.0829	61656.0
2008-11-19 07:00:00	MSFT	Stock	19.3	19.3	19.3	19.3	100.0
2008-11-19 07:30:00	MSFT	Stock	19.5	19.5	19.5	19.5	500.0
2008-11-19 08:00:00	MSFT	Stock	19.5	19.62	19.4	19.5	29238.0
2008-11-19 08:30:00	MSFT	Stock	19.45	19.45	19.38	19.42	15796.0
2008-11-19 09:00:00	MSFT	Stock	19.37	19.62	19.37	19.62	36008.0
2008-11-19 09:30:00	MSFT	Stock	19.6	19.92	19.565	19.68	6776241.0
2008-11-19 10:00:00	MSFT	Stock	19.68	19.95	19.66	19.84	7411932.0
2008-11-19 10:30:00	MSFT	Stock	19.832	19.85	19.5	19.522	7159817.0
2008-11-19 11:00:00	MSFT	Stock	19.52	19.56	19.12	19.128	6752427.0
2008-11-19 11:30:00	MSFT	Stock	19.15	19.17	18.8	19.0	10243960.0
2008-11-19 12:00:00	MSFT	Stock	19.0	19.1	18.87	18.91	4926977.0
2008-11-19 12:30:00	MSFT	Stock	18.91	19.04	18.88	18.98	3285668.0
2008-11-19 13:00:00	MSFT	Stock	18.982	19.12	18.85	18.85	4247904.0
2008-11-19 13:30:00	MSFT	Stock	18.85	19.04	18.78	18.99	4284506.0
2008-11-19 14:00:00	MSFT	Stock	18.99	19.03	18.83	18.87	5603544.0
2008-11-19 14:30:00	MSFT	Stock	18.87	19.24	18.75	19.159	7843220.0
2008-11-19 15:00:00	MSFT	Stock	19.155	19.2	18.81	18.9	9195137.0
2008-11-19 15:30:00	MSFT	Stock	18.9	18.98	18.25	18.27	18911261.0
2008-11-19 16:00:00	MSFT	Stock	18.28	19.71	18.25	18.33	4262100.0
2008-11-19 16:30:00	MSFT	Stock	18.32	18.36	18.29	18.34	405278.0
2008-11-19 17:00:00	MSFT	Stock	18.34	18.38	18.3	18.35	13470.0
2008-11-19 17:30:00	MSFT	Stock	18.34	19.065	18.31	18.36	25589.0
2008-11-19 18:00:00	MSFT	Stock	18.35	18.36	18.31	18.35	4555.0
2008-11-19 18:30:00	MSFT	Stock	18.35	18.38	18.3	18.35	22650.0

> showing 50 of 68,951 rows — these rows as CSV

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