PREVIEW / stock_30min / 2014-07-02

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-02.parquet
  size:    1.6 MB
  rows:    84,038
  symbols: 3,570

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-07-02 05:00:00	AAPL	Stock	23.465	23.465	23.425	23.425	7016.0
2014-07-02 05:30:00	AAPL	Stock	23.4325	23.4325	23.4275	23.4275	2376.0
2014-07-02 06:00:00	AAPL	Stock	23.42	23.4725	23.41	23.4725	15652.0
2014-07-02 06:30:00	AAPL	Stock	23.46	23.46	23.43	23.4375	13600.0
2014-07-02 07:00:00	AAPL	Stock	23.4675	23.485	23.4575	23.475	33120.0
2014-07-02 07:30:00	AAPL	Stock	23.4675	23.475	23.45	23.45	58332.0
2014-07-02 08:00:00	AAPL	Stock	23.45	23.525	23.445	23.485	301044.0
2014-07-02 08:30:00	AAPL	Stock	23.4825	23.4875	23.455	23.455	209076.0
2014-07-02 09:00:00	AAPL	Stock	23.455	23.465	23.4275	23.465	470996.0
2014-07-02 09:30:00	AAPL	Stock	23.4675	23.515	23.4125	23.4575	19351200.0
2014-07-02 10:00:00	AAPL	Stock	23.457	23.4725	23.4125	23.4242	9515208.0
2014-07-02 10:30:00	AAPL	Stock	23.4232	23.45	23.3875	23.4218	8708096.0
2014-07-02 11:00:00	AAPL	Stock	23.4212	23.4325	23.335	23.3575	10668064.0
2014-07-02 11:30:00	AAPL	Stock	23.36	23.4425	23.34	23.425	6407036.0
2014-07-02 12:00:00	AAPL	Stock	23.425	23.435	23.3775	23.39	3536192.0
2014-07-02 12:30:00	AAPL	Stock	23.3917	23.4	23.3475	23.3675	5156292.0
2014-07-02 13:00:00	AAPL	Stock	23.3675	23.407	23.3475	23.3975	4309444.0
2014-07-02 13:30:00	AAPL	Stock	23.3988	23.4	23.355	23.3825	3682512.0
2014-07-02 14:00:00	AAPL	Stock	23.38	23.3875	23.36	23.3725	2793924.0
2014-07-02 14:30:00	AAPL	Stock	23.3718	23.3925	23.3125	23.335	5273328.0
2014-07-02 15:00:00	AAPL	Stock	23.34	23.3525	23.2975	23.3175	5377940.0
2014-07-02 15:30:00	AAPL	Stock	23.32	23.3825	23.2725	23.3675	15391388.0
2014-07-02 16:00:00	AAPL	Stock	23.37	23.41	23.3475	23.37	4475904.0
2014-07-02 16:30:00	AAPL	Stock	23.3475	23.37	23.3475	23.3525	212000.0
2014-07-02 17:00:00	AAPL	Stock	23.355	23.4058	23.3425	23.35	69540.0
2014-07-02 17:30:00	AAPL	Stock	23.355	23.37	23.355	23.37	9888.0
2014-07-02 18:00:00	AAPL	Stock	23.355	23.37	23.355	23.3575	16884.0
2014-07-02 18:30:00	AAPL	Stock	23.3525	23.36	23.3525	23.3525	22000.0
2014-07-02 19:00:00	AAPL	Stock	23.355	23.365	23.3375	23.3425	64728.0
2014-07-02 19:30:00	AAPL	Stock	23.3375	23.3625	23.3375	23.3575	75020.0
2014-07-02 08:00:00	MSFT	Stock	41.75	41.85	41.75	41.85	254.0
2014-07-02 08:30:00	MSFT	Stock	41.85	41.87	41.85	41.86	5477.0
2014-07-02 09:00:00	MSFT	Stock	41.85	41.85	41.71	41.75	14045.0
2014-07-02 09:30:00	MSFT	Stock	41.76	41.76	41.58	41.66	3332171.0
2014-07-02 10:00:00	MSFT	Stock	41.66	41.67	41.56	41.57	2232848.0
2014-07-02 10:30:00	MSFT	Stock	41.56	41.62	41.53	41.56	2146981.0
2014-07-02 11:00:00	MSFT	Stock	41.564	41.66	41.56	41.64	1263925.0
2014-07-02 11:30:00	MSFT	Stock	41.65	41.77	41.65	41.76	823153.0
2014-07-02 12:00:00	MSFT	Stock	41.76	41.83	41.76	41.79	940886.0
2014-07-02 12:30:00	MSFT	Stock	41.79	41.8	41.75	41.795	532805.0
2014-07-02 13:00:00	MSFT	Stock	41.79	41.81	41.71	41.79	628758.0
2014-07-02 13:30:00	MSFT	Stock	41.796	41.8	41.7	41.755	576351.0
2014-07-02 14:00:00	MSFT	Stock	41.76	41.82	41.74	41.82	674310.0
2014-07-02 14:30:00	MSFT	Stock	41.82	41.85	41.765	41.84	963669.0
2014-07-02 15:00:00	MSFT	Stock	41.84	41.87	41.78	41.855	1166115.0
2014-07-02 15:30:00	MSFT	Stock	41.855	41.9	41.83	41.9	1924944.0
2014-07-02 16:00:00	MSFT	Stock	41.9	41.9	41.725	41.9	1981197.0
2014-07-02 16:30:00	MSFT	Stock	41.84	41.9	41.84	41.9	45227.0
2014-07-02 17:00:00	MSFT	Stock	41.605	41.908	41.605	41.908	9686.0
2014-07-02 19:30:00	MSFT	Stock	41.87	41.89	41.87	41.89	314.0

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

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