PREVIEW / stock_30min / 2015-06-29

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-29.parquet
  size:    1.6 MB
  rows:    85,233
  symbols: 3,516

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
2015-06-29 04:00:00	AAPL	Stock	31.125	31.2775	31.125	31.2625	137144.0
2015-06-29 04:30:00	AAPL	Stock	31.2625	31.3425	31.2625	31.3	52564.0
2015-06-29 05:00:00	AAPL	Stock	31.34	31.345	31.2875	31.3	33336.0
2015-06-29 05:30:00	AAPL	Stock	31.315	31.33	31.2875	31.295	23820.0
2015-06-29 06:00:00	AAPL	Stock	31.2625	31.2825	31.215	31.225	59652.0
2015-06-29 06:30:00	AAPL	Stock	31.2375	31.325	31.2125	31.315	118132.0
2015-06-29 07:00:00	AAPL	Stock	31.33	31.3625	31.3	31.3125	190632.0
2015-06-29 07:30:00	AAPL	Stock	31.3125	31.4125	31.3125	31.4125	249904.0
2015-06-29 08:00:00	AAPL	Stock	31.405	31.485	31.23	31.345	874760.0
2015-06-29 08:30:00	AAPL	Stock	31.3375	31.3425	31.2825	31.2875	399308.0
2015-06-29 09:00:00	AAPL	Stock	31.285	31.38	31.2825	31.38	624128.0
2015-06-29 09:30:00	AAPL	Stock	31.365	31.6175	31.295	31.5375	33213952.0
2015-06-29 10:00:00	AAPL	Stock	31.5375	31.61	31.4625	31.47	14371036.0
2015-06-29 10:30:00	AAPL	Stock	31.4688	31.5425	31.4225	31.4335	12394216.0
2015-06-29 11:00:00	AAPL	Stock	31.435	31.4725	31.4025	31.445	8383608.0
2015-06-29 11:30:00	AAPL	Stock	31.4475	31.4575	31.3575	31.4252	8360092.0
2015-06-29 12:00:00	AAPL	Stock	31.425	31.4475	31.3675	31.3875	5751180.0
2015-06-29 12:30:00	AAPL	Stock	31.39	31.4225	31.3475	31.375	5339948.0
2015-06-29 13:00:00	AAPL	Stock	31.3725	31.3975	31.31	31.3638	7121776.0
2015-06-29 13:30:00	AAPL	Stock	31.3625	31.4	31.3125	31.3445	6049780.0
2015-06-29 14:00:00	AAPL	Stock	31.345	31.3525	31.275	31.285	7451492.0
2015-06-29 14:30:00	AAPL	Stock	31.2872	31.3525	31.225	31.2288	15199800.0
2015-06-29 15:00:00	AAPL	Stock	31.2285	31.2725	31.1925	31.205	14419256.0
2015-06-29 15:30:00	AAPL	Stock	31.205	31.2475	31.12	31.145	25030152.0
2015-06-29 16:00:00	AAPL	Stock	31.1325	31.3408	31.13	31.1825	6936752.0
2015-06-29 16:30:00	AAPL	Stock	31.1775	31.19	31.1325	31.18	149352.0
2015-06-29 17:00:00	AAPL	Stock	31.1775	31.1875	31.16	31.17	92928.0
2015-06-29 17:30:00	AAPL	Stock	31.17	31.185	31.1625	31.17	64120.0
2015-06-29 18:00:00	AAPL	Stock	31.17	31.1875	31.1325	31.1325	133308.0
2015-06-29 18:30:00	AAPL	Stock	31.1525	31.1625	31.15	31.15	62388.0
2015-06-29 19:00:00	AAPL	Stock	31.16	31.17	31.125	31.17	80000.0
2015-06-29 19:30:00	AAPL	Stock	31.17	31.2	31.1525	31.2	76752.0
2015-06-29 04:00:00	MSFT	Stock	45.05	45.05	44.9	44.9	2400.0
2015-06-29 05:00:00	MSFT	Stock	44.89	44.89	44.82	44.85	3314.0
2015-06-29 05:30:00	MSFT	Stock	44.81	44.88	44.8	44.88	2980.0
2015-06-29 06:00:00	MSFT	Stock	44.81	44.84	44.74	44.74	5600.0
2015-06-29 06:30:00	MSFT	Stock	44.73	44.79	44.7	44.79	3800.0
2015-06-29 07:00:00	MSFT	Stock	44.78	44.78	44.73	44.74	3700.0
2015-06-29 07:30:00	MSFT	Stock	44.76	44.85	44.76	44.81	1500.0
2015-06-29 08:00:00	MSFT	Stock	44.85	44.99	44.75	44.75	18108.0
2015-06-29 08:30:00	MSFT	Stock	44.79	44.79	44.75	44.79	4215.0
2015-06-29 09:00:00	MSFT	Stock	44.8	45.04	44.8	45.03	45954.0
2015-06-29 09:30:00	MSFT	Stock	45.04	45.23	44.82	44.975	4263720.0
2015-06-29 10:00:00	MSFT	Stock	44.975	45.15	44.93	44.94	2446398.0
2015-06-29 10:30:00	MSFT	Stock	44.94	45.065	44.9	44.97	1879664.0
2015-06-29 11:00:00	MSFT	Stock	44.98	44.99	44.84	44.91	2258263.0
2015-06-29 11:30:00	MSFT	Stock	44.91	44.92	44.78	44.815	1389678.0
2015-06-29 12:00:00	MSFT	Stock	44.815	44.88	44.77	44.82	1158607.0
2015-06-29 12:30:00	MSFT	Stock	44.82	44.865	44.75	44.86	1114475.0
2015-06-29 13:00:00	MSFT	Stock	44.85	44.855	44.66	44.75	1624458.0

> showing 50 of 85,233 rows — these rows as CSV

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