PREVIEW / stock_30min / 2018-09-04

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-04.parquet
  size:    1.7 MB
  rows:    84,785
  symbols: 2,797

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-09-04 04:00:00	AAPL	Stock	57.0625	57.175	57.0625	57.1175	26152.0
2018-09-04 04:30:00	AAPL	Stock	57.095	57.125	57.0875	57.125	23136.0
2018-09-04 05:00:00	AAPL	Stock	57.125	57.125	57.075	57.075	16604.0
2018-09-04 05:30:00	AAPL	Stock	57.075	57.0775	57.02	57.0775	9216.0
2018-09-04 06:00:00	AAPL	Stock	57.065	57.085	57.01	57.07	16336.0
2018-09-04 06:30:00	AAPL	Stock	57.065	57.065	56.99	57.0375	11224.0
2018-09-04 07:00:00	AAPL	Stock	57.0125	57.0825	56.9425	56.97	233908.0
2018-09-04 07:30:00	AAPL	Stock	56.955	57.0	56.8875	56.995	91960.0
2018-09-04 08:00:00	AAPL	Stock	57.04	57.08	56.8878	57.01	353720.0
2018-09-04 08:30:00	AAPL	Stock	57.01	57.025	56.965	57.025	144156.0
2018-09-04 09:00:00	AAPL	Stock	57.045	57.1575	56.94	57.1325	299084.0
2018-09-04 09:30:00	AAPL	Stock	57.1225	57.235	56.6575	56.74	18757492.0
2018-09-04 10:00:00	AAPL	Stock	56.74	57.0825	56.73	56.92	9461940.0
2018-09-04 10:30:00	AAPL	Stock	56.92	57.1875	56.865	57.125	7483888.0
2018-09-04 11:00:00	AAPL	Stock	57.1275	57.295	57.0525	57.1625	7501896.0
2018-09-04 11:30:00	AAPL	Stock	57.1625	57.2328	56.9112	56.93	6063664.0
2018-09-04 12:00:00	AAPL	Stock	56.93	56.9775	56.7475	56.82	5635756.0
2018-09-04 12:30:00	AAPL	Stock	56.8225	57.09	56.785	57.0268	4586716.0
2018-09-04 13:00:00	AAPL	Stock	57.0262	57.185	57.0175	57.09	4022568.0
2018-09-04 13:30:00	AAPL	Stock	57.0925	57.15	57.0175	57.1222	3069352.0
2018-09-04 14:00:00	AAPL	Stock	57.1225	57.14	57.0275	57.1112	2718272.0
2018-09-04 14:30:00	AAPL	Stock	57.11	57.145	57.05	57.0975	2733780.0
2018-09-04 15:00:00	AAPL	Stock	57.105	57.13	57.03	57.095	2897052.0
2018-09-04 15:30:00	AAPL	Stock	57.0925	57.1725	57.0425	57.09	7903832.0
2018-09-04 16:00:00	AAPL	Stock	57.09	57.145	57.0625	57.095	8289924.0
2018-09-04 16:30:00	AAPL	Stock	57.09	57.1275	57.09	57.1225	181272.0
2018-09-04 17:00:00	AAPL	Stock	57.1425	57.1425	57.1125	57.1375	8400.0
2018-09-04 17:30:00	AAPL	Stock	57.125	57.1325	57.1125	57.1125	15208.0
2018-09-04 18:00:00	AAPL	Stock	57.09	57.1175	57.075	57.09	23584.0
2018-09-04 18:30:00	AAPL	Stock	57.09	57.125	57.09	57.125	15324.0
2018-09-04 19:00:00	AAPL	Stock	57.125	57.125	57.09	57.1225	11136.0
2018-09-04 19:30:00	AAPL	Stock	57.1125	57.1125	57.09	57.1125	19204.0
2018-09-04 04:00:00	MSFT	Stock	113.0	113.0	112.85	112.85	8740.0
2018-09-04 04:30:00	MSFT	Stock	112.8	112.8	112.8	112.8	100.0
2018-09-04 05:30:00	MSFT	Stock	112.56	112.56	112.5	112.5	425.0
2018-09-04 06:30:00	MSFT	Stock	112.4	112.4	112.35	112.35	1152.0
2018-09-04 07:00:00	MSFT	Stock	112.48	112.48	112.3	112.4	4093.0
2018-09-04 07:30:00	MSFT	Stock	112.12	112.12	111.93	111.93	2922.0
2018-09-04 08:00:00	MSFT	Stock	112.1	112.8	111.92	112.15	4069.0
2018-09-04 08:30:00	MSFT	Stock	112.12	112.33	112.01	112.33	4103.0
2018-09-04 09:00:00	MSFT	Stock	112.02	112.13	110.75	110.82	137544.0
2018-09-04 09:30:00	MSFT	Stock	110.85	111.61	110.22	111.045	4338458.0
2018-09-04 10:00:00	MSFT	Stock	111.05	111.5	111.045	111.285	1562842.0
2018-09-04 10:30:00	MSFT	Stock	111.29	111.87	111.2	111.785	1266410.0
2018-09-04 11:00:00	MSFT	Stock	111.78	111.955	111.61	111.815	995776.0
2018-09-04 11:30:00	MSFT	Stock	111.82	111.89	111.24	111.28	975967.0
2018-09-04 12:00:00	MSFT	Stock	111.274	111.506	111.06	111.225	1053811.0
2018-09-04 12:30:00	MSFT	Stock	111.225	111.32	111.1	111.195	859253.0
2018-09-04 13:00:00	MSFT	Stock	111.19	111.4	111.15	111.36	580479.0
2018-09-04 13:30:00	MSFT	Stock	111.36	111.46	111.15	111.26	744521.0

> showing 50 of 84,785 rows — these rows as CSV

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