PREVIEW / stock_30min / 2014-10-24

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-24.parquet
  size:    1.6 MB
  rows:    81,468
  symbols: 3,537

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
2014-10-24 04:00:00	AAPL	Stock	26.2025	26.2175	26.2025	26.2175	2880.0
2014-10-24 04:30:00	AAPL	Stock	26.18	26.205	26.175	26.175	7600.0
2014-10-24 05:00:00	AAPL	Stock	26.1925	26.1925	26.175	26.1825	5600.0
2014-10-24 05:30:00	AAPL	Stock	26.175	26.1775	26.15	26.15	16892.0
2014-10-24 06:00:00	AAPL	Stock	26.17	26.175	26.15	26.1625	8832.0
2014-10-24 06:30:00	AAPL	Stock	26.15	26.1875	26.15	26.18	31744.0
2014-10-24 07:00:00	AAPL	Stock	26.1925	26.235	26.1925	26.2075	47328.0
2014-10-24 07:30:00	AAPL	Stock	26.2025	26.2025	26.1625	26.2	145372.0
2014-10-24 08:00:00	AAPL	Stock	26.195	26.3025	26.15	26.3025	564004.0
2014-10-24 08:30:00	AAPL	Stock	26.3025	26.3625	26.2925	26.33	1122336.0
2014-10-24 09:00:00	AAPL	Stock	26.33	26.365	26.285	26.285	611856.0
2014-10-24 09:30:00	AAPL	Stock	26.285	26.3725	26.14	26.16	32049276.0
2014-10-24 10:00:00	AAPL	Stock	26.1575	26.2725	26.1325	26.2025	17685536.0
2014-10-24 10:30:00	AAPL	Stock	26.2025	26.27	26.2025	26.2325	9717776.0
2014-10-24 11:00:00	AAPL	Stock	26.2325	26.2375	26.15	26.2075	10957384.0
2014-10-24 11:30:00	AAPL	Stock	26.21	26.27	26.2075	26.2568	9662456.0
2014-10-24 12:00:00	AAPL	Stock	26.255	26.26	26.2275	26.2325	7026080.0
2014-10-24 12:30:00	AAPL	Stock	26.235	26.2375	26.2	26.2025	5810584.0
2014-10-24 13:00:00	AAPL	Stock	26.2038	26.2325	26.1875	26.2275	6262344.0
2014-10-24 13:30:00	AAPL	Stock	26.2282	26.2475	26.22	26.235	5403976.0
2014-10-24 14:00:00	AAPL	Stock	26.2355	26.2525	26.23	26.2425	6681564.0
2014-10-24 14:30:00	AAPL	Stock	26.2425	26.25	26.1925	26.2412	7688752.0
2014-10-24 15:00:00	AAPL	Stock	26.2408	26.2875	26.22	26.2312	10922840.0
2014-10-24 15:30:00	AAPL	Stock	26.23	26.3175	26.225	26.305	22410740.0
2014-10-24 16:00:00	AAPL	Stock	26.305	26.3225	26.214	26.32	9111808.0
2014-10-24 16:30:00	AAPL	Stock	26.32	26.32	26.2275	26.3075	428236.0
2014-10-24 17:00:00	AAPL	Stock	26.29	26.32	26.29	26.32	64280.0
2014-10-24 17:30:00	AAPL	Stock	26.3125	26.3125	26.2975	26.3	74976.0
2014-10-24 18:00:00	AAPL	Stock	26.3075	26.3125	26.3	26.305	72988.0
2014-10-24 18:30:00	AAPL	Stock	26.3175	26.3175	26.295	26.3075	69568.0
2014-10-24 19:00:00	AAPL	Stock	26.3075	26.31	26.2925	26.31	85652.0
2014-10-24 19:30:00	AAPL	Stock	26.305	26.315	26.3	26.3125	123904.0
2014-10-24 04:00:00	MSFT	Stock	46.45	46.45	46.45	46.45	500.0
2014-10-24 04:30:00	MSFT	Stock	46.45	46.45	46.41	46.45	1300.0
2014-10-24 05:00:00	MSFT	Stock	46.44	46.44	46.39	46.39	1700.0
2014-10-24 05:30:00	MSFT	Stock	46.35	46.39	46.3	46.39	4922.0
2014-10-24 06:00:00	MSFT	Stock	46.42	46.42	46.42	46.42	4000.0
2014-10-24 06:30:00	MSFT	Stock	46.43	46.48	46.37	46.37	3862.0
2014-10-24 07:00:00	MSFT	Stock	46.37	46.48	46.15	46.38	27553.0
2014-10-24 07:30:00	MSFT	Stock	46.37	46.48	46.24	46.25	33144.0
2014-10-24 08:00:00	MSFT	Stock	46.25	46.48	46.15	46.36	199654.0
2014-10-24 08:30:00	MSFT	Stock	46.36	47.4	46.3	47.26	452048.0
2014-10-24 09:00:00	MSFT	Stock	47.28	47.35	46.81	46.82	667544.0
2014-10-24 09:30:00	MSFT	Stock	46.83	46.9	45.41	45.59	16268416.0
2014-10-24 10:00:00	MSFT	Stock	45.59	45.77	45.18	45.72	7792742.0
2014-10-24 10:30:00	MSFT	Stock	45.7	45.91	45.5	45.69	4049301.0
2014-10-24 11:00:00	MSFT	Stock	45.68	45.815	45.44	45.65	3133558.0
2014-10-24 11:30:00	MSFT	Stock	45.645	45.85	45.61	45.735	2121029.0
2014-10-24 12:00:00	MSFT	Stock	45.745	45.96	45.72	45.815	2327048.0
2014-10-24 12:30:00	MSFT	Stock	45.815	45.87	45.71	45.84	2102108.0

> showing 50 of 81,468 rows — these rows as CSV

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