PREVIEW / stock_30min / 2014-10-09

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-09.parquet
  size:    1.6 MB
  rows:    83,755
  symbols: 3,545

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-09 04:00:00	AAPL	Stock	25.235	25.2825	25.225	25.28	16948.0
2014-10-09 04:30:00	AAPL	Stock	25.275	25.275	25.2625	25.2625	8008.0
2014-10-09 05:00:00	AAPL	Stock	25.23	25.2375	25.21	25.21	12200.0
2014-10-09 05:30:00	AAPL	Stock	25.225	25.225	25.225	25.225	2000.0
2014-10-09 06:00:00	AAPL	Stock	25.255	25.275	25.255	25.2625	8632.0
2014-10-09 06:30:00	AAPL	Stock	25.2375	25.3775	25.2375	25.3025	138624.0
2014-10-09 07:00:00	AAPL	Stock	25.355	25.3575	25.27	25.28	221732.0
2014-10-09 07:30:00	AAPL	Stock	25.2725	25.2975	25.13	25.1675	317224.0
2014-10-09 08:00:00	AAPL	Stock	25.175	25.33	25.125	25.21	389464.0
2014-10-09 08:30:00	AAPL	Stock	25.215	25.47	25.2125	25.425	4707176.0
2014-10-09 09:00:00	AAPL	Stock	25.425	25.4325	25.3325	25.3925	2058776.0
2014-10-09 09:30:00	AAPL	Stock	25.4	25.4925	25.32	25.44	40673772.0
2014-10-09 10:00:00	AAPL	Stock	25.4412	25.47	25.3275	25.4175	20944904.0
2014-10-09 10:30:00	AAPL	Stock	25.4175	25.445	25.355	25.4425	17292256.0
2014-10-09 11:00:00	AAPL	Stock	25.44	25.595	25.415	25.565	28382388.0
2014-10-09 11:30:00	AAPL	Stock	25.5675	25.5775	25.38	25.4278	24548436.0
2014-10-09 12:00:00	AAPL	Stock	25.4225	25.47	25.2825	25.3075	24996716.0
2014-10-09 12:30:00	AAPL	Stock	25.3075	25.3675	25.24	25.3565	17280264.0
2014-10-09 13:00:00	AAPL	Stock	25.3575	25.36	25.2	25.2478	16617684.0
2014-10-09 13:30:00	AAPL	Stock	25.2475	25.35	25.1525	25.2025	15231220.0
2014-10-09 14:00:00	AAPL	Stock	25.2025	25.2575	25.165	25.2185	12499500.0
2014-10-09 14:30:00	AAPL	Stock	25.22	25.3275	25.1962	25.265	13077796.0
2014-10-09 15:00:00	AAPL	Stock	25.2642	25.34	25.2525	25.3252	13876840.0
2014-10-09 15:30:00	AAPL	Stock	25.3275	25.4025	25.255	25.255	26349588.0
2014-10-09 16:00:00	AAPL	Stock	25.255	25.468	25.2475	25.2475	8308236.0
2014-10-09 16:30:00	AAPL	Stock	25.25	25.3735	25.13	25.1725	473048.0
2014-10-09 17:00:00	AAPL	Stock	25.255	25.3588	25.13	25.1825	1226016.0
2014-10-09 17:30:00	AAPL	Stock	25.1925	25.205	25.175	25.195	36620.0
2014-10-09 18:00:00	AAPL	Stock	25.1825	25.2125	25.1625	25.2125	86880.0
2014-10-09 18:30:00	AAPL	Stock	25.2125	25.22	25.195	25.1975	43548.0
2014-10-09 19:00:00	AAPL	Stock	25.1925	25.1925	25.185	25.1875	85436.0
2014-10-09 19:30:00	AAPL	Stock	25.1875	25.255	25.185	25.1875	94648.0
2014-10-09 04:00:00	MSFT	Stock	46.84	46.84	46.84	46.84	200.0
2014-10-09 06:00:00	MSFT	Stock	46.8	46.8	46.8	46.8	600.0
2014-10-09 07:00:00	MSFT	Stock	46.63	46.63	46.63	46.63	1900.0
2014-10-09 07:30:00	MSFT	Stock	46.63	46.63	46.61	46.61	1224.0
2014-10-09 08:00:00	MSFT	Stock	46.6	46.61	46.6	46.61	2900.0
2014-10-09 08:30:00	MSFT	Stock	46.65	46.65	46.57	46.57	4509.0
2014-10-09 09:00:00	MSFT	Stock	46.57	46.59	46.49	46.52	22119.0
2014-10-09 09:30:00	MSFT	Stock	46.49	46.8	46.49	46.59	2826446.0
2014-10-09 10:00:00	MSFT	Stock	46.595	46.66	46.49	46.56	1609523.0
2014-10-09 10:30:00	MSFT	Stock	46.57	46.6	46.37	46.6	1507229.0
2014-10-09 11:00:00	MSFT	Stock	46.6	46.79	46.563	46.66	1411765.0
2014-10-09 11:30:00	MSFT	Stock	46.67	46.67	46.225	46.31	2080882.0
2014-10-09 12:00:00	MSFT	Stock	46.3	46.35	46.04	46.13	2277180.0
2014-10-09 12:30:00	MSFT	Stock	46.13	46.145	45.97	46.045	1649056.0
2014-10-09 13:00:00	MSFT	Stock	46.05	46.06	45.78	45.89	2010731.0
2014-10-09 13:30:00	MSFT	Stock	45.89	46.04	45.78	45.86	1748141.0
2014-10-09 14:00:00	MSFT	Stock	45.86	45.94	45.74	45.92	2635803.0
2014-10-09 14:30:00	MSFT	Stock	45.91	46.025	45.8	45.9	2254215.0

> showing 50 of 83,755 rows — these rows as CSV

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