PREVIEW / stock_30min / 2014-06-30

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-30.parquet
  size:    1.6 MB
  rows:    84,314
  symbols: 3,598

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-06-30 04:00:00	AAPL	Stock	23.0275	23.1025	23.0275	23.1	7384.0
2014-06-30 04:30:00	AAPL	Stock	23.0775	23.0775	23.075	23.075	2972.0
2014-06-30 05:00:00	AAPL	Stock	23.0825	23.09	23.0825	23.09	3680.0
2014-06-30 05:30:00	AAPL	Stock	23.075	23.075	23.0	23.0	16312.0
2014-06-30 06:00:00	AAPL	Stock	23.035	23.0525	23.02	23.04	10320.0
2014-06-30 06:30:00	AAPL	Stock	23.0525	23.055	23.04	23.05	22796.0
2014-06-30 07:00:00	AAPL	Stock	23.05	23.065	23.03	23.0375	42800.0
2014-06-30 07:30:00	AAPL	Stock	23.0425	23.045	23.0275	23.045	29216.0
2014-06-30 08:00:00	AAPL	Stock	23.0375	23.055	22.995	23.055	543664.0
2014-06-30 08:30:00	AAPL	Stock	23.0525	23.065	23.0225	23.03	200336.0
2014-06-30 09:00:00	AAPL	Stock	23.03	23.045	23.0175	23.04	208452.0
2014-06-30 09:30:00	AAPL	Stock	23.0275	23.2075	23.0225	23.1575	28564096.0
2014-06-30 10:00:00	AAPL	Stock	23.1575	23.19	23.09	23.1325	10841136.0
2014-06-30 10:30:00	AAPL	Stock	23.1338	23.1875	23.1	23.1688	10089688.0
2014-06-30 11:00:00	AAPL	Stock	23.1698	23.19	23.14	23.1775	8063160.0
2014-06-30 11:30:00	AAPL	Stock	23.1775	23.2	23.1582	23.1725	8444784.0
2014-06-30 12:00:00	AAPL	Stock	23.1735	23.1975	23.14	23.185	5884084.0
2014-06-30 12:30:00	AAPL	Stock	23.1825	23.1925	23.1575	23.1875	5287568.0
2014-06-30 13:00:00	AAPL	Stock	23.1868	23.2975	23.1825	23.295	13370672.0
2014-06-30 13:30:00	AAPL	Stock	23.2925	23.3375	23.2625	23.3355	9211164.0
2014-06-30 14:00:00	AAPL	Stock	23.3362	23.4275	23.325	23.409	13130512.0
2014-06-30 14:30:00	AAPL	Stock	23.41	23.4312	23.3275	23.33	12704404.0
2014-06-30 15:00:00	AAPL	Stock	23.3288	23.375	23.31	23.3725	10863464.0
2014-06-30 15:30:00	AAPL	Stock	23.37	23.375	23.2325	23.24	24876968.0
2014-06-30 16:00:00	AAPL	Stock	23.24	23.2975	23.232	23.2325	19055844.0
2014-06-30 16:30:00	AAPL	Stock	23.29	23.2975	23.155	23.2975	269232.0
2014-06-30 17:00:00	AAPL	Stock	23.295	23.2975	23.2325	23.29	76800.0
2014-06-30 17:30:00	AAPL	Stock	23.29	23.2925	23.275	23.2825	71052.0
2014-06-30 18:00:00	AAPL	Stock	23.275	23.2875	23.25	23.2725	109132.0
2014-06-30 18:30:00	AAPL	Stock	23.2725	23.2725	23.2325	23.2625	210508.0
2014-06-30 19:00:00	AAPL	Stock	23.2625	23.285	23.26	23.285	24940.0
2014-06-30 19:30:00	AAPL	Stock	23.275	23.2875	23.275	23.28	33240.0
2014-06-30 05:00:00	MSFT	Stock	42.23	42.23	42.23	42.23	500.0
2014-06-30 06:30:00	MSFT	Stock	42.27	42.27	42.27	42.27	200.0
2014-06-30 07:00:00	MSFT	Stock	42.23	42.23	42.18	42.18	1450.0
2014-06-30 07:30:00	MSFT	Stock	42.14	42.14	42.14	42.14	500.0
2014-06-30 08:00:00	MSFT	Stock	42.13	42.22	42.13	42.2	2574.0
2014-06-30 09:00:00	MSFT	Stock	42.19	42.2	42.16	42.19	1650.0
2014-06-30 09:30:00	MSFT	Stock	42.17	42.21	41.94	42.11	4052383.0
2014-06-30 10:00:00	MSFT	Stock	42.1	42.18	41.96	41.99	2304892.0
2014-06-30 10:30:00	MSFT	Stock	41.995	42.06	41.92	41.93	1502085.0
2014-06-30 11:00:00	MSFT	Stock	41.93	42.03	41.91	42.01	1063837.0
2014-06-30 11:30:00	MSFT	Stock	42.02	42.02	41.88	41.88	765656.0
2014-06-30 12:00:00	MSFT	Stock	41.88	42.02	41.88	41.982	1434598.0
2014-06-30 12:30:00	MSFT	Stock	41.985	42.02	41.92	41.925	633622.0
2014-06-30 13:00:00	MSFT	Stock	41.93	41.99	41.92	41.97	1050699.0
2014-06-30 13:30:00	MSFT	Stock	41.975	41.98	41.89	41.9	874321.0
2014-06-30 14:00:00	MSFT	Stock	41.89	41.93	41.89	41.895	832790.0
2014-06-30 14:30:00	MSFT	Stock	41.9	41.9	41.73	41.75	1979218.0
2014-06-30 15:00:00	MSFT	Stock	41.76	41.8	41.72	41.75	1937613.0

> showing 50 of 84,314 rows — these rows as CSV

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