PREVIEW / stock_30min / 2013-12-10

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-10.parquet
  size:    1.6 MB
  rows:    82,761
  symbols: 3,527

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
2013-12-10 04:00:00	AAPL	Stock	20.2721	20.2721	20.2721	20.2721	2800.0
2013-12-10 05:30:00	AAPL	Stock	20.25	20.25	20.25	20.25	2800.0
2013-12-10 06:00:00	AAPL	Stock	20.2589	20.2589	20.25	20.25	23800.0
2013-12-10 06:30:00	AAPL	Stock	20.2489	20.2489	20.2264	20.2264	50652.0
2013-12-10 07:00:00	AAPL	Stock	20.2396	20.2396	20.2007	20.2007	79800.0
2013-12-10 07:30:00	AAPL	Stock	20.1968	20.2029	20.1696	20.1836	199332.0
2013-12-10 08:00:00	AAPL	Stock	20.1929	20.2329	20.125	20.1268	1202852.0
2013-12-10 08:30:00	AAPL	Stock	20.1307	20.1561	20.1289	20.1429	539644.0
2013-12-10 09:00:00	AAPL	Stock	20.1432	20.1536	20.1286	20.1293	935704.0
2013-12-10 09:30:00	AAPL	Stock	20.1293	20.1636	20.0429	20.0932	45744300.0
2013-12-10 10:00:00	AAPL	Stock	20.0919	20.1375	20.0479	20.1375	23875264.0
2013-12-10 10:30:00	AAPL	Stock	20.1379	20.2257	20.1339	20.2007	19832680.0
2013-12-10 11:00:00	AAPL	Stock	20.1986	20.2814	20.1743	20.2682	21955640.0
2013-12-10 11:30:00	AAPL	Stock	20.2682	20.2696	20.1602	20.1711	14961492.0
2013-12-10 12:00:00	AAPL	Stock	20.1711	20.2046	20.1436	20.19	16216228.0
2013-12-10 12:30:00	AAPL	Stock	20.1857	20.2389	20.1804	20.2225	12002116.0
2013-12-10 13:00:00	AAPL	Stock	20.2229	20.2346	20.1864	20.1982	7512344.0
2013-12-10 13:30:00	AAPL	Stock	20.2018	20.2214	20.1793	20.1959	6693988.0
2013-12-10 14:00:00	AAPL	Stock	20.1921	20.1971	20.1557	20.1904	7630924.0
2013-12-10 14:30:00	AAPL	Stock	20.1904	20.2129	20.1714	20.2061	5069456.0
2013-12-10 15:00:00	AAPL	Stock	20.2086	20.2425	20.2079	20.2396	9865632.0
2013-12-10 15:30:00	AAPL	Stock	20.2379	20.2536	20.1979	20.2014	17716440.0
2013-12-10 16:00:00	AAPL	Stock	20.1982	20.2296	20.0705	20.1839	12369672.0
2013-12-10 16:30:00	AAPL	Stock	20.2022	20.2022	20.1911	20.1946	150360.0
2013-12-10 17:00:00	AAPL	Stock	20.2007	20.2032	20.19	20.19	136696.0
2013-12-10 17:30:00	AAPL	Stock	20.1982	20.1982	20.1839	20.1839	25172.0
2013-12-10 18:00:00	AAPL	Stock	20.1946	20.2318	20.1864	20.2318	329840.0
2013-12-10 18:30:00	AAPL	Stock	20.23	20.2804	20.1982	20.2643	752556.0
2013-12-10 19:00:00	AAPL	Stock	20.2614	20.2614	20.2411	20.25	250236.0
2013-12-10 19:30:00	AAPL	Stock	20.2546	20.275	20.2546	20.2661	166040.0
2013-12-10 08:00:00	MSFT	Stock	38.66	38.68	38.66	38.66	76510.0
2013-12-10 08:30:00	MSFT	Stock	38.54	38.62	38.53	38.57	44600.0
2013-12-10 09:00:00	MSFT	Stock	38.57	38.62	38.55	38.61	21341.0
2013-12-10 09:30:00	MSFT	Stock	38.61	38.9	38.41	38.505	4305386.0
2013-12-10 10:00:00	MSFT	Stock	38.505	38.51	38.27	38.31	2680086.0
2013-12-10 10:30:00	MSFT	Stock	38.315	38.32	38.095	38.2	2356640.0
2013-12-10 11:00:00	MSFT	Stock	38.21	38.33	38.08	38.15	2978569.0
2013-12-10 11:30:00	MSFT	Stock	38.15	38.218	38.02	38.13	3405205.0
2013-12-10 12:00:00	MSFT	Stock	38.13	38.29	38.04	38.26	4096469.0
2013-12-10 12:30:00	MSFT	Stock	38.264	38.29	38.19	38.25	1363901.0
2013-12-10 13:00:00	MSFT	Stock	38.25	38.25	38.12	38.156	1436194.0
2013-12-10 13:30:00	MSFT	Stock	38.153	38.238	38.135	38.16	1027035.0
2013-12-10 14:00:00	MSFT	Stock	38.166	38.19	38.13	38.19	1203529.0
2013-12-10 14:30:00	MSFT	Stock	38.19	38.22	38.14	38.16	1290424.0
2013-12-10 15:00:00	MSFT	Stock	38.16	38.22	38.13	38.18	1542011.0
2013-12-10 15:30:00	MSFT	Stock	38.175	38.2	38.08	38.115	4649096.0
2013-12-10 16:00:00	MSFT	Stock	38.12	38.67	38.09	38.12	2232720.0
2013-12-10 16:30:00	MSFT	Stock	38.177	38.19	38.11	38.11	25047.0
2013-12-10 17:00:00	MSFT	Stock	38.15	38.18	38.11	38.18	2159.0
2013-12-10 18:00:00	MSFT	Stock	38.2	38.2	38.15	38.15	4188.0

> showing 50 of 82,761 rows — these rows as CSV

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