PREVIEW / stock_30min / 2012-04-25

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-25.parquet
  size:    1.4 MB
  rows:    76,914
  symbols: 3,537

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
2012-04-25 04:00:00	AAPL	Stock	21.5643	21.8796	21.5643	21.8786	298060.0
2012-04-25 04:30:00	AAPL	Stock	21.8746	21.8782	21.8393	21.8686	1213856.0
2012-04-25 05:00:00	AAPL	Stock	21.8686	21.8746	21.8468	21.8532	208628.0
2012-04-25 05:30:00	AAPL	Stock	21.8732	21.8746	21.8568	21.8746	143556.0
2012-04-25 06:00:00	AAPL	Stock	21.8661	22.0	21.86	21.9946	353724.0
2012-04-25 06:30:00	AAPL	Stock	21.9821	21.9911	21.8446	21.8571	1488088.0
2012-04-25 07:00:00	AAPL	Stock	21.8486	21.8911	21.7189	21.7629	3840816.0
2012-04-25 07:30:00	AAPL	Stock	21.7407	21.8536	21.7321	21.8304	3238480.0
2012-04-25 08:00:00	AAPL	Stock	21.8325	22.0793	21.7589	22.0475	20061552.0
2012-04-25 08:30:00	AAPL	Stock	22.0536	22.0714	21.8393	21.845	15064084.0
2012-04-25 09:00:00	AAPL	Stock	21.8554	21.9904	21.7946	21.9818	21252868.0
2012-04-25 09:30:00	AAPL	Stock	21.987	22.0714	21.6543	22.0471	287941864.0
2012-04-25 10:00:00	AAPL	Stock	22.045	22.0661	21.8332	21.8973	101050628.0
2012-04-25 10:30:00	AAPL	Stock	21.8996	21.9279	21.6964	21.8031	84933492.0
2012-04-25 11:00:00	AAPL	Stock	21.8011	21.8664	21.7693	21.8404	41791904.0
2012-04-25 11:30:00	AAPL	Stock	21.8368	21.8518	21.7857	21.8096	26195764.0
2012-04-25 12:00:00	AAPL	Stock	21.8116	21.8193	21.7261	21.7657	30088772.0
2012-04-25 12:30:00	AAPL	Stock	21.7656	21.7975	21.6571	21.7589	51935940.0
2012-04-25 13:00:00	AAPL	Stock	21.7589	21.8346	21.6989	21.7843	32868584.0
2012-04-25 13:30:00	AAPL	Stock	21.7811	21.8571	21.7786	21.7857	27309968.0
2012-04-25 14:00:00	AAPL	Stock	21.7857	21.8246	21.7418	21.7969	25342772.0
2012-04-25 14:30:00	AAPL	Stock	21.7996	21.8064	21.7357	21.7818	20012944.0
2012-04-25 15:00:00	AAPL	Stock	21.7836	21.84	21.7521	21.7857	27089552.0
2012-04-25 15:30:00	AAPL	Stock	21.7866	21.8125	21.7546	21.78	53159792.0
2012-04-25 16:00:00	AAPL	Stock	21.78	22.0232	21.7761	21.8036	15230096.0
2012-04-25 16:30:00	AAPL	Stock	21.8021	21.8699	21.7857	21.8036	828772.0
2012-04-25 17:00:00	AAPL	Stock	21.8061	21.8186	21.8043	21.8179	187684.0
2012-04-25 17:30:00	AAPL	Stock	21.8179	21.8393	21.8179	21.8271	1086260.0
2012-04-25 18:00:00	AAPL	Stock	21.8282	21.8282	21.8125	21.8161	306656.0
2012-04-25 18:30:00	AAPL	Stock	21.8207	21.8264	21.8204	21.8214	156660.0
2012-04-25 19:00:00	AAPL	Stock	21.8243	21.8454	21.8214	21.845	290920.0
2012-04-25 19:30:00	AAPL	Stock	21.8432	21.8432	21.8075	21.8114	413392.0
2012-04-25 05:00:00	MSFT	Stock	31.96	32.05	31.96	32.05	1300.0
2012-04-25 06:00:00	MSFT	Stock	32.1	32.2	32.1	32.2	2200.0
2012-04-25 06:30:00	MSFT	Stock	32.15	32.15	32.11	32.11	3400.0
2012-04-25 07:00:00	MSFT	Stock	32.15	32.15	32.05	32.06	4400.0
2012-04-25 07:30:00	MSFT	Stock	32.06	32.06	32.05	32.05	5800.0
2012-04-25 08:00:00	MSFT	Stock	32.05	32.05	31.95	31.95	30734.0
2012-04-25 08:30:00	MSFT	Stock	31.95	31.96	31.91	31.92	30996.0
2012-04-25 09:00:00	MSFT	Stock	31.92	31.98	31.88	31.97	124095.0
2012-04-25 09:30:00	MSFT	Stock	31.96	32.18	31.87	32.135	7905715.0
2012-04-25 10:00:00	MSFT	Stock	32.14	32.18	32.09	32.139	3338823.0
2012-04-25 10:30:00	MSFT	Stock	32.135	32.135	32.065	32.11	4076969.0
2012-04-25 11:00:00	MSFT	Stock	32.11	32.17	32.08	32.155	3517511.0
2012-04-25 11:30:00	MSFT	Stock	32.155	32.18	32.13	32.145	1792535.0
2012-04-25 12:00:00	MSFT	Stock	32.145	32.24	32.14	32.225	2028229.0
2012-04-25 12:30:00	MSFT	Stock	32.23	32.27	32.17	32.245	3419282.0
2012-04-25 13:00:00	MSFT	Stock	32.245	32.32	32.22	32.255	3477550.0
2012-04-25 13:30:00	MSFT	Stock	32.255	32.285	32.18	32.205	2017232.0
2012-04-25 14:00:00	MSFT	Stock	32.2	32.24	32.09	32.19	3501892.0

> showing 50 of 76,914 rows — these rows as CSV

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