PREVIEW / stock_30min / 2008-01-11

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-11.parquet
  size:    1.2 MB
  rows:    69,345
  symbols: 3,259

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-01-11 06:30:00	AAPL	Stock	6.3036	6.3036	6.3036	6.3036	11200.0
2008-01-11 07:00:00	AAPL	Stock	6.3036	6.3036	6.2857	6.2857	140868.0
2008-01-11 07:30:00	AAPL	Stock	6.2857	6.3171	6.2854	6.3168	130620.0
2008-01-11 08:00:00	AAPL	Stock	6.3107	6.3107	6.2704	6.2771	2660868.0
2008-01-11 08:30:00	AAPL	Stock	6.2771	6.2946	6.2643	6.2857	1600312.0
2008-01-11 09:00:00	AAPL	Stock	6.2893	6.3139	6.2821	6.2857	1799672.0
2008-01-11 09:30:00	AAPL	Stock	6.2857	6.3518	6.2679	6.3011	129852716.0
2008-01-11 10:00:00	AAPL	Stock	6.2979	6.34	6.2825	6.3143	80575040.0
2008-01-11 10:30:00	AAPL	Stock	6.3146	6.3243	6.2704	6.2786	65114224.0
2008-01-11 11:00:00	AAPL	Stock	6.2786	6.2857	6.2261	6.2568	87530632.0
2008-01-11 11:30:00	AAPL	Stock	6.2539	6.3004	6.225	6.2386	54978168.0
2008-01-11 12:00:00	AAPL	Stock	6.2393	6.2429	6.1611	6.1796	92455524.0
2008-01-11 12:30:00	AAPL	Stock	6.1793	6.1954	6.1564	6.1839	53941692.0
2008-01-11 13:00:00	AAPL	Stock	6.1825	6.1854	6.1218	6.1486	80012352.0
2008-01-11 13:30:00	AAPL	Stock	6.1486	6.1607	6.1193	6.12	59858596.0
2008-01-11 14:00:00	AAPL	Stock	6.12	6.1821	6.0896	6.1586	86316636.0
2008-01-11 14:30:00	AAPL	Stock	6.1589	6.1675	6.0846	6.1075	82373256.0
2008-01-11 15:00:00	AAPL	Stock	6.1107	6.1636	6.0714	6.1486	146022688.0
2008-01-11 15:30:00	AAPL	Stock	6.1489	6.2296	6.1304	6.1571	165831064.0
2008-01-11 16:00:00	AAPL	Stock	6.1586	6.2653	6.1438	6.1704	30484944.0
2008-01-11 16:30:00	AAPL	Stock	6.1686	6.1732	6.1636	6.1696	8067332.0
2008-01-11 17:00:00	AAPL	Stock	6.1689	6.1696	6.1356	6.1646	473844.0
2008-01-11 17:30:00	AAPL	Stock	6.1661	6.1671	6.1611	6.1643	353920.0
2008-01-11 18:00:00	AAPL	Stock	6.1643	6.1886	6.1643	6.1839	1236760.0
2008-01-11 18:30:00	AAPL	Stock	6.1839	6.1993	6.1839	6.1875	393988.0
2008-01-11 19:00:00	AAPL	Stock	6.1875	6.2007	6.1814	6.2007	249984.0
2008-01-11 19:30:00	AAPL	Stock	6.1975	6.2018	6.1875	6.1964	170380.0
2008-01-11 07:30:00	MSFT	Stock	33.81	33.81	33.81	33.81	400.0
2008-01-11 08:00:00	MSFT	Stock	34.04	34.2	34.04	34.2	3150.0
2008-01-11 08:30:00	MSFT	Stock	34.18	34.18	34.18	34.18	3000.0
2008-01-11 09:00:00	MSFT	Stock	34.1	34.2	34.0	34.02	77180.0
2008-01-11 09:30:00	MSFT	Stock	34.1	34.24	33.99	34.0	4306285.0
2008-01-11 10:00:00	MSFT	Stock	34.0	34.1	33.95	34.025	4713554.0
2008-01-11 10:30:00	MSFT	Stock	34.03	34.07	33.92	34.04	4568436.0
2008-01-11 11:00:00	MSFT	Stock	34.04	34.1	33.95	34.0	3610399.0
2008-01-11 11:30:00	MSFT	Stock	34.0	34.05	33.95	34.01	2482066.0
2008-01-11 12:00:00	MSFT	Stock	34.02	34.07	33.92	33.97	2327593.0
2008-01-11 12:30:00	MSFT	Stock	33.96	34.08	33.87	34.08	2263303.0
2008-01-11 13:00:00	MSFT	Stock	34.07	34.08	33.78	33.865	3644908.0
2008-01-11 13:30:00	MSFT	Stock	33.86	33.93	33.75	33.79	3505003.0
2008-01-11 14:00:00	MSFT	Stock	33.79	33.97	33.77	33.93	2417817.0
2008-01-11 14:30:00	MSFT	Stock	33.925	33.95	33.78	33.9	3565590.0
2008-01-11 15:00:00	MSFT	Stock	33.893	33.96	33.72	33.877	5442972.0
2008-01-11 15:30:00	MSFT	Stock	33.87	34.08	33.79	33.92	8302067.0
2008-01-11 16:00:00	MSFT	Stock	33.92	33.974	33.88	33.9	3861670.0
2008-01-11 16:30:00	MSFT	Stock	33.919	33.919	33.88	33.91	15446.0
2008-01-11 17:00:00	MSFT	Stock	33.88	33.91	33.843	33.86	4350.0
2008-01-11 17:30:00	MSFT	Stock	33.86	33.92	33.85	33.92	20728.0
2008-01-11 18:00:00	MSFT	Stock	33.87	33.88	33.86	33.88	4700.0
2008-01-11 18:30:00	MSFT	Stock	33.88	33.88	33.88	33.88	1398.0

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

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