PREVIEW / stock_30min / 2018-06-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-26.parquet
  size:    1.7 MB
  rows:    82,864
  symbols: 2,823

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-06-26 04:00:00	AAPL	Stock	45.825	45.825	45.825	45.825	600.0
2018-06-26 04:30:00	AAPL	Stock	45.775	45.775	45.775	45.775	3880.0
2018-06-26 05:00:00	AAPL	Stock	45.725	45.755	45.725	45.755	5148.0
2018-06-26 05:30:00	AAPL	Stock	45.6975	45.6975	45.695	45.6975	19976.0
2018-06-26 06:00:00	AAPL	Stock	45.755	45.755	45.655	45.655	7660.0
2018-06-26 06:30:00	AAPL	Stock	45.6675	45.73	45.6675	45.7125	16292.0
2018-06-26 07:00:00	AAPL	Stock	45.6875	45.75	45.6875	45.6875	33928.0
2018-06-26 07:30:00	AAPL	Stock	45.665	45.675	45.635	45.6725	31904.0
2018-06-26 08:00:00	AAPL	Stock	45.75	45.8375	45.6375	45.8375	186664.0
2018-06-26 08:30:00	AAPL	Stock	45.8375	45.9	45.79	45.805	113952.0
2018-06-26 09:00:00	AAPL	Stock	45.8225	45.825	45.64	45.7225	223668.0
2018-06-26 09:30:00	AAPL	Stock	45.7225	46.14	45.635	46.095	13016824.0
2018-06-26 10:00:00	AAPL	Stock	46.095	46.2575	46.065	46.0675	7982436.0
2018-06-26 10:30:00	AAPL	Stock	46.0675	46.25	46.03	46.2025	7727872.0
2018-06-26 11:00:00	AAPL	Stock	46.2	46.305	46.1525	46.2225	5090440.0
2018-06-26 11:30:00	AAPL	Stock	46.2212	46.25	46.115	46.2075	3086184.0
2018-06-26 12:00:00	AAPL	Stock	46.203	46.3325	46.1975	46.2675	3309324.0
2018-06-26 12:30:00	AAPL	Stock	46.2675	46.3725	46.235	46.35	3374532.0
2018-06-26 13:00:00	AAPL	Stock	46.355	46.485	46.335	46.4825	3754624.0
2018-06-26 13:30:00	AAPL	Stock	46.4825	46.6175	46.475	46.6088	4768600.0
2018-06-26 14:00:00	AAPL	Stock	46.61	46.6325	46.36	46.3898	3969820.0
2018-06-26 14:30:00	AAPL	Stock	46.3875	46.515	46.3375	46.355	3305088.0
2018-06-26 15:00:00	AAPL	Stock	46.35	46.38	46.2175	46.2275	3515820.0
2018-06-26 15:30:00	AAPL	Stock	46.2275	46.339	46.0	46.11	12396020.0
2018-06-26 16:00:00	AAPL	Stock	46.1075	46.125	46.0825	46.1075	10318864.0
2018-06-26 16:30:00	AAPL	Stock	46.1125	46.269	46.095	46.095	220448.0
2018-06-26 17:00:00	AAPL	Stock	46.08	46.0975	46.075	46.075	23292.0
2018-06-26 17:30:00	AAPL	Stock	46.0875	46.0875	46.075	46.075	10380.0
2018-06-26 18:00:00	AAPL	Stock	46.0725	46.125	46.0725	46.0875	26332.0
2018-06-26 19:00:00	AAPL	Stock	46.1125	46.125	46.1075	46.1125	61316.0
2018-06-26 19:30:00	AAPL	Stock	46.0775	46.1425	46.0775	46.1425	27192.0
2018-06-26 04:30:00	MSFT	Stock	98.6	98.85	98.6	98.85	992.0
2018-06-26 05:30:00	MSFT	Stock	98.65	98.65	98.65	98.65	1997.0
2018-06-26 07:00:00	MSFT	Stock	98.82	98.99	98.8	98.8	3442.0
2018-06-26 07:30:00	MSFT	Stock	98.98	98.98	98.75	98.75	6610.0
2018-06-26 08:00:00	MSFT	Stock	98.75	99.17	98.7	99.17	13127.0
2018-06-26 08:30:00	MSFT	Stock	99.2	99.5	99.1	99.1	33947.0
2018-06-26 09:00:00	MSFT	Stock	99.09	99.2	98.82	98.84	31619.0
2018-06-26 09:30:00	MSFT	Stock	98.84	99.79	98.75	99.47	3477409.0
2018-06-26 10:00:00	MSFT	Stock	99.48	99.8	99.35	99.51	2015137.0
2018-06-26 10:30:00	MSFT	Stock	99.51	99.585	99.05	99.41	1602022.0
2018-06-26 11:00:00	MSFT	Stock	99.41	99.61	99.27	99.3	1106131.0
2018-06-26 11:30:00	MSFT	Stock	99.31	99.49	99.21	99.44	991594.0
2018-06-26 12:00:00	MSFT	Stock	99.436	99.82	99.42	99.71	1258603.0
2018-06-26 12:30:00	MSFT	Stock	99.72	99.92	99.59	99.85	819185.0
2018-06-26 13:00:00	MSFT	Stock	99.86	100.07	99.8	99.92	820944.0
2018-06-26 13:30:00	MSFT	Stock	99.91	100.08	99.78	99.815	1196975.0
2018-06-26 14:00:00	MSFT	Stock	99.815	99.88	99.451	99.457	906674.0
2018-06-26 14:30:00	MSFT	Stock	99.455	99.69	99.43	99.48	950423.0
2018-06-26 15:00:00	MSFT	Stock	99.48	99.52	99.195	99.31	971438.0

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

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