PREVIEW / stock_30min / 2019-06-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-26.parquet
  size:    1.7 MB
  rows:    85,629
  symbols: 2,622

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
2019-06-26 04:00:00	AAPL	Stock	49.0325	49.06	49.0325	49.06	2000.0
2019-06-26 04:30:00	AAPL	Stock	48.9725	49.3	48.9725	49.3	8288.0
2019-06-26 05:00:00	AAPL	Stock	49.255	49.6875	49.2525	49.6875	34160.0
2019-06-26 05:30:00	AAPL	Stock	49.685	49.685	49.625	49.675	17008.0
2019-06-26 06:00:00	AAPL	Stock	49.6925	49.7	49.665	49.665	29532.0
2019-06-26 06:30:00	AAPL	Stock	49.625	49.675	49.505	49.5075	11864.0
2019-06-26 07:00:00	AAPL	Stock	49.57	49.5725	49.4875	49.54	93052.0
2019-06-26 07:30:00	AAPL	Stock	49.54	49.615	49.525	49.545	67504.0
2019-06-26 08:00:00	AAPL	Stock	49.575	49.625	49.46	49.525	213428.0
2019-06-26 08:30:00	AAPL	Stock	49.5125	49.515	49.2825	49.44	234628.0
2019-06-26 09:00:00	AAPL	Stock	49.4175	49.55	49.3782	49.4625	142048.0
2019-06-26 09:30:00	AAPL	Stock	49.4425	50.2375	49.3375	50.2275	18189296.0
2019-06-26 10:00:00	AAPL	Stock	50.2275	50.2475	49.9738	50.0662	7946064.0
2019-06-26 10:30:00	AAPL	Stock	50.0675	50.1375	49.9975	50.057	5541456.0
2019-06-26 11:00:00	AAPL	Stock	50.0525	50.095	49.8925	50.0215	5331152.0
2019-06-26 11:30:00	AAPL	Stock	50.0252	50.16	49.8825	50.1592	5576640.0
2019-06-26 12:00:00	AAPL	Stock	50.1575	50.18	50.0975	50.171	3824624.0
2019-06-26 12:30:00	AAPL	Stock	50.1725	50.23	50.1275	50.13	3403056.0
2019-06-26 13:00:00	AAPL	Stock	50.13	50.1375	50.0	50.0	2342356.0
2019-06-26 13:30:00	AAPL	Stock	50.003	50.03	49.885	49.9575	3696168.0
2019-06-26 14:00:00	AAPL	Stock	49.955	49.9735	49.8325	49.8875	2873748.0
2019-06-26 14:30:00	AAPL	Stock	49.8875	49.9375	49.8225	49.9125	3093068.0
2019-06-26 15:00:00	AAPL	Stock	49.915	50.05	49.8925	49.99	4101544.0
2019-06-26 15:30:00	AAPL	Stock	49.99	50.05	49.9425	49.95	7927244.0
2019-06-26 16:00:00	AAPL	Stock	49.95	50.0	49.9375	49.9675	10265448.0
2019-06-26 16:30:00	AAPL	Stock	49.9675	49.9675	49.895	49.925	214144.0
2019-06-26 17:00:00	AAPL	Stock	49.915	49.945	49.915	49.945	14988.0
2019-06-26 17:30:00	AAPL	Stock	49.9425	49.965	49.94	49.95	26472.0
2019-06-26 18:00:00	AAPL	Stock	49.94	49.965	49.9375	49.9375	10392.0
2019-06-26 18:30:00	AAPL	Stock	49.9375	49.955	49.915	49.955	8068.0
2019-06-26 19:00:00	AAPL	Stock	49.95	49.97	49.95	49.97	7680.0
2019-06-26 19:30:00	AAPL	Stock	49.97	49.9975	49.9525	49.9975	27388.0
2019-06-26 04:00:00	MSFT	Stock	134.0	134.06	134.0	134.0	2225.0
2019-06-26 04:30:00	MSFT	Stock	134.05	134.07	133.95	133.95	700.0
2019-06-26 05:00:00	MSFT	Stock	134.2	135.0	134.2	134.66	1713.0
2019-06-26 05:30:00	MSFT	Stock	134.74	134.76	134.66	134.76	3372.0
2019-06-26 06:00:00	MSFT	Stock	134.95	135.0	134.88	134.9	4340.0
2019-06-26 06:30:00	MSFT	Stock	134.92	134.92	134.62	134.89	5695.0
2019-06-26 07:00:00	MSFT	Stock	134.65	134.9	134.58	134.77	17506.0
2019-06-26 07:30:00	MSFT	Stock	134.77	134.95	134.68	134.77	21171.0
2019-06-26 08:00:00	MSFT	Stock	134.8	134.97	133.76	134.69	43608.0
2019-06-26 08:30:00	MSFT	Stock	134.65	134.69	134.0	134.21	33624.0
2019-06-26 09:00:00	MSFT	Stock	134.27	134.48	134.168	134.44	19600.0
2019-06-26 09:30:00	MSFT	Stock	134.44	135.74	134.35	135.53	3665622.0
2019-06-26 10:00:00	MSFT	Stock	135.53	135.57	134.73	134.87	1504518.0
2019-06-26 10:30:00	MSFT	Stock	134.87	135.12	134.75	135.04	1412581.0
2019-06-26 11:00:00	MSFT	Stock	135.03	135.13	134.665	135.08	955897.0
2019-06-26 11:30:00	MSFT	Stock	135.095	135.12	134.75	134.9	897760.0
2019-06-26 12:00:00	MSFT	Stock	134.92	135.07	134.855	134.995	895920.0
2019-06-26 12:30:00	MSFT	Stock	134.99	135.08	134.84	135.008	665133.0

> showing 50 of 85,629 rows — these rows as CSV

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