PREVIEW / stock_30min / 2018-02-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-09.parquet
  size:    1.7 MB
  rows:    87,585
  symbols: 2,906

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
2018-02-09 04:00:00	AAPL	Stock	39.1275	39.225	39.1275	39.2125	40300.0
2018-02-09 04:30:00	AAPL	Stock	39.1225	39.1225	39.07	39.1175	8376.0
2018-02-09 05:00:00	AAPL	Stock	39.1025	39.1025	39.0025	39.0025	8628.0
2018-02-09 05:30:00	AAPL	Stock	39.1175	39.2125	39.1175	39.1675	27200.0
2018-02-09 06:00:00	AAPL	Stock	39.1675	39.1675	38.9825	38.9825	54580.0
2018-02-09 06:30:00	AAPL	Stock	38.9825	39.06	38.8825	39.025	100984.0
2018-02-09 07:00:00	AAPL	Stock	39.03	39.1025	38.8625	38.8625	155116.0
2018-02-09 07:30:00	AAPL	Stock	38.8675	38.9825	38.8325	38.86	86012.0
2018-02-09 08:00:00	AAPL	Stock	38.885	39.1	38.8525	39.0625	226432.0
2018-02-09 08:30:00	AAPL	Stock	39.0625	39.2925	39.03	39.25	346556.0
2018-02-09 09:00:00	AAPL	Stock	39.2525	39.35	39.14	39.1675	439804.0
2018-02-09 09:30:00	AAPL	Stock	39.1675	39.4575	38.9528	39.29	24568536.0
2018-02-09 10:00:00	AAPL	Stock	39.2925	39.4725	39.1825	39.3378	14916660.0
2018-02-09 10:30:00	AAPL	Stock	39.335	39.3525	38.685	38.975	19413868.0
2018-02-09 11:00:00	AAPL	Stock	38.98	39.12	38.7275	38.864	14072676.0
2018-02-09 11:30:00	AAPL	Stock	38.855	39.07	38.715	38.7408	8977108.0
2018-02-09 12:00:00	AAPL	Stock	38.7375	38.8375	38.3975	38.4325	15185556.0
2018-02-09 12:30:00	AAPL	Stock	38.44	38.625	37.8675	38.4835	18241092.0
2018-02-09 13:00:00	AAPL	Stock	38.4825	38.485	37.705	37.8525	14871992.0
2018-02-09 13:30:00	AAPL	Stock	37.8538	38.125	37.56	37.9425	18762840.0
2018-02-09 14:00:00	AAPL	Stock	37.9375	38.8725	37.9	38.4678	18835476.0
2018-02-09 14:30:00	AAPL	Stock	38.47	38.8525	38.4025	38.6825	12585396.0
2018-02-09 15:00:00	AAPL	Stock	38.6875	38.8225	38.365	38.735	12120816.0
2018-02-09 15:30:00	AAPL	Stock	38.7375	39.295	38.6875	39.055	26081780.0
2018-02-09 16:00:00	AAPL	Stock	39.1025	39.1175	38.98	39.04	13173856.0
2018-02-09 16:30:00	AAPL	Stock	39.04	39.1025	39.0375	39.0575	201632.0
2018-02-09 17:00:00	AAPL	Stock	39.0575	39.14	39.0575	39.125	232828.0
2018-02-09 17:30:00	AAPL	Stock	39.155	39.17	39.0975	39.15	92480.0
2018-02-09 18:00:00	AAPL	Stock	39.125	39.18	39.125	39.1525	38080.0
2018-02-09 18:30:00	AAPL	Stock	39.175	39.175	39.14	39.175	19196.0
2018-02-09 19:00:00	AAPL	Stock	39.165	39.1825	39.165	39.175	8396.0
2018-02-09 19:30:00	AAPL	Stock	39.1825	39.185	39.1375	39.185	36168.0
2018-02-09 04:30:00	MSFT	Stock	85.99	86.0	85.99	86.0	1490.0
2018-02-09 05:00:00	MSFT	Stock	85.79	85.79	85.69	85.7	5897.0
2018-02-09 05:30:00	MSFT	Stock	85.99	86.05	85.92	86.04	18541.0
2018-02-09 06:00:00	MSFT	Stock	86.1	86.19	85.94	85.94	19765.0
2018-02-09 06:30:00	MSFT	Stock	85.81	85.94	85.25	85.75	11573.0
2018-02-09 07:00:00	MSFT	Stock	85.77	85.85	85.35	85.35	15201.0
2018-02-09 07:30:00	MSFT	Stock	85.3	85.51	85.17	85.19	9916.0
2018-02-09 08:00:00	MSFT	Stock	85.87	85.87	85.17	85.7	35138.0
2018-02-09 08:30:00	MSFT	Stock	85.64	86.24	85.37	86.2	43277.0
2018-02-09 09:00:00	MSFT	Stock	86.2	86.61	85.84	86.24	51048.0
2018-02-09 09:30:00	MSFT	Stock	86.24	87.28	86.07	86.89	5576352.0
2018-02-09 10:00:00	MSFT	Stock	86.9	87.09	86.15	86.8	2572632.0
2018-02-09 10:30:00	MSFT	Stock	86.8	87.47	86.11	86.89	4030589.0
2018-02-09 11:00:00	MSFT	Stock	86.91	87.595	86.53	86.82	3137159.0
2018-02-09 11:30:00	MSFT	Stock	86.81	87.23	86.345	86.39	2431008.0
2018-02-09 12:00:00	MSFT	Stock	86.39	86.49	85.22	85.22	3778886.0
2018-02-09 12:30:00	MSFT	Stock	85.23	85.63	84.13	85.54	3233911.0
2018-02-09 13:00:00	MSFT	Stock	85.53	85.55	84.08	84.23	2643882.0

> showing 50 of 87,585 rows — these rows as CSV

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