PREVIEW / stock_30min / 2019-12-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-18.parquet
  size:    1.8 MB
  rows:    86,641
  symbols: 2,517

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-12-18 04:00:00	AAPL	Stock	70.0775	70.095	70.0775	70.095	2000.0
2019-12-18 04:30:00	AAPL	Stock	70.19	70.19	70.19	70.19	672.0
2019-12-18 05:00:00	AAPL	Stock	70.1125	70.1125	69.97	70.05	12804.0
2019-12-18 05:30:00	AAPL	Stock	70.0975	70.1	70.05	70.0925	4984.0
2019-12-18 06:00:00	AAPL	Stock	70.0525	70.0525	70.05	70.05	6940.0
2019-12-18 06:30:00	AAPL	Stock	70.0	70.05	70.0	70.05	5200.0
2019-12-18 07:00:00	AAPL	Stock	70.05	70.0825	69.9375	70.025	52220.0
2019-12-18 07:30:00	AAPL	Stock	70.045	70.08	70.025	70.0625	26784.0
2019-12-18 08:00:00	AAPL	Stock	70.025	70.1025	69.9025	70.07	120452.0
2019-12-18 08:30:00	AAPL	Stock	70.04	70.075	70.0	70.0	66812.0
2019-12-18 09:00:00	AAPL	Stock	70.0	70.09	69.925	69.9475	166648.0
2019-12-18 09:30:00	AAPL	Stock	69.9275	70.12	69.825	69.8542	11841992.0
2019-12-18 10:00:00	AAPL	Stock	69.8525	69.995	69.78	69.96	6670420.0
2019-12-18 10:30:00	AAPL	Stock	69.96	69.975	69.8175	69.9225	4690412.0
2019-12-18 11:00:00	AAPL	Stock	69.92	70.0275	69.8825	69.9475	4167208.0
2019-12-18 11:30:00	AAPL	Stock	69.9458	70.065	69.935	70.015	6426332.0
2019-12-18 12:00:00	AAPL	Stock	70.0175	70.275	70.0175	70.2738	5414460.0
2019-12-18 12:30:00	AAPL	Stock	70.2725	70.3125	70.2128	70.255	3970948.0
2019-12-18 13:00:00	AAPL	Stock	70.2575	70.33	70.2275	70.2575	3875100.0
2019-12-18 13:30:00	AAPL	Stock	70.255	70.371	70.1925	70.3692	3387796.0
2019-12-18 14:00:00	AAPL	Stock	70.37	70.38	70.3175	70.3625	3081188.0
2019-12-18 14:30:00	AAPL	Stock	70.36	70.475	70.36	70.4625	4378800.0
2019-12-18 15:00:00	AAPL	Stock	70.4638	70.475	70.3162	70.335	3846256.0
2019-12-18 15:30:00	AAPL	Stock	70.3338	70.3375	69.8775	69.9275	11755644.0
2019-12-18 16:00:00	AAPL	Stock	69.935	70.0875	69.9	69.9375	15362740.0
2019-12-18 16:30:00	AAPL	Stock	69.925	69.96	69.9125	69.95	170900.0
2019-12-18 17:00:00	AAPL	Stock	69.9375	69.955	69.9375	69.9425	10764.0
2019-12-18 17:30:00	AAPL	Stock	69.95	69.9825	69.94	69.95	54828.0
2019-12-18 18:00:00	AAPL	Stock	69.975	69.9925	69.95	69.9625	22472.0
2019-12-18 18:30:00	AAPL	Stock	69.9625	69.98	69.95	69.9725	11636.0
2019-12-18 19:00:00	AAPL	Stock	69.9525	69.9775	69.9525	69.9775	7192.0
2019-12-18 19:30:00	AAPL	Stock	69.9925	70.0	69.9775	70.0	28684.0
2019-12-18 04:00:00	MSFT	Stock	154.68	154.94	154.68	154.94	945.0
2019-12-18 04:30:00	MSFT	Stock	154.94	154.94	154.94	154.94	100.0
2019-12-18 05:00:00	MSFT	Stock	155.04	155.04	154.91	154.91	1754.0
2019-12-18 05:30:00	MSFT	Stock	155.0	155.0	155.0	155.0	100.0
2019-12-18 06:00:00	MSFT	Stock	154.9	154.9	154.9	154.9	100.0
2019-12-18 07:00:00	MSFT	Stock	154.76	154.8	154.75	154.79	2626.0
2019-12-18 07:30:00	MSFT	Stock	154.8	154.9	154.8	154.89	1230.0
2019-12-18 08:00:00	MSFT	Stock	154.887	154.89	154.75	154.84	6994.0
2019-12-18 08:30:00	MSFT	Stock	154.8	154.8	154.65	154.74	5213.0
2019-12-18 09:00:00	MSFT	Stock	154.74	154.74	154.07	154.46	43321.0
2019-12-18 09:30:00	MSFT	Stock	154.42	154.7	154.18	154.57	1849166.0
2019-12-18 10:00:00	MSFT	Stock	154.57	154.714	154.43	154.71	850573.0
2019-12-18 10:30:00	MSFT	Stock	154.7	155.2	154.63	155.15	1035042.0
2019-12-18 11:00:00	MSFT	Stock	155.15	155.465	155.045	155.43	994729.0
2019-12-18 11:30:00	MSFT	Stock	155.43	155.48	155.1	155.32	1092669.0
2019-12-18 12:00:00	MSFT	Stock	155.316	155.37	155.154	155.2	584569.0
2019-12-18 12:30:00	MSFT	Stock	155.2	155.2	155.0	155.01	490720.0
2019-12-18 13:00:00	MSFT	Stock	155.01	155.12	154.92	154.94	434345.0

> showing 50 of 86,641 rows — these rows as CSV

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