PREVIEW / stock_30min / 2018-08-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-02.parquet
  size:    1.7 MB
  rows:    83,854
  symbols: 2,788

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-08-02 04:00:00	AAPL	Stock	49.975	50.1375	49.975	50.0725	43180.0
2018-08-02 04:30:00	AAPL	Stock	50.0725	50.115	50.0375	50.0375	22256.0
2018-08-02 05:00:00	AAPL	Stock	50.075	50.075	49.97	49.97	50296.0
2018-08-02 05:30:00	AAPL	Stock	49.9625	50.0375	49.9275	49.9975	38944.0
2018-08-02 06:00:00	AAPL	Stock	49.975	50.03	49.9225	49.975	118760.0
2018-08-02 06:30:00	AAPL	Stock	49.98	50.0175	49.9625	49.9925	66276.0
2018-08-02 07:00:00	AAPL	Stock	49.9975	50.115	49.9925	50.065	276320.0
2018-08-02 07:30:00	AAPL	Stock	50.0875	50.1475	50.05	50.125	264980.0
2018-08-02 08:00:00	AAPL	Stock	50.075	50.185	50.015	50.1525	501384.0
2018-08-02 08:30:00	AAPL	Stock	50.1575	50.375	50.1525	50.1575	288840.0
2018-08-02 09:00:00	AAPL	Stock	50.17	50.17	50.0625	50.1575	297184.0
2018-08-02 09:30:00	AAPL	Stock	50.1525	50.8925	50.0875	50.825	29612136.0
2018-08-02 10:00:00	AAPL	Stock	50.825	51.2125	50.715	51.1888	20596288.0
2018-08-02 10:30:00	AAPL	Stock	51.1875	51.645	51.12	51.4775	29566988.0
2018-08-02 11:00:00	AAPL	Stock	51.4775	51.6925	51.2775	51.605	17488456.0
2018-08-02 11:30:00	AAPL	Stock	51.6025	51.7625	51.47	51.6675	20761588.0
2018-08-02 12:00:00	AAPL	Stock	51.6725	51.7475	51.5262	51.6195	13292040.0
2018-08-02 12:30:00	AAPL	Stock	51.6188	51.7325	51.575	51.607	9535312.0
2018-08-02 13:00:00	AAPL	Stock	51.6085	51.815	51.605	51.7	11476080.0
2018-08-02 13:30:00	AAPL	Stock	51.7	51.9925	51.69	51.9775	11983472.0
2018-08-02 14:00:00	AAPL	Stock	51.9775	52.095	51.9075	51.9325	14253416.0
2018-08-02 14:30:00	AAPL	Stock	51.9325	52.075	51.8975	51.935	8303268.0
2018-08-02 15:00:00	AAPL	Stock	51.935	52.0	51.875	51.89	7428800.0
2018-08-02 15:30:00	AAPL	Stock	51.8888	51.9825	51.835	51.845	16518396.0
2018-08-02 16:00:00	AAPL	Stock	51.85	51.8775	51.835	51.86	9159744.0
2018-08-02 16:30:00	AAPL	Stock	51.86	51.88	51.8375	51.8625	201056.0
2018-08-02 17:00:00	AAPL	Stock	51.8725	51.885	51.815	51.825	97568.0
2018-08-02 17:30:00	AAPL	Stock	51.845	51.845	51.7875	51.8175	43936.0
2018-08-02 18:00:00	AAPL	Stock	51.8075	51.8425	51.8	51.8125	62504.0
2018-08-02 18:30:00	AAPL	Stock	51.825	51.835	51.7875	51.815	53316.0
2018-08-02 19:00:00	AAPL	Stock	51.8175	51.8225	51.8	51.815	49672.0
2018-08-02 19:30:00	AAPL	Stock	51.8025	51.82	51.7725	51.7725	83016.0
2018-08-02 04:00:00	MSFT	Stock	105.95	105.95	105.95	105.95	1390.0
2018-08-02 05:00:00	MSFT	Stock	105.65	105.65	105.65	105.65	780.0
2018-08-02 05:30:00	MSFT	Stock	105.28	105.28	105.1	105.1	1897.0
2018-08-02 06:00:00	MSFT	Stock	105.28	105.28	105.13	105.13	1573.0
2018-08-02 06:30:00	MSFT	Stock	105.27	105.27	105.27	105.27	229.0
2018-08-02 07:00:00	MSFT	Stock	105.5	105.64	105.23	105.5	14269.0
2018-08-02 07:30:00	MSFT	Stock	105.31	105.58	105.31	105.32	3446.0
2018-08-02 08:00:00	MSFT	Stock	105.51	105.9	105.23	105.43	14901.0
2018-08-02 08:30:00	MSFT	Stock	105.38	106.28	105.33	105.39	26765.0
2018-08-02 09:00:00	MSFT	Stock	105.36	105.48	105.17	105.33	48924.0
2018-08-02 09:30:00	MSFT	Stock	105.34	105.92	104.84	105.78	2981489.0
2018-08-02 10:00:00	MSFT	Stock	105.775	106.47	105.77	106.24	1822684.0
2018-08-02 10:30:00	MSFT	Stock	106.23	106.51	105.96	105.98	1435453.0
2018-08-02 11:00:00	MSFT	Stock	105.99	106.55	105.91	106.51	1002111.0
2018-08-02 11:30:00	MSFT	Stock	106.51	107.24	106.51	107.03	1924839.0
2018-08-02 12:00:00	MSFT	Stock	107.03	107.5	106.8	107.42	1099300.0
2018-08-02 12:30:00	MSFT	Stock	107.42	107.68	107.295	107.458	1244229.0
2018-08-02 13:00:00	MSFT	Stock	107.46	107.97	107.46	107.93	1152717.0

> showing 50 of 83,854 rows — these rows as CSV

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