PREVIEW / stock_30min / 2019-05-14

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-14.parquet
  size:    1.7 MB
  rows:    84,007
  symbols: 2,624

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-05-14 04:00:00	AAPL	Stock	46.565	46.735	46.565	46.64	22024.0
2019-05-14 04:30:00	AAPL	Stock	46.625	46.65	46.5775	46.65	16280.0
2019-05-14 05:00:00	AAPL	Stock	46.7	46.75	46.69	46.75	12708.0
2019-05-14 05:30:00	AAPL	Stock	46.725	46.825	46.725	46.8	22092.0
2019-05-14 06:00:00	AAPL	Stock	46.7875	46.8125	46.7625	46.8	16464.0
2019-05-14 06:30:00	AAPL	Stock	46.7925	46.9425	46.7925	46.8625	46796.0
2019-05-14 07:00:00	AAPL	Stock	46.825	47.075	46.79	46.9925	271412.0
2019-05-14 07:30:00	AAPL	Stock	46.9675	46.995	46.7275	46.8125	274340.0
2019-05-14 08:00:00	AAPL	Stock	46.8375	47.075	46.71	46.725	481456.0
2019-05-14 08:30:00	AAPL	Stock	46.7325	46.82	46.625	46.775	275888.0
2019-05-14 09:00:00	AAPL	Stock	46.7975	46.8875	46.555	46.575	523124.0
2019-05-14 09:30:00	AAPL	Stock	46.6025	46.8375	46.3525	46.45	23142064.0
2019-05-14 10:00:00	AAPL	Stock	46.4452	46.9192	46.4452	46.78	11320340.0
2019-05-14 10:30:00	AAPL	Stock	46.7812	46.8325	46.555	46.605	7623932.0
2019-05-14 11:00:00	AAPL	Stock	46.6075	46.9875	46.54	46.93	7969004.0
2019-05-14 11:30:00	AAPL	Stock	46.9225	47.225	46.905	47.1575	8917524.0
2019-05-14 12:00:00	AAPL	Stock	47.1525	47.255	46.9825	47.0582	6659868.0
2019-05-14 12:30:00	AAPL	Stock	47.0725	47.285	47.07	47.1525	5590500.0
2019-05-14 13:00:00	AAPL	Stock	47.155	47.375	47.1535	47.32	5192556.0
2019-05-14 13:30:00	AAPL	Stock	47.32	47.415	47.27	47.3725	4655784.0
2019-05-14 14:00:00	AAPL	Stock	47.375	47.425	47.2175	47.36	5774716.0
2019-05-14 14:30:00	AAPL	Stock	47.3625	47.4058	47.1725	47.245	5222628.0
2019-05-14 15:00:00	AAPL	Stock	47.2425	47.4075	47.1825	47.3675	5406796.0
2019-05-14 15:30:00	AAPL	Stock	47.365	47.3775	47.13	47.1625	11431880.0
2019-05-14 16:00:00	AAPL	Stock	47.18	47.2125	46.9702	47.1525	11171860.0
2019-05-14 16:30:00	AAPL	Stock	47.1525	47.1825	47.125	47.125	36720.0
2019-05-14 17:00:00	AAPL	Stock	47.125	47.125	47.105	47.105	28200.0
2019-05-14 17:30:00	AAPL	Stock	47.105	47.1125	47.05	47.1	34256.0
2019-05-14 18:00:00	AAPL	Stock	47.115	47.185	47.08	47.185	36292.0
2019-05-14 18:30:00	AAPL	Stock	47.185	47.22	47.1625	47.22	26460.0
2019-05-14 19:00:00	AAPL	Stock	47.22	47.25	47.21	47.25	14940.0
2019-05-14 19:30:00	AAPL	Stock	47.2375	47.25	47.225	47.2375	41704.0
2019-05-14 04:00:00	MSFT	Stock	124.01	124.1	123.98	124.0	2961.0
2019-05-14 04:30:00	MSFT	Stock	123.88	124.1	123.88	124.1	1870.0
2019-05-14 05:00:00	MSFT	Stock	124.06	124.15	124.05	124.15	680.0
2019-05-14 05:30:00	MSFT	Stock	124.2	124.2	124.2	124.2	160.0
2019-05-14 06:00:00	MSFT	Stock	124.19	124.37	124.19	124.37	1050.0
2019-05-14 06:30:00	MSFT	Stock	124.36	124.46	124.3	124.4	2700.0
2019-05-14 07:00:00	MSFT	Stock	124.38	124.47	124.11	124.4	12223.0
2019-05-14 07:30:00	MSFT	Stock	124.35	124.44	124.25	124.25	8698.0
2019-05-14 08:00:00	MSFT	Stock	124.3	124.48	123.65	124.3	43549.0
2019-05-14 08:30:00	MSFT	Stock	124.2	124.4	123.9	124.4	23904.0
2019-05-14 09:00:00	MSFT	Stock	124.3	124.42	123.9	123.9	22443.0
2019-05-14 09:30:00	MSFT	Stock	123.87	124.59	123.7	123.93	2752365.0
2019-05-14 10:00:00	MSFT	Stock	123.93	124.99	123.9	124.92	1796951.0
2019-05-14 10:30:00	MSFT	Stock	124.91	125.16	124.68	125.1	1568925.0
2019-05-14 11:00:00	MSFT	Stock	125.11	125.427	124.8	125.22	1652324.0
2019-05-14 11:30:00	MSFT	Stock	125.21	125.71	125.18	125.546	1489742.0
2019-05-14 12:00:00	MSFT	Stock	125.55	125.88	125.26	125.28	1287242.0
2019-05-14 12:30:00	MSFT	Stock	125.28	125.61	125.25	125.325	877824.0

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

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