PREVIEW / stock_30min / 2011-01-11

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-11.parquet
  size:    1.4 MB
  rows:    77,291
  symbols: 3,509

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
2011-01-11 04:00:00	AAPL	Stock	12.3014	12.3014	12.3014	12.3014	28000.0
2011-01-11 04:30:00	AAPL	Stock	12.3068	12.3107	12.3054	12.3107	11200.0
2011-01-11 05:00:00	AAPL	Stock	12.3146	12.3146	12.3004	12.3139	8400.0
2011-01-11 05:30:00	AAPL	Stock	12.3139	12.3139	12.3139	12.3139	8400.0
2011-01-11 06:00:00	AAPL	Stock	12.3036	12.3139	12.3036	12.3139	126000.0
2011-01-11 06:30:00	AAPL	Stock	12.3139	12.3389	12.3089	12.3389	65800.0
2011-01-11 07:00:00	AAPL	Stock	12.3171	12.3389	12.3093	12.325	314720.0
2011-01-11 07:30:00	AAPL	Stock	12.325	12.3304	12.2893	12.3018	462476.0
2011-01-11 08:00:00	AAPL	Stock	12.2989	12.3089	12.2743	12.3036	2516024.0
2011-01-11 08:30:00	AAPL	Stock	12.3032	12.3036	12.2929	12.3	2017904.0
2011-01-11 09:00:00	AAPL	Stock	12.2996	12.3129	12.2968	12.3114	2924488.0
2011-01-11 09:30:00	AAPL	Stock	12.3114	12.32	12.1911	12.2007	88627644.0
2011-01-11 10:00:00	AAPL	Stock	12.2004	12.2446	12.1911	12.2361	39715956.0
2011-01-11 10:30:00	AAPL	Stock	12.2361	12.2386	12.2075	12.2254	26819660.0
2011-01-11 11:00:00	AAPL	Stock	12.2236	12.2586	12.1782	12.2193	57089200.0
2011-01-11 11:30:00	AAPL	Stock	12.2193	12.2571	12.1914	12.2004	32409748.0
2011-01-11 12:00:00	AAPL	Stock	12.2002	12.2089	12.1871	12.2021	14743988.0
2011-01-11 12:30:00	AAPL	Stock	12.2004	12.2139	12.185	12.2011	14365064.0
2011-01-11 13:00:00	AAPL	Stock	12.2007	12.2025	12.1657	12.1793	23495976.0
2011-01-11 13:30:00	AAPL	Stock	12.1793	12.1918	12.1471	12.1532	21341012.0
2011-01-11 14:00:00	AAPL	Stock	12.1514	12.1729	12.1239	12.1725	34148380.0
2011-01-11 14:30:00	AAPL	Stock	12.1725	12.185	12.1539	12.1821	17743768.0
2011-01-11 15:00:00	AAPL	Stock	12.1818	12.1929	12.1696	12.1814	14692860.0
2011-01-11 15:30:00	AAPL	Stock	12.1807	12.2011	12.1704	12.2	29245216.0
2011-01-11 16:00:00	AAPL	Stock	12.2014	12.208	12.1837	12.2036	8021384.0
2011-01-11 16:30:00	AAPL	Stock	12.2029	12.2082	12.1825	12.2061	806148.0
2011-01-11 17:00:00	AAPL	Stock	12.2064	12.2139	12.2064	12.2114	962360.0
2011-01-11 17:30:00	AAPL	Stock	12.2118	12.2125	12.2068	12.2068	161560.0
2011-01-11 18:00:00	AAPL	Stock	12.2089	12.2114	12.2014	12.2104	241500.0
2011-01-11 18:30:00	AAPL	Stock	12.2079	12.2082	12.2	12.2043	531244.0
2011-01-11 19:00:00	AAPL	Stock	12.2043	12.205	12.2004	12.2018	320600.0
2011-01-11 19:30:00	AAPL	Stock	12.2018	12.2039	12.2011	12.2011	279328.0
2011-01-11 06:30:00	MSFT	Stock	28.3	28.3	28.3	28.3	100.0
2011-01-11 07:00:00	MSFT	Stock	28.36	28.36	28.36	28.36	500.0
2011-01-11 07:30:00	MSFT	Stock	28.4	28.4	28.33	28.33	1700.0
2011-01-11 08:00:00	MSFT	Stock	28.33	28.36	28.32	28.35	14402.0
2011-01-11 08:30:00	MSFT	Stock	28.34	28.35	28.3	28.35	3272.0
2011-01-11 09:00:00	MSFT	Stock	28.33	28.4	28.18	28.18	167573.0
2011-01-11 09:30:00	MSFT	Stock	28.2	28.24	28.05	28.07	6468964.0
2011-01-11 10:00:00	MSFT	Stock	28.062	28.19	28.06	28.13	3362343.0
2011-01-11 10:30:00	MSFT	Stock	28.13	28.17	28.12	28.15	3210999.0
2011-01-11 11:00:00	MSFT	Stock	28.15	28.2	28.11	28.13	4236993.0
2011-01-11 11:30:00	MSFT	Stock	28.14	28.14	28.11	28.11	2869030.0
2011-01-11 12:00:00	MSFT	Stock	28.11	28.15	28.11	28.14	1514579.0
2011-01-11 12:30:00	MSFT	Stock	28.14	28.18	28.13	28.18	1851192.0
2011-01-11 13:00:00	MSFT	Stock	28.18	28.19	28.15	28.18	3292230.0
2011-01-11 13:30:00	MSFT	Stock	28.18	28.21	28.07	28.12	3110569.0
2011-01-11 14:00:00	MSFT	Stock	28.12	28.23	28.08	28.22	2012036.0
2011-01-11 14:30:00	MSFT	Stock	28.221	28.24	28.19	28.21	2084593.0
2011-01-11 15:00:00	MSFT	Stock	28.21	28.25	28.16	28.198	3724644.0

> showing 50 of 77,291 rows — these rows as CSV

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