PREVIEW / stock_30min / 2018-04-30

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-30.parquet
  size:    1.6 MB
  rows:    81,858
  symbols: 2,862

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-04-30 04:00:00	AAPL	Stock	40.675	40.75	40.675	40.7275	11884.0
2018-04-30 04:30:00	AAPL	Stock	40.775	40.8125	40.7725	40.7725	3292.0
2018-04-30 05:00:00	AAPL	Stock	40.775	40.7875	40.75	40.75	11128.0
2018-04-30 05:30:00	AAPL	Stock	40.7875	40.7875	40.7875	40.7875	1200.0
2018-04-30 06:30:00	AAPL	Stock	40.815	40.815	40.8	40.8	2000.0
2018-04-30 07:00:00	AAPL	Stock	40.76	40.825	40.7375	40.75	67052.0
2018-04-30 07:30:00	AAPL	Stock	40.73	40.8	40.7	40.7375	70684.0
2018-04-30 08:00:00	AAPL	Stock	40.7875	40.8225	40.6875	40.775	236256.0
2018-04-30 08:30:00	AAPL	Stock	40.7625	40.775	40.575	40.64	399232.0
2018-04-30 09:00:00	AAPL	Stock	40.625	40.65	40.475	40.5375	388940.0
2018-04-30 09:30:00	AAPL	Stock	40.5275	41.76	40.46	41.5625	34317352.0
2018-04-30 10:00:00	AAPL	Stock	41.56	41.815	41.49	41.66	16727616.0
2018-04-30 10:30:00	AAPL	Stock	41.6595	41.732	41.4725	41.55	8405996.0
2018-04-30 11:00:00	AAPL	Stock	41.5525	41.6025	41.4275	41.4812	6416372.0
2018-04-30 11:30:00	AAPL	Stock	41.48	41.5238	41.2575	41.375	7802080.0
2018-04-30 12:00:00	AAPL	Stock	41.3825	41.415	41.2075	41.4065	6022344.0
2018-04-30 12:30:00	AAPL	Stock	41.405	41.41	41.1775	41.31	4785896.0
2018-04-30 13:00:00	AAPL	Stock	41.31	41.335	41.1	41.185	5677480.0
2018-04-30 13:30:00	AAPL	Stock	41.1835	41.3775	41.1712	41.3625	4415132.0
2018-04-30 14:00:00	AAPL	Stock	41.3598	41.3625	41.1125	41.2775	6086120.0
2018-04-30 14:30:00	AAPL	Stock	41.2775	41.3	41.1775	41.1775	5235176.0
2018-04-30 15:00:00	AAPL	Stock	41.1752	41.3925	41.16	41.285	7859332.0
2018-04-30 15:30:00	AAPL	Stock	41.2825	41.4975	41.2675	41.315	14048588.0
2018-04-30 16:00:00	AAPL	Stock	41.315	41.4	41.2175	41.36	13719392.0
2018-04-30 16:30:00	AAPL	Stock	41.375	41.395	41.315	41.315	88756.0
2018-04-30 17:00:00	AAPL	Stock	41.3375	41.5125	41.3275	41.4625	230888.0
2018-04-30 17:30:00	AAPL	Stock	41.45	41.49	41.315	41.4575	1165680.0
2018-04-30 18:00:00	AAPL	Stock	41.465	41.4725	41.4225	41.425	59016.0
2018-04-30 18:30:00	AAPL	Stock	41.43	41.4625	41.4125	41.445	91804.0
2018-04-30 19:00:00	AAPL	Stock	41.4375	41.65	41.4375	41.48	44884.0
2018-04-30 19:30:00	AAPL	Stock	41.475	41.5625	41.46	41.5375	108852.0
2018-04-30 04:30:00	MSFT	Stock	96.6	96.75	96.6	96.75	1100.0
2018-04-30 05:00:00	MSFT	Stock	96.4	96.4	96.4	96.4	215.0
2018-04-30 05:30:00	MSFT	Stock	96.6	96.6	96.6	96.6	500.0
2018-04-30 06:00:00	MSFT	Stock	96.6	96.6	96.6	96.6	405.0
2018-04-30 06:30:00	MSFT	Stock	96.5	96.6	96.5	96.6	200.0
2018-04-30 07:00:00	MSFT	Stock	96.4	96.49	96.25	96.25	2479.0
2018-04-30 07:30:00	MSFT	Stock	96.44	96.49	96.3	96.49	1962.0
2018-04-30 08:00:00	MSFT	Stock	96.4	96.45	96.25	96.42	11477.0
2018-04-30 08:30:00	MSFT	Stock	96.4	96.5	96.18	96.21	35102.0
2018-04-30 09:00:00	MSFT	Stock	96.29	96.29	95.86	96.27	30334.0
2018-04-30 09:30:00	MSFT	Stock	96.27	96.396	95.73	95.79	3171302.0
2018-04-30 10:00:00	MSFT	Stock	95.79	96.0	95.37	95.62	2219694.0
2018-04-30 10:30:00	MSFT	Stock	95.62	95.739	95.4	95.72	1680077.0
2018-04-30 11:00:00	MSFT	Stock	95.73	95.87	95.08	95.08	1895615.0
2018-04-30 11:30:00	MSFT	Stock	95.08	95.085	93.735	93.91	2955979.0
2018-04-30 12:00:00	MSFT	Stock	93.9	93.91	93.15	93.71	2677994.0
2018-04-30 12:30:00	MSFT	Stock	93.7	94.02	93.43	93.746	2107637.0
2018-04-30 13:00:00	MSFT	Stock	93.74	93.94	93.59	93.79	1395496.0
2018-04-30 13:30:00	MSFT	Stock	93.79	94.36	93.73	94.32	1267794.0

> showing 50 of 81,858 rows — these rows as CSV

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