PREVIEW / stock_30min / 2017-10-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-20.parquet
  size:    1.6 MB
  rows:    83,192
  symbols: 2,948

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
2017-10-20 04:00:00	AAPL	Stock	39.05	39.1875	39.05	39.175	4632.0
2017-10-20 04:30:00	AAPL	Stock	39.125	39.15	39.1225	39.15	2200.0
2017-10-20 05:00:00	AAPL	Stock	39.1625	39.1625	39.145	39.145	4000.0
2017-10-20 05:30:00	AAPL	Stock	39.145	39.1625	39.125	39.125	2488.0
2017-10-20 06:00:00	AAPL	Stock	39.175	39.185	39.175	39.175	11232.0
2017-10-20 06:30:00	AAPL	Stock	39.175	39.175	39.15	39.1525	7600.0
2017-10-20 07:00:00	AAPL	Stock	39.175	39.1875	39.0775	39.0775	61596.0
2017-10-20 07:30:00	AAPL	Stock	39.1	39.1625	39.0775	39.1375	97304.0
2017-10-20 08:00:00	AAPL	Stock	39.175	39.175	39.0875	39.1625	223444.0
2017-10-20 08:30:00	AAPL	Stock	39.1625	39.165	39.1375	39.15	110168.0
2017-10-20 09:00:00	AAPL	Stock	39.15	39.3	39.15	39.225	744344.0
2017-10-20 09:30:00	AAPL	Stock	39.2275	39.2975	39.1325	39.2075	14097976.0
2017-10-20 10:00:00	AAPL	Stock	39.21	39.4298	39.205	39.4125	9639336.0
2017-10-20 10:30:00	AAPL	Stock	39.4125	39.4375	39.295	39.33	5612660.0
2017-10-20 11:00:00	AAPL	Stock	39.33	39.38	39.1775	39.31	8048352.0
2017-10-20 11:30:00	AAPL	Stock	39.3125	39.37	39.2875	39.369	3444248.0
2017-10-20 12:00:00	AAPL	Stock	39.3675	39.375	39.2975	39.3445	2552908.0
2017-10-20 12:30:00	AAPL	Stock	39.3438	39.37	39.3025	39.36	2879032.0
2017-10-20 13:00:00	AAPL	Stock	39.355	39.3675	39.335	39.3625	1826108.0
2017-10-20 13:30:00	AAPL	Stock	39.3608	39.3675	39.2925	39.3	2195452.0
2017-10-20 14:00:00	AAPL	Stock	39.3	39.3125	39.23	39.2325	3339228.0
2017-10-20 14:30:00	AAPL	Stock	39.235	39.2525	39.1875	39.2	3595204.0
2017-10-20 15:00:00	AAPL	Stock	39.2	39.2175	39.1125	39.1213	3757832.0
2017-10-20 15:30:00	AAPL	Stock	39.1275	39.1325	38.99	39.0625	12759972.0
2017-10-20 16:00:00	AAPL	Stock	39.055	39.0625	39.0275	39.05	12555024.0
2017-10-20 16:30:00	AAPL	Stock	39.055	39.065	39.04	39.05	132168.0
2017-10-20 17:00:00	AAPL	Stock	39.0525	39.0725	39.05	39.0725	54648.0
2017-10-20 17:30:00	AAPL	Stock	39.065	39.065	39.0325	39.0375	28172.0
2017-10-20 18:00:00	AAPL	Stock	39.06	39.06	39.04	39.0575	20000.0
2017-10-20 18:30:00	AAPL	Stock	39.0425	39.06	39.0425	39.06	2928.0
2017-10-20 19:00:00	AAPL	Stock	39.0575	39.0575	39.055	39.055	12224.0
2017-10-20 19:30:00	AAPL	Stock	39.055	39.0625	39.045	39.06	16296.0
2017-10-20 07:00:00	MSFT	Stock	78.06	78.06	78.06	78.06	168.0
2017-10-20 07:30:00	MSFT	Stock	78.08	78.15	78.08	78.15	725.0
2017-10-20 08:00:00	MSFT	Stock	78.15	78.21	78.11	78.21	2877.0
2017-10-20 08:30:00	MSFT	Stock	78.21	78.36	78.19	78.36	1420.0
2017-10-20 09:00:00	MSFT	Stock	78.25	78.43	78.21	78.26	99819.0
2017-10-20 09:30:00	MSFT	Stock	78.32	78.52	78.22	78.51	3166541.0
2017-10-20 10:00:00	MSFT	Stock	78.505	78.57	78.4	78.435	1161185.0
2017-10-20 10:30:00	MSFT	Stock	78.43	78.48	78.315	78.395	919390.0
2017-10-20 11:00:00	MSFT	Stock	78.4	78.64	78.395	78.61	968779.0
2017-10-20 11:30:00	MSFT	Stock	78.605	78.76	78.58	78.72	879522.0
2017-10-20 12:00:00	MSFT	Stock	78.73	78.83	78.71	78.796	700859.0
2017-10-20 12:30:00	MSFT	Stock	78.79	78.9	78.71	78.9	798336.0
2017-10-20 13:00:00	MSFT	Stock	78.9	78.91	78.78	78.845	745269.0
2017-10-20 13:30:00	MSFT	Stock	78.85	78.93	78.81	78.91	683792.0
2017-10-20 14:00:00	MSFT	Stock	78.905	78.97	78.88	78.91	556220.0
2017-10-20 14:30:00	MSFT	Stock	78.91	78.93	78.77	78.815	821385.0
2017-10-20 15:00:00	MSFT	Stock	78.81	78.84	78.68	78.69	910478.0
2017-10-20 15:30:00	MSFT	Stock	78.68	78.82	78.68	78.8	2769460.0

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

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