PREVIEW / stock_30min / 2017-06-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-07.parquet
  size:    1.6 MB
  rows:    80,951
  symbols: 3,042

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-06-07 05:00:00	AAPL	Stock	38.6675	38.6875	38.6675	38.685	5000.0
2017-06-07 05:30:00	AAPL	Stock	38.685	38.685	38.685	38.685	820.0
2017-06-07 06:30:00	AAPL	Stock	38.67	38.67	38.67	38.67	800.0
2017-06-07 07:00:00	AAPL	Stock	38.655	38.6975	38.6375	38.6975	18676.0
2017-06-07 07:30:00	AAPL	Stock	38.7	38.7175	38.685	38.7175	18004.0
2017-06-07 08:00:00	AAPL	Stock	38.6875	38.725	38.6875	38.72	80272.0
2017-06-07 08:30:00	AAPL	Stock	38.72	38.7375	38.71	38.735	75084.0
2017-06-07 09:00:00	AAPL	Stock	38.735	38.7525	38.7075	38.75	170336.0
2017-06-07 09:30:00	AAPL	Stock	38.7525	38.95	38.73	38.9212	15474468.0
2017-06-07 10:00:00	AAPL	Stock	38.92	38.995	38.86	38.8912	8348820.0
2017-06-07 10:30:00	AAPL	Stock	38.89	38.9125	38.735	38.8125	6132620.0
2017-06-07 11:00:00	AAPL	Stock	38.8125	38.9075	38.81	38.8342	4196088.0
2017-06-07 11:30:00	AAPL	Stock	38.8325	38.8735	38.8162	38.8638	2998768.0
2017-06-07 12:00:00	AAPL	Stock	38.865	38.8725	38.7575	38.77	3173664.0
2017-06-07 12:30:00	AAPL	Stock	38.77	38.7825	38.62	38.7275	5092732.0
2017-06-07 13:00:00	AAPL	Stock	38.73	38.825	38.7175	38.8192	3621924.0
2017-06-07 13:30:00	AAPL	Stock	38.82	38.83	38.7775	38.805	2266160.0
2017-06-07 14:00:00	AAPL	Stock	38.805	38.8925	38.8	38.8128	3409640.0
2017-06-07 14:30:00	AAPL	Stock	38.8125	38.8625	38.805	38.85	2745008.0
2017-06-07 15:00:00	AAPL	Stock	38.8525	38.8525	38.78	38.82	3639996.0
2017-06-07 15:30:00	AAPL	Stock	38.8175	38.885	38.7975	38.8425	8481136.0
2017-06-07 16:00:00	AAPL	Stock	38.8425	38.8575	38.79	38.8575	6581004.0
2017-06-07 16:30:00	AAPL	Stock	38.8425	38.86	38.825	38.855	207396.0
2017-06-07 17:00:00	AAPL	Stock	38.84	38.85	38.8375	38.8375	4484.0
2017-06-07 17:30:00	AAPL	Stock	38.8375	38.875	38.8375	38.8625	28004.0
2017-06-07 18:00:00	AAPL	Stock	38.8675	38.8725	38.8625	38.8725	24204.0
2017-06-07 18:30:00	AAPL	Stock	38.865	38.8725	38.8625	38.865	12828.0
2017-06-07 19:00:00	AAPL	Stock	38.8625	38.8625	38.8525	38.8525	7200.0
2017-06-07 19:30:00	AAPL	Stock	38.8525	38.8525	38.825	38.8375	41972.0
2017-06-07 06:00:00	MSFT	Stock	72.3	72.31	72.3	72.31	260.0
2017-06-07 08:00:00	MSFT	Stock	72.6	72.6	72.6	72.6	4921.0
2017-06-07 08:30:00	MSFT	Stock	72.65	72.67	72.6	72.67	3346.0
2017-06-07 09:00:00	MSFT	Stock	72.65	72.66	72.65	72.66	1129.0
2017-06-07 09:30:00	MSFT	Stock	72.64	72.77	72.45	72.465	2004743.0
2017-06-07 10:00:00	MSFT	Stock	72.46	72.525	72.04	72.04	2116145.0
2017-06-07 10:30:00	MSFT	Stock	72.05	72.36	72.015	72.35	2038121.0
2017-06-07 11:00:00	MSFT	Stock	72.36	72.545	72.27	72.27	1390986.0
2017-06-07 11:30:00	MSFT	Stock	72.27	72.38	72.23	72.28	641057.0
2017-06-07 12:00:00	MSFT	Stock	72.27	72.276	72.15	72.21	488689.0
2017-06-07 12:30:00	MSFT	Stock	72.21	72.22	71.95	72.07	878921.0
2017-06-07 13:00:00	MSFT	Stock	72.07	72.13	71.96	72.07	843899.0
2017-06-07 13:30:00	MSFT	Stock	72.07	72.3	72.07	72.285	625972.0
2017-06-07 14:00:00	MSFT	Stock	72.288	72.41	72.15	72.17	1279097.0
2017-06-07 14:30:00	MSFT	Stock	72.17	72.28	72.16	72.265	1009515.0
2017-06-07 15:00:00	MSFT	Stock	72.265	72.35	72.22	72.295	877585.0
2017-06-07 15:30:00	MSFT	Stock	72.3	72.48	72.25	72.39	3356282.0
2017-06-07 16:00:00	MSFT	Stock	72.39	72.39	72.31	72.31	2741519.0
2017-06-07 16:30:00	MSFT	Stock	72.38	72.38	72.31	72.37	2272.0
2017-06-07 17:00:00	MSFT	Stock	72.31	72.37	72.31	72.37	200.0
2017-06-07 17:30:00	MSFT	Stock	72.35	72.35	72.35	72.35	400.0

> showing 50 of 80,951 rows — these rows as CSV

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