PREVIEW / stock_30min / 2014-04-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-28.parquet
  size:    1.6 MB
  rows:    81,750
  symbols: 3,543

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-04-28 04:00:00	AAPL	Stock	20.4286	20.4793	20.4286	20.4793	13440.0
2014-04-28 04:30:00	AAPL	Stock	20.4679	20.4786	20.4679	20.4786	14000.0
2014-04-28 05:00:00	AAPL	Stock	20.475	20.475	20.475	20.475	78176.0
2014-04-28 05:30:00	AAPL	Stock	20.475	20.475	20.4218	20.4339	71008.0
2014-04-28 06:00:00	AAPL	Stock	20.4339	20.4339	20.4339	20.4339	2800.0
2014-04-28 07:00:00	AAPL	Stock	20.4636	20.4768	20.4636	20.4768	172368.0
2014-04-28 07:30:00	AAPL	Stock	20.47	20.4786	20.4554	20.4725	320684.0
2014-04-28 08:00:00	AAPL	Stock	20.4679	20.4746	20.4061	20.4446	1124872.0
2014-04-28 08:30:00	AAPL	Stock	20.4464	20.4564	20.4346	20.4536	623980.0
2014-04-28 09:00:00	AAPL	Stock	20.4536	20.4693	20.4311	20.4554	1315552.0
2014-04-28 09:30:00	AAPL	Stock	20.4571	20.8214	20.4482	20.8021	87766028.0
2014-04-28 10:00:00	AAPL	Stock	20.8068	21.0811	20.7839	20.9821	77143668.0
2014-04-28 10:30:00	AAPL	Stock	20.9829	21.0643	20.9643	21.0271	37954476.0
2014-04-28 11:00:00	AAPL	Stock	21.0279	21.1768	21.0079	21.017	62884752.0
2014-04-28 11:30:00	AAPL	Stock	21.0132	21.0786	20.9089	20.9382	31506608.0
2014-04-28 12:00:00	AAPL	Stock	20.9439	21.0446	20.8857	21.0446	23607304.0
2014-04-28 12:30:00	AAPL	Stock	21.0511	21.0711	21.0079	21.0496	15157520.0
2014-04-28 13:00:00	AAPL	Stock	21.0454	21.0454	20.8432	20.8929	21052528.0
2014-04-28 13:30:00	AAPL	Stock	20.8909	20.905	20.8075	20.8807	20168820.0
2014-04-28 14:00:00	AAPL	Stock	20.8818	20.9643	20.8143	20.9607	19285392.0
2014-04-28 14:30:00	AAPL	Stock	20.9571	21.0314	20.9329	21.0043	17278044.0
2014-04-28 15:00:00	AAPL	Stock	21.0045	21.1721	20.9871	21.1668	33372276.0
2014-04-28 15:30:00	AAPL	Stock	21.165	21.2768	21.1454	21.2168	69561716.0
2014-04-28 16:00:00	AAPL	Stock	21.2245	21.2311	20.9364	21.2121	21801024.0
2014-04-28 16:30:00	AAPL	Stock	21.2054	21.2143	21.0284	21.2107	376572.0
2014-04-28 17:00:00	AAPL	Stock	21.2061	21.2217	21.2007	21.2071	163968.0
2014-04-28 17:30:00	AAPL	Stock	21.2036	21.2311	21.2007	21.2311	335468.0
2014-04-28 18:00:00	AAPL	Stock	21.2254	21.2357	21.2175	21.2357	289128.0
2014-04-28 18:30:00	AAPL	Stock	21.2418	21.25	21.2193	21.2232	298872.0
2014-04-28 19:00:00	AAPL	Stock	21.2314	21.2429	21.2214	21.2429	67956.0
2014-04-28 19:30:00	AAPL	Stock	21.2321	21.2496	21.2321	21.2346	182952.0
2014-04-28 07:00:00	MSFT	Stock	39.98	39.98	39.98	39.98	5000.0
2014-04-28 07:30:00	MSFT	Stock	40.09	40.18	40.09	40.11	1184.0
2014-04-28 08:00:00	MSFT	Stock	40.08	40.14	40.08	40.08	8003.0
2014-04-28 08:30:00	MSFT	Stock	40.05	40.05	40.03	40.03	3451.0
2014-04-28 09:00:00	MSFT	Stock	40.02	40.2	40.0	40.11	50674.0
2014-04-28 09:30:00	MSFT	Stock	40.14	40.83	40.09	40.83	8706800.0
2014-04-28 10:00:00	MSFT	Stock	40.83	41.29	40.74	41.2	6649582.0
2014-04-28 10:30:00	MSFT	Stock	41.2	41.25	41.01	41.055	3208414.0
2014-04-28 11:00:00	MSFT	Stock	41.05	41.07	40.81	40.825	3498650.0
2014-04-28 11:30:00	MSFT	Stock	40.83	40.945	40.76	40.81	2982310.0
2014-04-28 12:00:00	MSFT	Stock	40.8	40.88	40.62	40.857	2672610.0
2014-04-28 12:30:00	MSFT	Stock	40.86	40.9	40.66	40.67	1724875.0
2014-04-28 13:00:00	MSFT	Stock	40.68	40.68	40.495	40.564	2824204.0
2014-04-28 13:30:00	MSFT	Stock	40.56	40.71	40.48	40.595	2824984.0
2014-04-28 14:00:00	MSFT	Stock	40.59	40.8	40.54	40.733	2259921.0
2014-04-28 14:30:00	MSFT	Stock	40.739	40.79	40.6	40.65	1701897.0
2014-04-28 15:00:00	MSFT	Stock	40.65	40.99	40.64	40.91	3018569.0
2014-04-28 15:30:00	MSFT	Stock	40.915	40.98	40.83	40.86	4861337.0
2014-04-28 16:00:00	MSFT	Stock	40.87	40.95	40.792	40.87	1412551.0

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

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