PREVIEW / stock_30min / 2015-02-25

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-25.parquet
  size:    1.6 MB
  rows:    82,270
  symbols: 3,508

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-02-25 04:00:00	AAPL	Stock	32.9675	33.05	32.9675	33.0375	7520.0
2015-02-25 04:30:00	AAPL	Stock	33.025	33.025	32.995	33.025	6800.0
2015-02-25 05:30:00	AAPL	Stock	32.9875	32.9875	32.9875	32.9875	4180.0
2015-02-25 06:00:00	AAPL	Stock	32.95	32.9525	32.9	32.9125	9200.0
2015-02-25 06:30:00	AAPL	Stock	32.9175	32.94	32.915	32.93	16160.0
2015-02-25 07:00:00	AAPL	Stock	32.935	32.94	32.8775	32.9125	73920.0
2015-02-25 07:30:00	AAPL	Stock	32.9	32.92	32.85	32.8725	101652.0
2015-02-25 08:00:00	AAPL	Stock	32.8725	33.0425	32.8625	32.9775	554664.0
2015-02-25 08:30:00	AAPL	Stock	32.9725	32.98	32.875	32.9125	328376.0
2015-02-25 09:00:00	AAPL	Stock	32.9125	32.95	32.88	32.89	507108.0
2015-02-25 09:30:00	AAPL	Stock	32.89	32.9	32.6325	32.77	38077916.0
2015-02-25 10:00:00	AAPL	Stock	32.76	32.835	32.5725	32.5725	22461396.0
2015-02-25 10:30:00	AAPL	Stock	32.575	32.7475	32.565	32.7225	18529452.0
2015-02-25 11:00:00	AAPL	Stock	32.7225	32.8125	32.6725	32.805	11738704.0
2015-02-25 11:30:00	AAPL	Stock	32.8062	32.815	32.7075	32.7152	8804056.0
2015-02-25 12:00:00	AAPL	Stock	32.7152	32.7567	32.7025	32.715	6025224.0
2015-02-25 12:30:00	AAPL	Stock	32.7175	32.785	32.68	32.741	7144732.0
2015-02-25 13:00:00	AAPL	Stock	32.745	32.7525	32.7125	32.7188	4808236.0
2015-02-25 13:30:00	AAPL	Stock	32.7175	32.7325	32.5675	32.57	13171528.0
2015-02-25 14:00:00	AAPL	Stock	32.57	32.5725	32.425	32.5348	28969788.0
2015-02-25 14:30:00	AAPL	Stock	32.5325	32.5375	32.07	32.2875	47475520.0
2015-02-25 15:00:00	AAPL	Stock	32.2875	32.3325	32.0875	32.095	25346784.0
2015-02-25 15:30:00	AAPL	Stock	32.0928	32.22	32.0375	32.195	37194476.0
2015-02-25 16:00:00	AAPL	Stock	32.1975	32.8572	32.1625	32.175	6033848.0
2015-02-25 16:30:00	AAPL	Stock	32.185	32.6138	32.1525	32.1575	188316.0
2015-02-25 17:00:00	AAPL	Stock	32.1575	32.1975	32.1575	32.1875	989648.0
2015-02-25 17:30:00	AAPL	Stock	32.1875	32.1975	32.1625	32.175	258080.0
2015-02-25 18:00:00	AAPL	Stock	32.175	32.1825	32.1675	32.175	59720.0
2015-02-25 18:30:00	AAPL	Stock	32.1725	32.1775	32.1625	32.165	48464.0
2015-02-25 19:00:00	AAPL	Stock	32.1725	32.1875	32.17	32.185	52312.0
2015-02-25 19:30:00	AAPL	Stock	32.1825	32.1825	32.15	32.16	159164.0
2015-02-25 07:00:00	MSFT	Stock	43.88	43.88	43.88	43.88	1050.0
2015-02-25 07:30:00	MSFT	Stock	43.89	43.89	43.89	43.89	665.0
2015-02-25 08:00:00	MSFT	Stock	43.88	43.9	43.88	43.9	1400.0
2015-02-25 08:30:00	MSFT	Stock	43.88	43.89	43.82	43.86	3162.0
2015-02-25 09:00:00	MSFT	Stock	43.86	44.02	43.82	43.96	40575.0
2015-02-25 09:30:00	MSFT	Stock	43.96	44.09	43.85	43.95	4481242.0
2015-02-25 10:00:00	MSFT	Stock	43.95	44.02	43.92	43.95	1796452.0
2015-02-25 10:30:00	MSFT	Stock	43.96	44.09	43.94	44.06	1496106.0
2015-02-25 11:00:00	MSFT	Stock	44.06	44.08	43.95	44.005	1268384.0
2015-02-25 11:30:00	MSFT	Stock	44.01	44.02	43.95	43.965	1197609.0
2015-02-25 12:00:00	MSFT	Stock	43.965	44.01	43.95	43.965	690573.0
2015-02-25 12:30:00	MSFT	Stock	43.97	43.98	43.91	43.93	1655976.0
2015-02-25 13:00:00	MSFT	Stock	43.93	43.96	43.9	43.94	1467260.0
2015-02-25 13:30:00	MSFT	Stock	43.95	44.01	43.93	43.98	1125599.0
2015-02-25 14:00:00	MSFT	Stock	43.98	43.99	43.9	43.94	1070903.0
2015-02-25 14:30:00	MSFT	Stock	43.94	43.94	43.81	43.865	2813154.0
2015-02-25 15:00:00	MSFT	Stock	43.86	43.87	43.8	43.815	1620599.0
2015-02-25 15:30:00	MSFT	Stock	43.815	43.99	43.8	43.98	4349424.0
2015-02-25 16:00:00	MSFT	Stock	43.98	44.0	43.898	43.99	3132611.0

> showing 50 of 82,270 rows — these rows as CSV

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