PREVIEW / stock_30min / 2017-03-02

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-02.parquet
  size:    1.6 MB
  rows:    82,174
  symbols: 3,093

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
2017-03-02 04:00:00	AAPL	Stock	35.0	35.0	34.9475	34.9625	3872.0
2017-03-02 04:30:00	AAPL	Stock	34.9375	34.9375	34.89	34.89	1056.0
2017-03-02 05:00:00	AAPL	Stock	34.8875	34.95	34.8875	34.95	1888.0
2017-03-02 05:30:00	AAPL	Stock	34.9675	34.975	34.95	34.95	3364.0
2017-03-02 06:00:00	AAPL	Stock	34.92	34.9575	34.92	34.95	16012.0
2017-03-02 06:30:00	AAPL	Stock	34.9075	34.95	34.9075	34.95	3292.0
2017-03-02 07:00:00	AAPL	Stock	34.9575	34.9975	34.955	34.995	22300.0
2017-03-02 07:30:00	AAPL	Stock	34.9875	34.995	34.9775	34.9875	14092.0
2017-03-02 08:00:00	AAPL	Stock	34.9875	35.02	34.95	35.005	183404.0
2017-03-02 08:30:00	AAPL	Stock	35.005	35.01	34.975	35.0	217220.0
2017-03-02 09:00:00	AAPL	Stock	35.0025	35.0025	34.955	34.9875	129048.0
2017-03-02 09:30:00	AAPL	Stock	34.9925	35.0698	34.9075	34.97	17895340.0
2017-03-02 10:00:00	AAPL	Stock	34.97	34.975	34.9025	34.9688	5984548.0
2017-03-02 10:30:00	AAPL	Stock	34.965	34.9698	34.9195	34.925	4597116.0
2017-03-02 11:00:00	AAPL	Stock	34.92	34.925	34.8075	34.89	7738020.0
2017-03-02 11:30:00	AAPL	Stock	34.89	34.9	34.84	34.9	4912868.0
2017-03-02 12:00:00	AAPL	Stock	34.9	34.9325	34.845	34.8612	4636668.0
2017-03-02 12:30:00	AAPL	Stock	34.86	34.905	34.835	34.905	2917036.0
2017-03-02 13:00:00	AAPL	Stock	34.903	34.9075	34.7775	34.7962	7416880.0
2017-03-02 13:30:00	AAPL	Stock	34.795	34.8043	34.7118	34.7638	6169656.0
2017-03-02 14:00:00	AAPL	Stock	34.765	34.8125	34.7525	34.7912	3607764.0
2017-03-02 14:30:00	AAPL	Stock	34.7925	34.815	34.7675	34.785	3312240.0
2017-03-02 15:00:00	AAPL	Stock	34.785	34.7925	34.7	34.74	4736756.0
2017-03-02 15:30:00	AAPL	Stock	34.7425	34.7675	34.69	34.7325	11905428.0
2017-03-02 16:00:00	AAPL	Stock	34.74	34.775	34.6525	34.75	9671788.0
2017-03-02 16:30:00	AAPL	Stock	34.74	34.7525	34.74	34.7525	56016.0
2017-03-02 17:00:00	AAPL	Stock	34.75	34.7675	34.75	34.7525	6148.0
2017-03-02 17:30:00	AAPL	Stock	34.7525	34.765	34.75	34.76	15388.0
2017-03-02 18:00:00	AAPL	Stock	34.7525	34.7675	34.7525	34.765	26780.0
2017-03-02 18:30:00	AAPL	Stock	34.765	34.77	34.745	34.75	14148.0
2017-03-02 19:00:00	AAPL	Stock	34.745	34.775	34.7425	34.745	8580.0
2017-03-02 19:30:00	AAPL	Stock	34.745	34.775	34.745	34.75	5324.0
2017-03-02 06:30:00	MSFT	Stock	64.93	64.93	64.93	64.93	150.0
2017-03-02 08:00:00	MSFT	Stock	64.8	64.8	64.75	64.75	312.0
2017-03-02 08:30:00	MSFT	Stock	64.77	64.9	64.77	64.86	800.0
2017-03-02 09:00:00	MSFT	Stock	64.77	64.79	64.67	64.69	44809.0
2017-03-02 09:30:00	MSFT	Stock	64.69	64.75	64.17	64.245	2913170.0
2017-03-02 10:00:00	MSFT	Stock	64.245	64.246	64.02	64.05	2170385.0
2017-03-02 10:30:00	MSFT	Stock	64.05	64.15	64.03	64.15	1492360.0
2017-03-02 11:00:00	MSFT	Stock	64.15	64.2	64.05	64.085	1432713.0
2017-03-02 11:30:00	MSFT	Stock	64.08	64.14	63.99	64.132	1288885.0
2017-03-02 12:00:00	MSFT	Stock	64.13	64.14	63.96	63.995	881634.0
2017-03-02 12:30:00	MSFT	Stock	63.995	64.03	63.97	63.98	1076768.0
2017-03-02 13:00:00	MSFT	Stock	63.98	64.02	63.88	63.99	1307903.0
2017-03-02 13:30:00	MSFT	Stock	63.995	64.02	63.97	64.005	864012.0
2017-03-02 14:00:00	MSFT	Stock	64.01	64.075	64.0	64.069	1194492.0
2017-03-02 14:30:00	MSFT	Stock	64.06	64.15	64.06	64.08	1057297.0
2017-03-02 15:00:00	MSFT	Stock	64.085	64.09	63.96	63.965	1121987.0
2017-03-02 15:30:00	MSFT	Stock	63.96	64.04	63.9	64.0	4056505.0
2017-03-02 16:00:00	MSFT	Stock	64.01	64.01	63.94	63.98	2415676.0

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

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