PREVIEW / stock_30min / 2014-12-23

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-23.parquet
  size:    1.6 MB
  rows:    84,012
  symbols: 3,569

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-12-23 06:00:00	AAPL	Stock	28.1875	28.2125	28.1875	28.2125	3200.0
2014-12-23 06:30:00	AAPL	Stock	28.2125	28.2125	28.2125	28.2125	1200.0
2014-12-23 07:00:00	AAPL	Stock	28.2275	28.27	28.225	28.27	75380.0
2014-12-23 07:30:00	AAPL	Stock	28.2725	28.3625	28.2575	28.27	53544.0
2014-12-23 08:00:00	AAPL	Stock	28.275	28.2975	28.25	28.265	220408.0
2014-12-23 08:30:00	AAPL	Stock	28.2825	28.325	28.275	28.325	292916.0
2014-12-23 09:00:00	AAPL	Stock	28.325	28.3525	28.3025	28.3225	292944.0
2014-12-23 09:30:00	AAPL	Stock	28.3125	28.3325	28.13	28.1775	18723956.0
2014-12-23 10:00:00	AAPL	Stock	28.175	28.275	28.1525	28.2475	11103208.0
2014-12-23 10:30:00	AAPL	Stock	28.2475	28.25	28.1875	28.2175	7309844.0
2014-12-23 11:00:00	AAPL	Stock	28.2152	28.225	28.165	28.1925	6585188.0
2014-12-23 11:30:00	AAPL	Stock	28.1925	28.21	28.1625	28.1778	4165696.0
2014-12-23 12:00:00	AAPL	Stock	28.1788	28.2	28.1675	28.1775	4040120.0
2014-12-23 12:30:00	AAPL	Stock	28.175	28.185	28.13	28.1475	3995268.0
2014-12-23 13:00:00	AAPL	Stock	28.1475	28.18	28.115	28.175	4577344.0
2014-12-23 13:30:00	AAPL	Stock	28.175	28.18	28.14	28.149	4745016.0
2014-12-23 14:00:00	AAPL	Stock	28.1485	28.1888	28.1475	28.1825	3983624.0
2014-12-23 14:30:00	AAPL	Stock	28.1825	28.225	28.1825	28.1975	4824044.0
2014-12-23 15:00:00	AAPL	Stock	28.1975	28.2225	28.1575	28.17	4612380.0
2014-12-23 15:30:00	AAPL	Stock	28.1712	28.1925	28.13	28.135	8735476.0
2014-12-23 16:00:00	AAPL	Stock	28.135	28.1965	28.1275	28.135	8876720.0
2014-12-23 16:30:00	AAPL	Stock	28.1375	28.1425	28.1275	28.135	21596.0
2014-12-23 17:00:00	AAPL	Stock	28.135	28.145	28.135	28.14	91460.0
2014-12-23 17:30:00	AAPL	Stock	28.145	28.145	28.13	28.135	9400.0
2014-12-23 18:00:00	AAPL	Stock	28.13	28.135	28.12	28.1275	44072.0
2014-12-23 18:30:00	AAPL	Stock	28.1275	28.1275	28.11	28.125	10996.0
2014-12-23 19:00:00	AAPL	Stock	28.115	28.135	28.115	28.135	24272.0
2014-12-23 19:30:00	AAPL	Stock	28.1375	28.145	28.125	28.145	53508.0
2014-12-23 06:00:00	MSFT	Stock	47.95	47.95	47.95	47.95	1100.0
2014-12-23 07:30:00	MSFT	Stock	47.93	47.93	47.93	47.93	800.0
2014-12-23 08:00:00	MSFT	Stock	47.9	47.9	47.9	47.9	625.0
2014-12-23 08:30:00	MSFT	Stock	48.0	48.12	47.86	48.12	4010.0
2014-12-23 09:00:00	MSFT	Stock	48.11	48.44	48.11	48.37	28785.0
2014-12-23 09:30:00	MSFT	Stock	48.37	48.5	48.13	48.481	3062455.0
2014-12-23 10:00:00	MSFT	Stock	48.49	48.66	48.41	48.57	2822848.0
2014-12-23 10:30:00	MSFT	Stock	48.57	48.65	48.5	48.611	2047667.0
2014-12-23 11:00:00	MSFT	Stock	48.62	48.76	48.6	48.724	1213839.0
2014-12-23 11:30:00	MSFT	Stock	48.72	48.8	48.7	48.71	1009496.0
2014-12-23 12:00:00	MSFT	Stock	48.71	48.74	48.64	48.657	1059052.0
2014-12-23 12:30:00	MSFT	Stock	48.65	48.665	48.55	48.56	1024662.0
2014-12-23 13:00:00	MSFT	Stock	48.56	48.71	48.56	48.705	850659.0
2014-12-23 13:30:00	MSFT	Stock	48.705	48.8	48.66	48.66	838796.0
2014-12-23 14:00:00	MSFT	Stock	48.67	48.69	48.584	48.67	727155.0
2014-12-23 14:30:00	MSFT	Stock	48.67	48.71	48.55	48.56	939720.0
2014-12-23 15:00:00	MSFT	Stock	48.555	48.62	48.5	48.51	1006347.0
2014-12-23 15:30:00	MSFT	Stock	48.505	48.56	48.42	48.44	2798787.0
2014-12-23 16:00:00	MSFT	Stock	48.45	48.594	48.42	48.45	3442703.0
2014-12-23 16:30:00	MSFT	Stock	48.46	48.69	48.43	48.69	401.0
2014-12-23 17:00:00	MSFT	Stock	48.45	48.47	48.42	48.47	5980.0
2014-12-23 17:30:00	MSFT	Stock	48.42	48.42	48.42	48.42	500.0

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

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