PREVIEW / stock_30min / 2018-05-24

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-24.parquet
  size:    1.6 MB
  rows:    82,879
  symbols: 2,825

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-05-24 04:00:00	AAPL	Stock	47.1725	47.2375	47.1725	47.2375	4152.0
2018-05-24 04:30:00	AAPL	Stock	47.225	47.255	47.225	47.225	11180.0
2018-05-24 05:00:00	AAPL	Stock	47.235	47.25	47.235	47.25	5984.0
2018-05-24 05:30:00	AAPL	Stock	47.2	47.2375	47.19	47.2375	17488.0
2018-05-24 06:00:00	AAPL	Stock	47.225	47.2525	47.225	47.25	7028.0
2018-05-24 06:30:00	AAPL	Stock	47.2175	47.2175	47.195	47.2125	21384.0
2018-05-24 07:00:00	AAPL	Stock	47.19	47.2	47.15	47.15	31300.0
2018-05-24 07:30:00	AAPL	Stock	47.165	47.195	47.1275	47.195	94128.0
2018-05-24 08:00:00	AAPL	Stock	47.2	47.21	47.0875	47.0875	157764.0
2018-05-24 08:30:00	AAPL	Stock	47.1075	47.17	47.1	47.1625	85804.0
2018-05-24 09:00:00	AAPL	Stock	47.14	47.215	47.125	47.1875	181784.0
2018-05-24 09:30:00	AAPL	Stock	47.1925	47.21	46.7375	46.7925	11493612.0
2018-05-24 10:00:00	AAPL	Stock	46.7925	46.9625	46.7375	46.79	6388440.0
2018-05-24 10:30:00	AAPL	Stock	46.785	46.8625	46.5525	46.605	7131144.0
2018-05-24 11:00:00	AAPL	Stock	46.6075	46.8175	46.59	46.81	4591628.0
2018-05-24 11:30:00	AAPL	Stock	46.81	46.9075	46.7825	46.9075	3703516.0
2018-05-24 12:00:00	AAPL	Stock	46.905	47.0	46.8825	46.9525	3205732.0
2018-05-24 12:30:00	AAPL	Stock	46.9525	47.0175	46.9375	46.9925	2493052.0
2018-05-24 13:00:00	AAPL	Stock	46.9938	47.1625	46.99	47.16	3241088.0
2018-05-24 13:30:00	AAPL	Stock	47.16	47.1625	47.02	47.055	2984656.0
2018-05-24 14:00:00	AAPL	Stock	47.055	47.135	47.0225	47.1112	2316236.0
2018-05-24 14:30:00	AAPL	Stock	47.1112	47.1175	46.9975	47.0438	2560944.0
2018-05-24 15:00:00	AAPL	Stock	47.0425	47.12	46.9975	47.09	2865080.0
2018-05-24 15:30:00	AAPL	Stock	47.0912	47.1275	46.945	47.0525	7129904.0
2018-05-24 16:00:00	AAPL	Stock	47.0375	47.1125	47.0375	47.075	6178588.0
2018-05-24 16:30:00	AAPL	Stock	47.0513	47.0525	47.0125	47.04	23752.0
2018-05-24 17:00:00	AAPL	Stock	47.05	47.0625	47.0392	47.0392	8652.0
2018-05-24 17:30:00	AAPL	Stock	47.05	47.0875	47.05	47.055	24988.0
2018-05-24 18:00:00	AAPL	Stock	47.06	47.085	47.045	47.085	42380.0
2018-05-24 18:30:00	AAPL	Stock	47.085	47.0875	47.06	47.075	24680.0
2018-05-24 19:00:00	AAPL	Stock	47.0875	47.125	47.0875	47.125	9000.0
2018-05-24 19:30:00	AAPL	Stock	47.1225	47.125	47.1	47.125	12824.0
2018-05-24 04:30:00	MSFT	Stock	98.8	98.8	98.8	98.8	150.0
2018-05-24 05:30:00	MSFT	Stock	98.71	98.71	98.71	98.71	2900.0
2018-05-24 06:30:00	MSFT	Stock	98.7	98.7	98.7	98.7	190.0
2018-05-24 07:00:00	MSFT	Stock	98.66	98.67	98.5	98.5	1660.0
2018-05-24 07:30:00	MSFT	Stock	98.67	98.67	98.67	98.67	200.0
2018-05-24 08:00:00	MSFT	Stock	98.476	98.75	98.476	98.51	5711.0
2018-05-24 08:30:00	MSFT	Stock	98.58	98.67	98.52	98.55	863.0
2018-05-24 09:00:00	MSFT	Stock	98.52	98.88	98.17	98.78	15361.0
2018-05-24 09:30:00	MSFT	Stock	98.71	98.94	97.655	97.86	2808433.0
2018-05-24 10:00:00	MSFT	Stock	97.86	98.09	97.57	97.62	1724292.0
2018-05-24 10:30:00	MSFT	Stock	97.625	97.625	96.9	96.94	1722352.0
2018-05-24 11:00:00	MSFT	Stock	96.94	97.455	96.81	97.44	1519024.0
2018-05-24 11:30:00	MSFT	Stock	97.445	97.787	97.41	97.75	1015567.0
2018-05-24 12:00:00	MSFT	Stock	97.76	98.04	97.63	97.96	1099987.0
2018-05-24 12:30:00	MSFT	Stock	97.97	98.07	97.82	98.02	732468.0
2018-05-24 13:00:00	MSFT	Stock	98.02	98.18	97.965	98.12	901846.0
2018-05-24 13:30:00	MSFT	Stock	98.11	98.13	97.79	97.965	859945.0
2018-05-24 14:00:00	MSFT	Stock	97.96	98.28	97.88	98.25	661988.0

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

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